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
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
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.
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.