Question12Replies190Views RaviY230 Member since 2018 22 posts HCL Technologies Ltd Posted: 8 months agoLast activity: 8 months 1 week ago OBj-Browse with Date condition as Equal not fetching ResultsIn OBj-Browse filter condition i given like thisDate IsEqual Param.Date (here i gave like this 20200210T105916)Not fetching any Results. Can you please help me. Thannks,Ravi Pega Client Lifecycle Management for Financial Services 7.4 System Administration Financial Services Product Owner ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Posted: 8 months agovaspoz BPM Company replied to RaviY230The string you provided (20200210T105916) is DateTime type. Check your DB column type, is it Date or DateTyme (like timestamp) Posted: 8 months agoJagdishK9827 Legato Health Technologies replied to RaviY230Hi 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.DateThanksJagdish Posted: 8 months agoRaviY230 HCL Technologies Ltd replied to JagdishK9827It is Date Time Property both param and DB Date Posted: 8 months agoRaviY230 HCL Technologies Ltd replied to JagdishK9827It is Date Time Property both param and DB Date.I given and date and time But it's not coming results Posted: 8 months agovaspoz BPM Company replied to RaviY230If 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 >=, <=) Posted: 8 months agoRaviY230 HCL Technologies Ltd replied to vaspozHi Vaspoz,Here my requirement is i have to fetch only Exactly Equal date results only.Is there any way please let me know. Thanks,Ravi Posted: 8 months agovaspoz BPM Company replied to RaviY230then you have to define a precision. If you use a default Equal, then the precision will be by milliseconds. So, in the majority of the cases, you will get no results.If you choose, for example, minutes, then you need to use a function in Obj-Browse filtering Posted: 8 months agoKarthikA4341 Accenture replied to RaviY230Hi,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 Posted: 8 months agoRaviY230 HCL Technologies Ltd replied to KarthikA4341Hi Karthik, I tried as you told same thing but till not coming results, I don't know what is the issue for me. Posted: 8 months agoBhavya_Incessant Incessant Technologies replied to RaviY230HiCan 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. RegardsBhavya Posted: 8 months agoSatish Mogilicherla Aaseya IT Services Pvt.Ltd replied to RaviY230Hi 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. Posted: 8 months agoDEVJYOTI Areteans Technology Solutions replied to RaviY230Just 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.