RTTSoftware Support Forum

PDF Explorer => General => Topic started by: Charlie775 on May 28, 2010, 04:12:21 AM

Title: Calculation: formatdate(s,d)
Post by: Charlie775 on May 28, 2010, 04:12:21 AM

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

Title: Re: Calculation: formatdate(s,d)
Post by: RTT on May 28, 2010, 08:04:03 AM

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))