I have 20 fields that users can put any information in them. They can specify if any of those fields are dates. This allows in the user interface to use a date picker and filter and apply date filters.
Is there anyway with the C# driver to a LINQ date filter query on these fields?
Ideally, I would ant to simply do:
result.Where(x => x.A1 != null && searchMin <= DateTime.Parse(x.A1) && DateTime.Parse(x.A1) <= searchMax);
I saw that there are the $toDate and $dateFromString functions, but I have not found any implementation of this with the driver.
Any help on this and what is possible would be greatly appreciated.