Get today's date and calculate age from deal date

[esabay]

Hi sorry newbie question? From the attached excel file, how do I always get todays date in a formula and calculate the difference between the date today and the column deal date. Thank you

[FrederikE]

Hey @esabay,

You could use the following functions: 

1. 

DateTimeParse([Deal date],"%d-%B-%y")

// Parse the Input into a ISO-Date format

(See here why this letters are used: https://help.alteryx.com/20221/designer/datetime-functions)

2. 

DateTimeToday()
// Todays time

3.

DateTimeDiff([Today],[Deal date],'days')
// Difference in days

See the attached WF. 

[esabay · Accepted solution]

Hi @FrederikE thanks for the solution it worked like a charm. Im trying to filter the difference column to only include results of more than 5 days. How do I do this? Thank you

[Erin]

Try adding a formula in the filter tool, such as DateTimeDiff([Date],DateTimeToday() ,"days") >= 5

Example attached.