Depreciation Schedule

[Bob Barnes]

Does 'Now()" or "Date" have a value that represents
a Month Value..IE, Aug 2006 = 234, Aug 2007 = 246..

I would use this in a straight-line 60-month Depreciation.

TIA - Bob

 

[Kerry]

Hi Bob,

I believe what you want to do is use the DateDiff function. For
months:
DateDiff("m",[YOUR_DATE],Date())

 

[Bob Barnes]

Kerry - Thank you.

Not sure if this is exactly what I need....if Equipment is bought on
7/30/07, and the date is 9/2/07....I'll try it...would "m" = 2???

Bob

Hi Bob,

I believe what you want to do is use the DateDiff function. For
months:
DateDiff("m",[YOUR_DATE],Date())

Does 'Now()" or "Date" have a value that represents
a Month Value..IE, Aug 2006 = 234, Aug 2007 = 246..

I would use this in a straight-line 60-month Depreciation.

TIA - Bob

 

[Kerry]

Hi Bob,

Yes, DateDiff("m",#7/30/2007#,#9/2/2007#)=2

Kerry - Thank you.

Not sure if this is exactly what I need....if Equipment is bought on
7/30/07, and the date is 9/2/07....I'll try it...would "m" = 2???

Bob

Hi Bob,

I believe what you want to do is use the DateDiff function. For
months:
DateDiff("m",[YOUR_DATE],Date())