G Guest Dec 12, 2003 #1 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
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 Dec 12, 2003 #2 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.
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.
