3,962
Hi community,
is it possible to add a uration of 3 or 6 month?
I have a column defined as duration.
When I enter "3 months" it is replaced after saving with "3 minutes".
When entering a "3" only, then only minutes, hours and days suggested.
Only thing, that I need are weeks, months and years.
I'm sure there is a possibility ...
Thanks,
AndKan.
Hi @Syndicate_Admin ,
input with '90 days' works ... but that's not useable for endusers to enter 'days'
I need such a longer duration for a contract, which runs i.e. 1 year. Duration: 1 year.
This contract can be canceled/terminated 3 month before year of contract ends.
If contract not canceled 3 month before, it runs one year again.
In table there are 3 fields, user inputs:
startofcontract (date)
runtime (duration)
termination (duration)
I solved this problem with choices so users can select a duration like 1year, 1month.
A date field is calculated with choice duration.
Field termination_date (date) is calculated depending on choice termination_duration (choice):
if (termination_duration eq 'year') { termination_date = AddYears(1, startofcontract); } elseif ( termination_duration eq 'month') { termination_date = AddMonths(1, startofcontract); }]
Microsofts solution to save durations as minutes is not useable in my case, because not every month has same count of minutes. And so there is a difference between AddMonths(1, startdate) and AddMinutes(30*86400, startdate).
| startdate | AddMonth(1, startdate) | AddMinutes(30*86400, startdate) |
| Jan 1st | Feb 1st | Jan 30th |
| Mar 1st | Apr 1st | Apr 1st |
BR,
AndKan
You could try 90 days.
Otherwise, you could do two field - To/From (date/time).
If you provide more of your end goal I can provide a better option.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (