Notice that with these:
Ctod("2/1/2000 02:00", "d/m/y")[/SIZE][/SIZE][/CODE]They return February 1st, 2000 and January 2nd, 2000. The formatting string isn't meant for you to specify the output format, it's for you to tell Monarch the format of the input.
That's why this expression:
The optional date/time parameter functions similarly, in that you need to tell Monarch how to treat your string. So for the example:
The others fail because the supplied string isn't in the expected format. That is, only a date, only a time, and a time followed by a date, respectively.
A little clearer now, hopefully?