DateTimeFormat and Action Tool

Hey Guys.

I Am trying to attach an action tool to a filter tool, in which uses a formula to substitute and format the date.

It does work, however I have no knowledge in trying to identify and apply the correct column that should be filtered.

Here is how it works:

Formula: DateTimeFormat([#1],'%Y-%m-%d','Português')

Column that should be filtered: DATA_LIQUIDACAO

Workflow

Accepted answers

binu_acs

@Joker_Hazard you can find an example in the Date interface tool - which is very similar to your use case

All comments

Robin_McIntosh

Are you looking to apply the filter on the selected date (once formatted)?

apathetichell

Can you add a select tool before the filter - are you sending in only a date or a datetime? My hypothesis would be this isn't an action tool issue - but your underlying dataset is datetime prior to the filter so it's datetime coming out of the filter. If this was just a date it would be working correctly (or mostly correctly)...

One thing to note is that you are trying to compare what is presumably a date (data_liquidicao) to a string (the results of datetimeformat) - which may also be causing a problem. - you should be using a trim instead.

Joker_Hazard

Yep @Robin_McIntosh

I have to use custom in action tool because I cannot add a "replace string".

Joker_Hazard

I've tried changing to date or strings and the result is the same, the filter is not applied.

My dataset has two dates only, 29th and 30th, both of them filter as True if I filter 30th on calendar app.

binu_acs

@Joker_Hazard you can find an example in the Date interface tool - which is very similar to your use case

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703