community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Date to Date Value

Highlighted
Meteoroid

Does anyone know how to convert a date in the format yyyy/mm/dd to date value? Date value is the number of days since 1/1/1900.

Alteryx Partner

2018-02-15_00069.png

Asteroid

Use text input to input the 1900 date value, append it to the input data using append tool and then use the DateDiff function in formula tool to find the difference between the dates.

Labels