Last day of the previous month access 1

[teqtaq]

I need to have a text box with

label: Report Printed as of
and text box: last day of the previous month

Thanks

P.S. I wanted to use DateSerial(Year([MyDate]), Month([MyDate]) + 1, 0) - however I am placing it on form and i don't have MyDate.

thanks again

 

[lameid]

Use the date function instead of a field?

 

[teqtaq]

lameid,
if you mean like this
DateSerial(Year([Date()]), Month([Date()]) + 1, 0)
it asks for the parameter...

 

[lameid]

Square brackets are for tables and fields not functions...

DateSerial(Year(Date()), Month(Date()) + 1, 0)

 

[teqtaq]

Oy! Working, thanks so much!

 

[MichaelRed]

... but it is (or at least MAY BE a 'lie'? when you say printed as of date and it is printed any other date - you give the WRONG information!!!!!

At best (if the report actually concerns data from that date) you loose the capability of distingusing which version (of possible multiple copies) is the most recent. At worst (the report reflects data to date) you end up with two reports reflecting different data but claiming a common origin!!!

no good seems to be available from either, while some benefit appears to be available from using the actual (real and unvarnished) information.

of course, if the data does reflect a specific cutoff date or date range, these should be shown, but NOT as the date printed.




MichaelRed