Date and Time Help

  • Thread starter Thread starter Tony Schlak
  • Start date Start date
T

Tony Schlak

I have a form that already has three drop down menus and the users have
asked for a fourth that has month and year. On the table i have a field that
stores the exact date and time the record was created, using
CurrentTimeAndDate. I was wondering if someone has any suggestions on how to
form a query that limited the date entry to mm/yyyy instead of mm/dd/yyyy
xx:xx am/pm. I would like the ablility to have the months that reside in the
table to only show.

Also is there a way to change CurrentTimeAndDate to mm/dd/yyyy right now it
has the month as just 6 instead of 06 for the month of June.

Thanks,
Tony
 
Leave the data entry alone- it's working. But you can extract just the month
and/or year from that value using the Month() and Year() functions. As in:

select month([your date field]) & "/" & year([your date field])
from YourTable

and this will give you a date display format of 'mm/yyyy'.
 
Back
Top