DSXchange

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

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

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