View previous topic :: View next topic
|
Author |
Message |
jaspal
New User
Joined: 22 May 2007 Posts: 68 Location: mumbai
|
|
|
|
We have one file , in which we have to append the current date during run time.
we can do this using the DATE1 fuction in sort
Code: |
SORT FIELDS=COPY
OUTREC FIELDS=(DATE1,1,10)
|
but the date appended is in yyyymmdd format.
Any idea how do can we get it in ddmmccyy format?
regards,
Jaspal |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Jaspal,
Assuming that you want the ddmmyyyy date followed by bytes 1-10 of the input record, you would use these DFSORT statements:
Code: |
SORT FIELDS=COPY
OUTREC BUILD=(1:DATENS=(DM4),1,10)
|
Note: The syntax you showed was incorrect. I corrected it. |
|
Back to top |
|
|
patypaz
New User
Joined: 21 Jun 2007 Posts: 2 Location: Brazil
|
|
|
|
Thank you!
Great work!!!! |
|
Back to top |
|
|
|