DateTimeFormat and Action Tool
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Are you looking to apply the filter on the selected date (once formatted)?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yep @Robin_McIntosh
I have to use custom in action tool because I cannot add a "replace string".
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Joker_Hazard you can find an example in the Date interface tool - which is very similar to your use case
