Adding new "Date" Column using Date Interface

[EKBS83]

Hi all,

I've been using the date interface tool to update dates in filters in my workflows with no issues at all.

I can't seem to get this to work in a formula tool.

I want the user to be able to select "today's date" in the interface, and for a new column to be created later in my workflow that applies this date to all rows.  This sets an anchor date for a number of outputs which are uploaded to a server to use as data sources for Tableau.

I've tried doing this in two main ways with some variations in each:

1 - Formula tool was configured as DateTimeToday()

a) action tool "Formula" highlighted - existing DateTimeToday() formula overrode date selection by user (apparent when server time ticked over to next day in Singapore when I am in UK).

b) action tool "@expression - value = "Date" highlighted - returned an error

2 - Formula tool was configured as "2021-11-04"

a) action tool "Formula" highlighted only - value remained the same regardless of date selected in action tool

b) action tool "@expression - value = "Date"" highlighted - value remained the same regardless of date selected in action tool

c) I tried b) with replace string and this also did not work

Hope the community can help here - feels like it should be a really simple solution i just can't see the wood for the trees anymore!

ATTEMPT 1

OR

ATTEMPT 2

with or without below

[ArtApa · Accepted solution]

Hi @EKBS83 - There is a couple of ways how you can do that, with or without the Action tool:

[EKBS83]

This is great thank you!  Looks like I both over-simplified and over-complicated either of my efforts!