Excel Date problem on Web

Hi,

When my report o/p in CSV - Date field EXDJ = 12/21/2040 is Displayed as 12/21/1940 in Excel o/p on Web,But on my local it works fine.Thanks in advance.

Can someone please help me

Version - E8.10
Tools - 8.96

Thanks,
reddy

Try This post.someone already answered it for u in jde list.

http://www.jdelist.com/ubb/showflat.php?Cat=0&Board=Apps&Number=145505&Forum=All_Forums&Words=Date&Searchpage=0&Limit=25&Main=145475&Search=true&where=bodysub&Name=&daterange=1&newerval=1&newertype=y&olderval=&oldertype=&bodyprev=#Post145505

Hi Reddy, sam123,

The pointed post mentions only DCYR Data Item, but ther is an other CENTCHG DD Item too.

I do not know, OW where use one, and where the other to determine the centery, when the year entry is 1 or 2 digit (Forms, Processing Options, Grid Import, Date Conversions, etc.)

Please, check the following threads too:

Export grid to Excel with 2 digit year interpretation
Date Fields problem
Calendar returns wrong century

Regards,

Zoltán

Hi,

We use CENTCHG to determine the century, but now I confused seing the DCYR field.

Somebody help us to clarify?

Thanks in advance

Did you get fix for this ???