Filter tool and dates

[Joker_Hazard]

Hello everyone.

I am trying to filter a custom date with the tool, however its not returning any results.

Am I doing something wrong?

Thanks

[Kenda]

Hi @Joker_Hazard 

Make sure that your RN_EXECUTION_DATE field is a Date field, not a DateTime field. Otherwise, you could surround your field name with the ToDate() function.

Also, it looks like you are just using greater than and less than (no equal to). This means only records with a date of 2021-05-14 would be true. Double check you do have records with this date.

[TheOC]

hey @Joker_Hazard 

is your date a string or date?

You may have to convert it to a date, then the filter has built-in functionality for choosing ranges.

Feel free to attach a anonymised version of your workflow and i'll have a look!

Cheers,
TheOC

[Joker_Hazard]

Hey thanks for the reply..

I do have values within this period and the filed is a "date type".

I tried changing for "dateTime" format and still have issues.

[TheOC]

NVM i made a mistake, 2 seconds ill give it a try in a workflow
TheOC

[TheOC · Accepted solution]

hey @Joker_Hazard 

Attached is a workflow with it working with this dateframe.

Just as a sanity check, do you have any dates in that dataset of "2021-05-14", because that is the only date the filter will allow through as of current.

Hope this helps,
TheOC