date format

[Anonymous]

hi,

i have feild like this "yymm" (1401)

how can i chenge it to the lest day of the month in this format :  "dd-mm-yyyy "

in the exm. it should be 31-01-2014.

thanks'

yarin.

[#2 · Accepted solution]

Try this:

=Date(MonthEnd(Date(Date#(TestDate,'YYMM'),'MM-YYYY')),'DD-MM-YYYY')

[jagannalla]

Hi,

Try this

Load

Date(MonthEnd(MakeDate(Left(DateField,2),Right(DateField,2))),'DD-MM-YYYY') as Date

from table

Cheers!!

Jagan