The string you provided (20200210T105916) is DateTime type. Check your DB column type, is it Date or DateTyme (like timestamp)

Hi Ravi,

Is the Date column which you are using in Obj-browse has only date value or date time value stored?

if Date has only date value then you need to pass only date (20200210 in the example) for Param.Date 

if it is Datetime then you need to pass time stamp as yyyyMMddThhmmss.sss for Param.Date

Thanks

Jagdish

If it's a DateTime, then a record from DB will contain seconds and milliseconds. Definitely, you will not find anything useful with the EQUAL condition. You should use functions instead (or >=, <=)

Hi,

For illustration purpose, I am using pxCreateDateTime of a work object which was: 20200130T151609.516 GMT.

I defined a parameter in my activity called Param.Date and defined it as a String. And then set value for Param.Date as "20200130T151609.516 GMT"

In the Obj-Browse step, i added a condition .pxCreateDateTime <Is Equal> Param.Date and system is fetching the expected result. 

Try defining you Parameter as String and try adding milliseconds as well as timezone i.e. GMT after your datetime value. For e.g. (20200210T105916.XXX GMT) and it should work.

Thanks,

Karthik

Hi

Can you share the screenshots of the configuration you have done?

Also just pick up one record from you table and try to hard code the condition for only that atleast for the debugging purpose.

Regards

Bhavya

Hi Ravi,

Can you share the screenshot of the Obj-Browse with filter you applied and also the column Type or Property Type you are using.

Thanks, Satish M.

Just a suggestion, can you try to use formatdatetime() before passing the date value. Check the accepted format by directly running the query in the DB.