Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate days between records and between two columns in the gro 7
Determining EVERY month between 2 given dates 13
Macro for Dates 5
Date calculation on 2 fields 5
Excel Vba to change displayed year automatically. 14
Return multiple records from a single entry. 2
Date Groups 1
Obtain Top Value from Table 9

Back
Top