AnsweredAssumed Answered

Deduce 100 days from a given date

Question asked by ZiteMedia on Mar 18, 2014
Latest reply on Mar 18, 2014 by ZiteMedia


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"

     What's wrong?

     Much appreciated