- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 02, 2024 03:43 AM
I want to have a select field with a couple of options for clients that need a subscription. Like: "1 month subscription", "2 month subscription", ... . This would ideally convert the answer into a 31 day duration field that can then be used in a date dependency to calculate the end date for the subscription. Is this possible?
I already figured out that i can convert it to duration using a formula field but then i can't use it in a date dependency...
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 02, 2024 08:12 PM
Does this look right?
DATEADD(
{Start Date},
SWITCH(
Subscription,
'1 month subscription', 31,
'2 month subscription', 62
),
'days'
)
 

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 02, 2024 12:54 PM
I'm not sure I'm fully understanding what you're asking. Can you show an example of an expected output?
So far I'm assuming you'd need an automation, but I want to make sure I provide the easiest and best solution for you.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 02, 2024 08:12 PM
Does this look right?
DATEADD(
{Start Date},
SWITCH(
Subscription,
'1 month subscription', 31,
'2 month subscription', 62
),
'days'
)
 
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 03, 2024 05:53 AM
This is exactly what i needed! Don't understand how i didn't think of just not using the date dependency and just using a formula instead...
Thank you very much!
