You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I have created a form and have date stored in it.
I want to delete all records whose event end time is older than a particular date time I specify in my filter query in the clean up API.
I am capturing the event date time in DateTime interval field. I tried putting multiple ways to filter out records whose end time is older than the specified but none seems to be working.
Example I tried: DateTime.endDate:<[Jun 30, 2021 00:00] to delete all records that have end time older than 30th Jun but nothing is happening
I guess this is about ConfiForms, right? But your question does not specify this very well...
If it is then look into https://wiki.vertuna.com/display/CONFIFORMS/ConfiForms+Filters and specifically into the date/datetime format the value for dates should be specified in
Also it always works when you give the dates as timestamps (epoch timestamp but in milliseconds)