Display Period From Date

[q582gmzhi]

Hi,

I am looking for guidance on how to get a query field to display a numeric period from an existing field that contains a date.

ie:

01/01/2005 = 1 (1st Month)
01/05/2005 = 5 (5th Month)

Etc.

Thanks

Darrell...

 

[Ukraine82]

Make an expression field;

Month([Fielddate])

hth,
Michael

 

[q582gmzhi]

Thanks,

Will try it.

Daz..