Date Input User Interface

I am using the Date interface to update the as-of date in my workflow. However, when the user is selecting the date, I'm getting an error that the formula "AS_OF_DATE_STRING" resulted in a number but the field is a Date/Time. Can someone help with this?

Date Input Issue.yxwz

Date Input Issue.yxmd

Date Time

Accepted answers

ed_hayter

weird it worked ok for me that time - having opened up your attached file you still have the speech marks round your date in the update action replace specific string - they need to be gone. I have updated your uploaded workflow with the changes and a table and render tool to show that it is updating for me.

Interface too.png

Date Input Issue(2).yxmd

All comments

ed_hayter

Interface Fix.png

This removed the error for me: by default you were replacing the speech marks as well and causing an error

tlhoyt

I made the change but am receiving the same error when I try to run as Analytic App

Date Input Issue.yxmd

ed_hayter

Sorry for missing the mark on the first one.

Try this in the formula with the above change as well:

Datetimeparse("2023-03-31", "%y-%m-%d")

This means you can input a string and then parse it to date and the data type should now accept it

tlhoyt

Now getting an error that says "Type mismatch. Number provided where a string is required"

Date Input Issue.yxmd

ed_hayter

Interface too.png

Date Input Issue(2).yxmd

tlhoyt

Working now; thanks!

tgawade

Can anyone tell me what am I doing wrong here my Paid date column from source is in datetime format and given dates are user input just like in the ongoing topic

Under Custom Formula :

Datetimeparse([paid_date],"%y-%m-%d")>=Datetimeparse("2021-07-01", "%y-%m-%d") and Datetimeparse([paid_date],"%y-%m-%d")<=Datetimeparse("2021-08-01","%y-%m-%d")

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703