Date getting converting to Text Date

Hi,

I am trying to change date format from MM/DD/YYYY to MM/DD/YY. I am using source as well as target as text file. I am using reformat date option. But in the output excel, date is being shown in Text Date format. Hence I am losing information about the century.

For example when I am converting 12/02/1994 to 12/02/94, in the output excel there is no way for me to tell whether date was 12/02/1994 or 12/02/2004. I want the information of the century to be retained and just the format of the date to change. IS there any way I can achieve that?

Thanks,

Ayush

You need to make sure that your date is in yyyy-mm-dd hh:mm:ss format.
Tnan it will be treated as date when inserted into excel.

To change date format:
Click on writer tab
Click Show Definition
Select desired format ot just enter it

Hi Peter
Tried that, I am getting 01/00/00 for all the observations now.

Works fine here.
I used 'Date format' fuction and not 'Reformat date'

Hi Peter,

Can you please share the snaps of your method.

Thanks

Ayush

Here they are