Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[robydago]

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

[marko]

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

[robydago]

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