Help with @Date as "092014" instead of "92014

Childrensmn · Post by **Childrensmn** » Mon Sep 22, 2014 8:55 am

Hello,

I have the following script in my batch to load month and year dynamically. I pass the below parms to jobs in the batch.

Current_Month = OCONV(@Date,"DM")
Current_Year = OCONV(@Date,"DY")

However the result is
Current_Month = "9" and I would like that to be "09".

Any tip is appreciated.

Thanks!!

chulett · Post by **chulett** » Mon Sep 22, 2014 10:38 am

Probably other ways but off the top of my head:

Current_Month = OCONV(@Date,"DM[2]")

Your month parameter will also have to be a string, of course.

Childrensmn · Post by **Childrensmn** » Mon Sep 22, 2014 12:21 pm

Thank You!!