Date Format

K

Krish

One of the fields in an attached table, the year and month is written as
yy-mm.(99-01,99-02,99-3....03-04,03-05,03-06....04-07,04-08,04-09). I want
to convert into mm/yyyy format. The formula Exp1:Format([Period],"mm/yyyy")
does not give correct results. The same incorrect information is received
when Datepart is used. Any suggestion is very much appreciated.
 
J

JL

I guess that the field is "text" and not "Date/Time" type.
Try this:

format(Format(table_field, "mm-yy"), "mm/yyyy")

Hope this will help.
 
Top