Date and Time Help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tony Schlak - 19 Jul 2005 19:12 GMT

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

Reply to this Message

Chaim - 19 Jul 2005 19:29 GMT

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'.

Signature

Chaim

> 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
[quoted text clipped - 9 lines]
> Thanks,
> Tony

Reply to this Message