Display records from the last year

[ToshTrent]

Hi,

What's the best method to get all records which were created within the last year?

>=Date()-365 ? Or is there a more professional method?

Cheers
Tosh

 

[PHV]

To deal with lap years:
>DateSerial(Year(Date)-1, Month(Date), Day(Date))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ToshTrent]

Brill thanx PHV!

[red]
Thankyou[/red]
Matt