Date Filters not working as expected

Q&A
,
1

hi,

I have a date column lastUpdatedDate, which i have created 2 dataset parameters lastUpdatedDateFrom and lastUpdatedDateTo. I have mentioned in SQL when lastUpdatedDateFrom<= <<$paramFrom>> and lastUpdatedDateTo>-<<$paramTo>>, but when in controls filter i select 18 july ,db has records. it does not show 18 july inclusive Data.. this is an issue with Date columns in control filters, ideally it should show the data which is inclusive of date selected.

2

Hi @suvarna0212 ,
let me summarize it to understand if I got it correctly:

  • You have a dataset with a column named lastUpdatedDate
  • You have created two params lastUpdatedDateFrom and lastUpdatedDateTo
  • You have set up a SQL filtering with conditions:
    • lastUpdatedDate >= <<$paramFrom>>
    • lastUpdatedDate <= <<$paramTo>>

Is it right?

Can I ask you

  • the format of the date in you lastUpdatedDate field
  • the format you are using in your parameters?

If you want/can, paste screenshots of the configurations directly here :slight_smile:

Thank you!
Andrea

3

lastUpdatedDate in table is this:
image

in dataset filters–> when i add control is 9999/12/31

4

Hi @suvarna0212

You have not shared the details as requested by @andrepgn. When diagnosing issues it is really important that we have all details available.

So I am making some guesses here. Based on your field description it appears that the lastUpdatedDate is a datetime column which means it may have a time component while your parameter control may just be the date (indirectly meaning 12 am would be the time component). Your data for 18th July may be with a particular time and that is probably not applying with just the date available in the parameter control.

You may want to truncate your last_update_timestamp field to only include the date part and then do the comparison.

Additionally, the analysis may have the timezone setting but your dataset is in UTC timezone. That may also play a role. Have you considered that angle as well?

Regards,
Giri

1 Like