Trying to convert "M" month field into "MM&qu

[Richcta]

This expression: Expr1: Month([tbl_ridedata]) strips out the month from a date field. the date field appears as M/D/YYYY. I need the month to be MM as in January being 01, etc. I usually work in PL/SQL and am under a time deadline so any help from anyone is appreciated.

 

[Norie]

I don't understand 100% what you mean but have you looked at the Format function?

Expr1:Format([tbl_ridedata], "MM")

 

[Richcta]

Norie:

The current query is an insert query. It takes the month part of the date and inserts it into another table. A change was made somewhere without informing those responsible for the tables and programs and a problem arose. the table the data is inserted since the change now has month in the MM AND M formats. Some of our queries and insert code is not working because of the change. We need to make that M an MM for this reason. I will try your suggestion. Thanks.

 

[Richcta]

Its invalid syntax. I need the month stripped out in "MM" format. this gets inserted into another table.

 

[Norie]

What do you mean?

Where are you trying to use this? In an Access query?

 

[Richcta]

Yes. The access query takes the month part of the date field and inserts it via ODBC into a PL/SQL table. We cannot select on the PL/SQL table because the month field (composed of the month part of the date field in the access table) is a mixture of M and MM. Therefore when we take out the month part of the date field in the Access table they all need to be MM format months.