Substrings in a date
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 53
- Joined: Fri Apr 18, 2008 8:13 am
- Location: United States
Hi,
If you are sourcing from a Sequential File, goto the file properties tab where you will find a DATE sub-tab. Browse that tab and you will find 'FORMAT' option. If you click it, you will be able to see the format of your date field. By default it is 'mm/dd/yyyy'. You can change this format to whatever format you want.
Other approach to your problem can be, try converting your source DATE to CHAR and then apply the Substrings() you want on it.
If you are sourcing from a Sequential File, goto the file properties tab where you will find a DATE sub-tab. Browse that tab and you will find 'FORMAT' option. If you click it, you will be able to see the format of your date field. By default it is 'mm/dd/yyyy'. You can change this format to whatever format you want.
Other approach to your problem can be, try converting your source DATE to CHAR and then apply the Substrings() you want on it.
Regards
Ajay
Ajay