Create a function that compares the date open to todays date

Valori

how would i create a function that compares the date open to today's date

Henry Simms

Broadly speaking, you're going to use the native functions Current timestamp (dynamic) to get the current date and Compare date/time to return the delta between your timestamp and the current timestamp.

Take care to format and convert your input value into DATE dataytype if it's not already

Valori

Thank you!

Josh Boxer

Some similar examples in the Functions library:

https://community.experianaperture.io/discussion/558/future-date-check-dynamic