Hello fellow friendly fibery folk,
In short - is it possible to easily manipulate date times using formulas, e.g. set / add / remove units of time.
Pain: “Setting a duration involves lots of clicks”
Idea: “Create a button that does some the hard work”
E.g. Duration = 30 minutes, Duration = 1 hour
So for a DURATION field, I need to set a sensible DateTimeRange.
I got as far as:
Which does what you’d expect:
However, what I’d actually like to do is!
- Get the current date
- Extract the current time
- Round the time down to a nearest interval (e.g. 15 minutes)
- Create a time range using the rounded down internal as the start
- Send the end range to the start plus X minutes
current datetime = 2020-01-13-20-23-12
rounded to nearest interval = 2020-01-13-20-15-00
start = rounded to nearest interval
end = start + 30 minutes
Any ideas much appreciated