Calc Field Help Please!

[Totes]

Hi,

I have a field called next reporting date, it is a dropdown calendar.

I have the following calc in a field called overdue:

If(Next_Reporting_Date < Get ( CurrentDate ) ; " Overdue" )

I have it set not to store and show as text.

(based on todays date of 7/2/2007)If the reporting date 7/1/2007 the Overdue message will be displayed...if the next reporting date is 7/3/2007 the field is blank.

Until you move the next reporting date up to the 14th or 15th or 16th or 17 or 19th, the Overdue message will appear, if I advance the next reporting date to the 20th the field becomes blank again.

Any suggestions as to why the message shows up on the 14th - 19th?

Thanks,

James

[The Shadow]

Next_Reporting_Date needs to be of type "Date".

[Totes]

Boy do I feel dumb!!! That was just something I overlooked.

Thanks for the info.

James

Edited July 3, 2007 by Guest