Formatting a Date Field

daniel · Post by **daniel** » Mon Jan 26, 2009 8:29 pm

I have a date field that can either be mm/dd/yyyy or mm/dd/yy and in either case i want to convert this to a string of mmddyy. Is there a formatting date option that i can use?

Me_again · Post by **Me_again** » Mon Jan 26, 2009 9:38 pm

Is it text? If so you can do this:

Code: Select all

//Works with 01/31/2009 or 01/31/09 dates
Let>mydate=01/31/2009
StringReplace>mydate,/,,date2
Len>date2,mylen
If>mylen=6
Let>newdate=date2
Goto>alldone
EndIf
Midstr>date2,1,4,newdate
Midstr>date2,7,2,yy
ConCat>newdate,yy
Label>alldone
MDL>newdate

If you are going to eventually sort/index by the dates then yyyymmdd is a more useful format.