I’m trying to filter results on a GI to @today but it returns 0 results.
I attached the GI.
Answer
Relative Date in GI filter
+4Best 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.
Jeff G.
+15Hi
I am able to filter records with today.
Could you please help me to understand with some more inputs
Thanks
+4Hi
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.
+15Hi
Thanks for the clarification
+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
+4
Hi
Thanks for the clarification
Did you change anything? Because for me it doesn’t show any results.
+15Hi
+4Hi
It’s already enabled.
+15Hi
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
+4Hi
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.
+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.
+4Hi 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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.