Hi I’m using Search Records on Data Store but even though the exact match record exists, it’s not returning any record.
Ideally, I’d want to get the nearby slots based on the date/time provided.
Hello @Mehmood1 and welcome to the Make Community!
It’s possible that 1.date_time is just text and not a date object.
You can convert it to date by using the parseDate function on it.
You’ll need to supply the format the date string is in and the function will return a date object suitable for comparison using the Datetime operators.
Please give that a try and let us know how it goes!
3 Likes
It worked, thank you Donald.
2 Likes