- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 13, 2025 08:14 AM
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.
ExpDate:
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 13, 2025 08:18 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 13, 2025 08:18 AM
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!
