Filter query

Help Data Service
, , ,
1

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

2

Hi @Sonalk,

Could you please share your Query Builder screenshot?

3

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

Create Time is less than DateTime.Now

4

Hi,

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.

5

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

6

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

7

@Aakash_Singh_Rawat : Yes both are in same format.