I have a datetimestamp field of type Date/Time in a table, which is updated with the default value, Now() from the system clock when a record is created. I want to show in query and report when a record was created or entered.
I have tried the following datediff statement to show entries that have been made in the last 90 days, but I get no results.
Can you help?
John
I have tried the following datediff statement to show entries that have been made in the last 90 days, but I get no results.
Code:
DateDiff("d",Date(),[table1]![DateTimeStamp)>=90
John