Page 1 of 1
date value
Posted: Mon May 14, 2012 8:02 pm
by hargun
Hi,
I have create a column name EFFT_DT (DATE) and i enter 2011-04-03 in dummy flat file in notepad but its showing values like 40240 in sequential when i try to view data.i want 2011-04-03.Can someone helps me on this.
Re: date value
Posted: Mon May 14, 2012 8:10 pm
by SURA
Share the settings you made in the Sequential file stage?
Posted: Tue May 15, 2012 12:30 am
by ray.wurlod
Date data type will be converted to an internal format when processed by the import operator. How are you determining that the value is 40240? (Don't believe everything you read in newspapers or the data browser.)
Posted: Tue May 15, 2012 7:19 am
by hargun
hi sura,
here is sequential file settings
Record level
Final delemiter :none
Field level
Delemiter : |
Quote :none
Hi ray,
I get to know that value of date when i copy the records from spreadsheet to notepad in notepad its showing that values wheres i enter the yyyy-mm-dd format in spreadsheet.I use spreadsheet for creating file
Posted: Tue May 15, 2012 4:42 pm
by ray.wurlod
Excel also stores dates in a numeric format. You have to specify the cell format to get it to display (or dump) in any other format.
Posted: Tue May 15, 2012 8:23 pm
by ankursaxena.2003
When you import the file in Excel at that time select EFFECTIVE_DT as TEXT columns and not General.
And try to open the file in Textpad or Notepad and I think it should show you the correct date as in the Source file.