Dataverse Filter by date with 35,000 records

[Andrew_Aitken]

Hello 

I need to filter 35,000 records in Dataverse by Date (DOB).   

Is best to store the date of birth as a number and not a date?

Cheers

Andrew

[bipinshan · Accepted solution]

Hello @Andrew_Aitken ,

You should create Date Time field with Date behaviour set to Date only.

https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/behavior-forma...

Thanks,

Bipin

[Andrew_Aitken]

Date only field works. 

Filter(Clients_1,'BAP-Date' > DOBSearch.SelectedDate,'BAP-Date' < DateAdd(DOBSearch.SelectedDate,1,Days))

Thank you