Check a date in a table

hello,
I have a problem and search a function or expression to check if a specific date is expired.
Example: if you want to check if a date in a specific table record is more than 12 days ago then the boolean is yes. But is there an expression or type where I can check this? Maybe:
if @tablerecord.table.date + 7days is earlier then current date then …
Does anyone has any idea?

hello @katha, that’s a great question.

you’re on the right track, the only thing you need to add multiply a Number by 86,400 (to convert from Seconds to Days). for example: @App Info.Current Date and Time - (@Variable.Days to Subtract * 86400).

you can then use this in a Trigger to compare the Date you just created to the Table Record Field:

this is what the result would look like:


does this help you in building your App?? let us know!!