I’m trying to filter results on a GI to @today but it returns 0 results.
I attached the GI.
Solved
Relative Date in GI filter
+5Best answer by Doug Johnson
Hi Folks. The Confirmed Date column keeps time information, the ShipDate does not. So perhaps date rounding is causing the issue.
For a quick fix, I did this with my filter …
… but I should probably figure a way to remove the time from my ConfirmedDate Time field.
You can use the DAC Schema Browser if you want to know which date fields store time:
- If the Type = datetime, then time and date are stored
- If the Type = datetime2, then only the date is stored.
+16Hi
I am able to filter records with today.
Could you please help me to understand with some more inputs
Thanks
Translate
+5Hi
I am able to filter records with today.
Could you please help me to understand with some more inputs
Thanks
I meant through the filter settings. I want to create and save a filter view with the @today function.
Translate
+16Hi
Thanks for the clarification
Translate
+7There are several ways to accomplish this. Here are a couple of methods. Let us know what you need more help with.
Quick Filter ‘Equals’ @Today
Quick Filter ‘Today’
Advanced Filter ‘Equals’ @Today
Generic Inquiry Condition ‘Equals’ @Today
Translate
+5
Hi
Thanks for the clarification
Did you change anything? Because for me it doesn’t show any results.
Translate
+16Hi
Translate
+5Hi
It’s already enabled.
Translate
+16Hi
Please try this
If still not able to see then follow the steps
- Click on the filter the button as shown as step-in in the below image
- Click on New and
- add the conditions as step 2
- Click on save
- Click on apply
Translate
+5Hi
Please try this
If still not able to see then follow the steps
- Click on the filter the button as shown as step-in in the below image
- Click on New and
- add the conditions as step 2
- Click on save
- Click on apply
I’m trying to filter the Confirmed Date column; it doesn’t work for that one.
Translate
+4Hi Folks. The Confirmed Date column keeps time information, the ShipDate does not. So perhaps date rounding is causing the issue.
For a quick fix, I did this with my filter …
… but I should probably figure a way to remove the time from my ConfirmedDate Time field.
You can use the DAC Schema Browser if you want to know which date fields store time:
- If the Type = datetime, then time and date are stored
- If the Type = datetime2, then only the date is stored.
Translate
+5Hi Folks. The Confirmed Date column keeps time information, the ShipDate does not. So perhaps time zones are causing the issue.
For a quick fix, I did this with my filter …
Thank you!
Translate
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.