Month calculation

[Steven H. Blackwell]

Try the Data function Month(CurrentDate)

Old Advance Man

[andygaunt]

Hi,

Try this.

CurrentMonth Field (calculation, number)

Month(Status(CurrentDate)).

Turn off the storage option so it is always correct every time you open the database.

This should work on your system as the database is using your system formats.

Another option is a global number field that you set via a startup script.

Set Field CurrentMonthGlobal, Month(Status(CurrentDate))

[Bikeman17]

Hi

I want to get the current month as calculation and the calculation result is number.

Something like this...

2002/02/01...2002/02/28

I've been able to program a current month calculation. However, new computers use a new date format which begins with the year. I tried to modify the calculation but the result was a mess.

Thank you