Date function format string

raju4u · Post by **raju4u** » Thu Jul 01, 2010 12:13 am

DB is DB2
Ds is :PX
Hi i am passing one parameter as date as a scheduled run date
when i give the format like yyyy/MM/DD it is accepting.but when i give format like MM/DD/YYYY it is not accepting..though i use datetostring function it is not accpting..

Can anybody help me out on this..

Thanks

richdhan · Post by **richdhan** » Thu Jul 01, 2010 7:08 am

Hi,

Along with the function mention the format as well.

The default format would be yyyy/mm/dd so when you pass the value in this format it works. But if you feed data in a different format it will not work until you mention the format in the DateToString function.

HTH
--Rich

chulett · Post by **chulett** » Thu Jul 01, 2010 7:59 am

In other words, post the actual syntax you are using along with a sample or two of your input data.