Turn Date into Numerical Value

Hi Alteryx Community - could someone please help - I have in excel a couple date columns.

One is "Period Date": 9/30/2024 12:00:00 AM

Another is "Maturity date" example: 01/15/2025

I want to calculate how many days in-between - example above being that there are 107 days until maturity. I'm having a difficult time converting a date into a numerical value to be able to calculate the days in between since I keep getting formula error that either the date is in a string format or in a date/time format, so a calculation is not working. Any thoughts here? Thanks

Error Message

Accepted answers

OllieClarke

Hi @missteran

If you parse your date fields to a date format, and then change date types to date, you can use the datetimediff() function to find the difference in days between them
parsing the datesfull workflow