-
Bug
-
Resolution: Unresolved
-
Low
-
None
-
Minor
-
Issue Summary
The filter does not return any data when using Advanced search in data manager for grouping 'Within last X days' if some data contains a very old date.
Steps to Reproduce
- Use the Intune adapter to bring data into Data Manager.
- For a date field, enter date ina string format like '0001-01-01 00:00:00:000'
- Use a transform function in the adapter to convert the date to the correct format. This would convert it as Jan 1, 1, 12:00:00 AM which is correct
- Use the Advanced search now and add the condition 'LastScandate' to be 'Within the last X days' for 'Any'
Expected Results
It should return the data for the number of days selected.
Actual Results
It comes back blank.
Workaround
Will update