Calculate Days Past Due from a specific date

[maddoxs]

Hello all thank you in advance for the help! 

I am trying to find a way to take a date (lets say 11/01/23) and calculate how many days have past since then from todays datem giving me a "days past due" collumn

Thank you!

[AndrewDMerrill · Accepted solution]

It looks like you need to parse the date before doing your calculation:

DateTimeDiff(DateTimeToday(),DateTimeParse([Field1],"%B %d, %Y"),"days")

^ This formula should work based on the image you included. I am also including a simple sample workflow.