File Type Defaults Timestamp

jagadam · Post by **jagadam** » Wed Sep 01, 2010 9:10 am

HI I have the following data coming from file 2/2/01 0:00:00. I have specified in Typedafaults under timestamp as %m/%dd/%yy %h:%nn:%ss ..I have to get result as 2001-02-02 00:00:00 but instead I am getting 1901-02-02 00:00:00as this ... Any idea what can be done on this

Quick reply is appreciated

ray.wurlod · Post by **ray.wurlod** » Wed Sep 01, 2010 4:22 pm

%2000yy

jagadam · Post by **jagadam** » Thu Sep 02, 2010 8:19 am

Hi Ray ,
your suggestion worked for me but it created a new problem

for year 00 its giving 2100 instead of 2000

for others 01,02 it did worked from 1901,1902 to 2001 ,2002 etc

Is there anything that can be done to solve 00 apart from xfm

Thanks
Jagadam

jagadam · Post by **jagadam** » Thu Sep 02, 2010 8:50 am

Well, I Tried with 1999 and it worked .. Thanks