Date Format

  • Thread starter Thread starter Krish
  • Start date Start date
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.
 
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.
 
Back
Top