Adding date parameter to batch file

Childrensmn · Post by **Childrensmn** » Thu Feb 25, 2016 12:33 pm

Hi,

We get daily file with change in date. Example:Today's file: FILE_NAME_20160225.txt.
I will be passing this as a parm in datastage job.

TodaysDate = Oconv(Date(), "DYMD[4,2,2]");
FileString1 = 'FILE_NAME_':TodaysDate:'.txt'

I am getting date in YYYY/MM/DD format instead of YYYYMMDD format.

The above code returns: FILE_NAME_2016/02/25.txt.

Please let me know how to get the right formatted date: FILE_NAME_20160225.txt.

Thanks!!

chulett · Post by **chulett** » Thu Feb 25, 2016 2:23 pm

Use the Convert() function to strip them from the field by replacing them with '' - an empty string.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 25, 2016 2:34 pm

Code: Select all

Oconv(Date(), "DYMD[4,2,2]" : @VM : "MCN")

Childrensmn · Post by **Childrensmn** » Thu Feb 25, 2016 2:43 pm

This did it. Thanks!!

chulett · Post by **chulett** » Thu Feb 25, 2016 3:06 pm

Do you understand how that 'did it'?

ray.wurlod · Post by **ray.wurlod** » Thu Feb 25, 2016 4:38 pm

I have explained the technique in the past on DSXchange. If there's enough interest, I could reprise that explanation.

Childrensmn · Post by **Childrensmn** » Sun Feb 28, 2016 10:36 am

Yes. I searched and got the explanation.