date formats in queries

  • Thread starter Thread starter Alexey
  • Start date Start date
A

Alexey

Hi

Using MonthID: Month([Date Marked]) in a query would give me the month of
the [date marked] field in numeric format -e.g. 9 for Septmeber. Is it
possible to adjust the query so that I can display the date as Sep 08 ?

Thanks

A
 
Hi

Using MonthID: Month([Date Marked]) in a query would give me the month of
the [date marked] field in numeric format -e.g. 9 for Septmeber. Is it
possible to adjust the query so that I can display the date as Sep 08 ?

Thanks

A
Click to expand...

[Date Marked] is a Date Datatype field?
If so....
ShowMonthDay:Format([Date Marked],"mmm dd")

You do not need to do this in the query. You can do this directly on a
form or in a report.
Simply set the Format property of this date control to
mmm dd
 
ummm i think he wants

ShowMonthyear:Format([Date Marked],"mmm yy")
Click to expand...

Perhaps. You may be correct.
Then again, perhaps not.
It's Alexey's responsibility to make his question clear, not ours to
guess. ;-)
 
Back
Top