Author Topic: Calculation: formatdate(s,d)  (Read 5329 times)

0 Members and 1 Guest are viewing this topic.

Charlie775

  • Newbie
  • *
  • Posts: 2
Calculation: formatdate(s,d)
« 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

RTT

  • Administrator
  • *****
  • Posts: 907
Re: Calculation: formatdate(s,d)
« Reply #1 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))