Help with elapsed time formula
I am looking for help with a formula field I need to create. The goal is to decipher between a record that contains a call_date that was less than one month in the past and a call_date that is more t...
Forum Discussion
Hi -- thanks for the help. Here is the formula example:
If(
[Date Created]-[CA Date] < Days(30), "1 Month",
[Date Created]-[CA Date] >= Days(180), "6 Month")
The issue I am getting a syntax error because [Date Created] is a date/time field type and [CA Date] is a date type. Is there an easy way to change this without changing the field type?
If(
[Date Created]-[CA Date] < Days(30), "1 Month",
[Date Created]-[CA Date] >= Days(180), "6 Month")
The issue I am getting a syntax error because [Date Created] is a date/time field type and [CA Date] is a date type. Is there an easy way to change this without changing the field type?
