SOLVED
How to calculate if contract date is active or no expiration date
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
lynettejackson
7 - Meteor
03-21-2022
06:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm having trouble adding a new column with a date formula that determines whether or not a contract is active. I'm creating a process utilizing the [contract line start date] and [contract line end date].
I have attached the file
TechidentNo and Technical Identification are my join fields. The expiration is 03/31/2022.
I would deeply appreciate any assistance I can get.
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
2 REPLIES 2
21 - Polaris
03-21-2022
06:29 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@lynettejackson
I am not quite able to understand the logic here. Just wild guess. 😁
03-21-2022
08:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much. The workflow worked. I have save formula for future reference. Again, thanks a lot.
![](/skins/images/12DF86F0CA96E81F3ABF675C1590B6DD/responsive_peak/images/icon_anonymous_message.png)