Calculation: formatdate(s,d)

[Charlie775]

Hi,

Just having a problem getting the formatdate functon to work.  I have a datetime info field and I would like my calculation to format the date in ISO 8601 format.

The datetime field is C3 and the syntax I am using in the Eval expression box is

Code: [Select]

formatdate('yyyy/mm/dd', C3)
When the value of C3 is 30-04-2008 the calculation field does not display anything

Any hints appreciated

Charlie

[RTT]

You should convert first the text of the C3 field to a datetime value.
Try this way:

Code: [Select]

formatdate('yyyy/mm/dd', date(C3))