convert mm/dd/yyyy to yyyy-mm-dd

[LoneReaper]

i would like a calulated field called "RW_dateentered" to convert a field called "HB_dateadded" like in the subject. i tried

Right( DateAdded , 4 ) & "-" & Middle( DateAdded, "3" , 2 ) & "-" & Left( DateAdded , 2 )

but it doesnt work. any ideas?

[kiwiora]

I'm not sure about swapping the format of them around, except for altering the display via custom date display. I have found to convert / to - you could try substitute command

(Substitute({fieldname},"/","-"))

[-Queue-]

Make your calculation field a text result if you want to use a nonstandard date format for exporting to another type of db, etc.

[BobWeaver]

Assuming that DateAdded is a date field and not a text field.....

Option 1:

You can just custom format the date field to display yyyy-mm-dd. Plunk the DateAdded field onto your layout and select the date options in the format menu.

Option 2:

If you want to do it the hard way, then you can use this formula:

Year(DateAdded)&"-"&Month(DateAdded),&"-"&Day(DateAdded)

The calculation result should be set to text.

[LoneReaper]

Thanks Guys!