How to format current date as string in parameter
Moderators: chulett, rschirm, roy
How to format current date as string in parameter
I want to pass the current date to to a job as a parameter from the sequence. I am calling DSJobStartDate for the parameter to the job. However, I'd like to reformat this to a string in the format of 'DD-MON-YYYY'. Yet, I cannot identify a function to do this type of reformatting of the current date in the parameter expression. Is this possible and what function could I use to reformat the current date into a string?
Jeff Cook, CBIP
Principal Consultant
Pinnacle Solutions Group, Inc.
Principal Consultant
Pinnacle Solutions Group, Inc.
Re: How to format current date as string in parameter
Use routine.
DS User
DS User
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
Oconv(Iconv(DSJobStartDate, "DYMD"), "D-DMY[2,A3,4]")
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Problem solved
Thanks, Ray. That fixed my problem! :D
Jeff Cook, CBIP
Principal Consultant
Pinnacle Solutions Group, Inc.
Principal Consultant
Pinnacle Solutions Group, Inc.