INTERACT FORUM

More => Old Versions => Media Center 12 (Development Ended) => Topic started by: robydago on April 11, 2007, 02:57:58 pm

Title: Strange dates...
Post by: robydago on April 11, 2007, 02:57:58 pm

Field(Date) -- FormatDate(Field(Date), yyyy-MMM-dd, nodate)

if XP is set (Standards and Formats) in English, MC gives

1/4/2004 9:35 AM -- 1899-Dec-31

if XP is set in Italian, MC gives:

4/1/2004 9:35 -- 1900-gen-03

The Field(Date) output is always correct, but the FormatDate(Field(Date), yyyy-MMM-dd, nodate) is wrong in both cases...

Any idea, please?

ps. -gen-=January

Title: Re: Strange dates...
Post by: marko on April 11, 2007, 04:30:02 pm

formatdate([date,0],yyyy-MMM-dd,nodate)

:)

Title: Re: Strange dates...
Post by: robydago on April 11, 2007, 05:10:14 pm

thanks marko!
it works now

while you're at it, can you please solve my 'sorting "international" months' problem?:
http://yabb.jriver.com/interact/index.php?topic=39968.msg272414#msg272414