hi Dharam maybe you can try to_date.
but for reason of performance, I think that you can choose a long to represent a date value instead of a string. Thanks and regards Gang Yan（闫钢） Sr. Solution Architect Customer Success, Pivotal Great China Mobile:+86 13636347460 [email protected] 2017-05-11 21:43 GMT+08:00 Thacker, Dharam <[email protected]>: > Hi Team, > > > > Is there any good way to play with DateType if I have PdxInstance data > having date string with type [java.lang.String]? > > > > *Example:* > > "duedates": { > > "legalDate": "2022-04-19", > > "currentDate": "2022-04-19", > > } > > > > My goal is to get results based on date comparison, > > > > select i from /Event i where i.duedates.legalDate > ‘2022-04-15’ > > > > Thanks & Regards, > > Dharam > > This message is confidential and subject to terms at: http:// > www.jpmorgan.com/emaildisclaimer including on confidentiality, legal > privilege, viruses and monitoring of electronic messages. If you are not > the intended recipient, please delete this message and notify the sender > immediately. Any unauthorized use is strictly prohibited. >
