Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Formula calculation using date fields

Topic Labels: Formulas
Solved
Jump to Solution
123 1
cancel
Showing results for 
Search instead for 
Did you mean: 
BeccaC
4 - Data Explorer
4 - Data Explorer

I am using a formula to calculate a date in one field, and then trying to use another formula field to determine whether a contract is current, future, or expired using that date and another manually entered date field.  The field I'm using to determine if the range returns the wrong results if I use the calculated expiration date field, but if I use a manually entered field with that same date, the calculated range returns correctly.   Screenshot - 2_13_2025 , 11_08_53 AM.png

ExpDate:

DATETIME_FORMATDATEADDDATEADDLIC__EffDate{Term (Mo)}"months"),-1'DAYS'), 'M/DD/YYYY')
 
ContractRange:
IF  ExpDate > TODAY(),   IF  LIC__EffDate > TODAY(),    "Future",   "Current"),   "Expired"   )
 
ContractRange copy:
IF  LIC_ExpDate > TODAY(),   IF  LIC__EffDate > TODAY(),    "Future",   "Current"),   "Expired"   )
 
Is there something wrong in my ExpDate formula, or is there an issue with using a calculated date in a date range?  Or am I just doing something else totally wrong?
1 Solution

Accepted Solutions
BeccaC
4 - Data Explorer
4 - Data Explorer

Well, I just solved this myself based on another post.  I added DATETIME_PARSE to the ExpDate field in my ContractRange calculation, and now it works perfectly.  Thanks anyway!

See Solution in Thread

1 Reply 1
BeccaC
4 - Data Explorer
4 - Data Explorer

Well, I just solved this myself based on another post.  I added DATETIME_PARSE to the ExpDate field in my ContractRange calculation, and now it works perfectly.  Thanks anyway!