Filter query

What query to pass and filter records in data service table based on created time.

Filter query : Create Time < DateTime.Now

I have tried this query but unable to extract records in data service table

Hi @Sonalk,

Could you please share your Query Builder screenshot?

Hi @Aakash_Singh_Rawat : I have selected this condition in query builder

Create Time is less than DateTime.Now


I wanted to see whether your DateTime.Now and Create time of data service entity are in the same format.
Otherwise it would return correct result as per the filter query.

Ok. Create Time or Update Time are in built values. i.e. dd/MM/yyyy HH:mm:ss

Can you check format of both dates are they in same? Just a scenario.

@Aakash_Singh_Rawat : Yes both are in same format.