I want the sequential file name to have Date and Time in the following fomat.
20110610_124801
I am creating this as a variable in user varaiables activity and passing it is as parameter to job.
I am using the following:
Code: Select all
OCONV(DATE(), "D4-YMD[4,2,2]"): '_':OCONV(TIME(), "MTS")
This returns:
2011-06-10_12:43:11
Sequential file name does not like ":" in its name.
I have gone through forum search. Could not find anything that suits me.
Help is appreciated to modify the OCONV to suit my format of
20110610_124801