IBM Mainframe Forum

[praveen_nayak17]

Hi All,

Could anyone help to subtract one day from a date filed(in YYYYMMDD format) in input file and write it in output file using sort???

Below is the sample file having date:
20090526
20090525

Expected output file should have records as
20090525
20090524

Thank you ...
Praveen Nayak

[Alissa Margulies]

Hello Praveen.

At this time, SyncSort does not have a special function to perform arithmetic on input date fields. We can only provide offsets to the current system date. However, I would be happy to speak with development to see if this can be incorporated into a future release of the product.

Regards,

[arcvns]

I would be happy to speak with development to see if this can be incorporated into a future release of the product.

Looking forward to see that one in SyncSort.