Change date dynamically

Topic

New Reply

Good Day everybody!

I have Report that has Date field and every year I am changing the criteria to the #>12/31/previous year#

How can I make it dynamic so it will work without manual intervention? Thanks

P.S. I have a form, I can add text box with =Format(Year(Date())) to get current year.
However my DT field has date entered in a format as 4/20/2009.
I will have to read last 4 characters and compare to the Year on the form…I can’t figure it out…

Reply | Quote

Replies

Try

>DateSerial(Year(Date())-1,12,31)

or

>DateSerial(Year(Date()),1,0)

Reply | Quote

Thanks, I totally forgot about DateSerial…

Reply | Quote

I have another Date issue.
I need to have my display date to be = to the last day of the month.

Like today I would like to see April, 30 2009

Thanks

Reply | Quote

You could use a text box with the following control source:

=Date()-Day(Date())

Reply | Quote

Or you could use
DateSerial(Year(Date()),Month(Date()),0)

Reply | Quote