Date

G

George Schneider

Is their a way given a user suplied date field and take a look at it and take data from the last day of the previous month based on the user entered date. 10/01 and 10/15 would look at 9/30 for example
 
K

Ken Snell

Assuming that your field is named DateField:

DaetOfLastDayOfPreviousMonth = DateSerial(Year([DateField]),
Month([DateField]), 0)


--
Ken Snell
<MS ACCESS MVP>

George Schneider said:
Is their a way given a user suplied date field and take a look at it and
Click to expand...
take data from the last day of the previous month based on the user entered
date. 10/01 and 10/15 would look at 9/30 for example.
 
Top