How can I get the current date in the format dd.mm.jjjj



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

How can I get the current date in the format dd.mm.jjjj

Postby sascha_wob » Mon Feb 10, 2014 4:35 pm

Hi volks,

how can I get the current date in the format dd.mm.jjjj in a INREC sort statement?
At the following statements I've tried to get the date starting at column 94:

94:DATE1(.), --> 2014.02.10 (wrong placements)

94:DATE=(DMY.), --> 10.02.14 (but the year ist only 2 digits long - it must be 4 digits.

It would be helpful if I can extract those parts from the current date, too:

dd
mm
yyyy

So I can put it with a c'.' together ;)

Have anybody an idea how I can solve the problem without doing 2 sort steps?

Thank you for your help!

Kind regards

Sascha
sascha_wob
 
Posts: 2
Joined: Mon Feb 10, 2014 4:15 pm
Has thanked: 1 time
Been thanked: 0 time

Re: How can I get the current date in the format dd.mm.jjjj

 

Re: How can I get the current date in the format dd.mm.jjjj

Postby skolusu » Mon Feb 10, 2014 11:21 pm

sascha,

94:DATE=(DM4.)


will give you the date as dd.mm.ccyy format
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

These users thanked the author skolusu for the post:
sascha_wob (Tue Feb 11, 2014 1:02 am)
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times

Re: How can I get the current date in the format dd.mm.jjjj

Postby sascha_wob » Tue Feb 11, 2014 1:03 am

Super! That works fine! Thanks a lot!
Best regards
Sascha
sascha_wob
 
Posts: 2
Joined: Mon Feb 10, 2014 4:15 pm
Has thanked: 1 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post