I need to reformat string to date in job parameters

[vishu19aug]

Hi,

I have a situation, where i need to convert the string to date in job parameters. I am passing the date in a job parameter as '01-Jan-2012' but the parameter is defined as string. I need to extract '20120101' from this parameter and use it in the file name. Can somebody help ?

Thanks,
Vishal Gupta

[jwiles]

Pass the date string into a job sequence as a parameter, reformat the date within a User Variable activity stage, and then call the job passing the reformatted date string in the job's date parameter.

Regards,

[vishu19aug]

Any idea which function to use for converting string to date in user activity stage? It be a great help

[jwiles]

Use ICONV to convert the provided date to internal format, then OCONV to convert the converted date to the format you desire.

Code: Select all

Convert("/","",OCONV(ICONV(DateParameter,"D-"),"D/YMD[4,2,2]"))

should work, given the source and desired results you provided.

Regards,

[Kryt0n]

Code: Select all

OCONV(ICONV(DateParameter,"D-"),"DYMD[4'',2'',2'']"))

Slight tweak to avoid the convert. (I'm assuming "D-" handles Jan/Feb etc as never dealing with such formats I have no idea).

Regarding OP, why all the different date string formats? Consistency through your jobs would be easier (I can understand potential differences from sources but with parameters?)

[ray.wurlod]

My preference would be:

Code: Select all

Oconv(Iconv(jpStringDate, "D"), "DYMD[4,2,2]" : @VM : "MCN")

[vishu19aug]

Thanks! all .. it worked perfectly.

[jwiles]

I figured there were better/other ways to accomplish it than my example...I just don't do server/BASIC often enough