date formats in queries

[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

 

[fredg]

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

[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

 

[Lord Kelvan]

ummm i think he wants

ShowMonthyear:Format([Date Marked],"mmm yy")

 

[fredg]

ummm i think he wants

ShowMonthyear:Format([Date Marked],"mmm yy")

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