I need to be able to calculate a date, created by a formula, which is prior to whatever the current date is. That sounds easy but I cannot figure out how to do it in my specific situation.

Because I needed to determine a date that was 2 weeks after a date entered based on two different scenarios I created this formula in my data table:

CASE

WHEN [@field:Brand_Received] = 'Brand 1' THEN Dateadd(day, 14, [@field:Date_1])

WHEN [@field:Brand_Received] = 'Brand 2' THEN Dateadd(day, 14, [@field:Date_2])

END

It works well to give me the date that is two weeks after the specific date given, based on unique requirements.

However, now I need to create a field that checks to see if the new Formula Date is before whatever the current date is. I have not been able to get a result for this. Caspio does not allow me to use results from one formula field as variable in another formula field. And I have not been able to figure out just yet how to combine all the variables I need to produce a valid formula.

You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

## Question

## Woolf

I need to be able to calculate a date, created by a formula, which is prior to whatever the current date is. That sounds easy but I cannot figure out how to do it in my specific situation.

Because I needed to determine a date that was 2 weeks after a date entered based on two different scenarios I created this formula in my data table:

CASE

WHEN [@field:Brand_Received] = 'Brand 1' THEN Dateadd(day, 14, [@field:Date_1])

WHEN [@field:Brand_Received] = 'Brand 2' THEN Dateadd(day, 14, [@field:Date_2])

END

It works well to give me the date that is two weeks after the specific date given, based on unique requirements.

However, now I need to create a field that checks to see if the new Formula Date is before whatever the current date is. I have not been able to get a result for this. Caspio does not allow me to use results from one formula field as variable in another formula field. And I have not been able to figure out just yet how to combine all the variables I need to produce a valid formula.

Any thoughts?

## Link to comment

## Share on other sites

## 5 answers to this question

## Recommended Posts

## Join the conversation

Note:Your post will require moderator approval before it will be visible.