Date is in short form in Database, how to have the "Month" shown as

[TracyYu]

(subject con't) charactors in Report?

Please help!

I have a database which has a field: QUARTER, with datatype as Date/Time short form (mm/dd/yyyy). I need to output the month in the following form in a report:

January To "Current month" "current year"

It will always start from January of the current year, and "current month" is the month the report is produced, for example, it is February now, and if a report is produced this month, in the report it should show:

January To February 2004

As of now, I have a query for that report, where it prompts the user the starting date (e.g. 1/1/2004), and ending date (e.g. 2/9/2004), but how to get it to show January when the date start with 1/**/****, February when the date starts with 2/*******, etc.?


No IT personnel in our department, I'm a beginner, so when you post your answers please be very specific as how and where should I do what. Thank you in advance!!!

Tracy

 

[LNBruno]

Use the Format method:

=format(dtStart, "mmmm/yyyy")

< M!ke >

 

[SteveR77]

Tracy,

You will need to use the Format option with your date field where the dates are stored.

If you add another field to your query that looks like what is below you should have what you are after -

MonthName: Format([TracyDate],&quot;mmmm&quot

HTH,

Steve