Deduce 100 days from a given date
I have just one table and "givendate" is one of the fields and is of the "Date" type. I need to calculate another date which is 100 days before that givendate.
I've searched the forum and based on some answers i found on similar questions i came up with this formula:
Let ( D = Get ( givendate ) ; Date ( Day ( D ) - 100 ; Month ( D ) ; Year ( D ) ) )
When i try this i get an error message highlighting givendate and saying:
"This paramter is an invalid Get function parameter"