Creating Events before/after an event

[Sam_CG]

Hello,

I'm trying to create a macro which allows me to input an event into fantastical and then create an event for travel 30 minutes before the beginning of that event (for 30 minutes) and an event for travel for 30 minutes following the event. Everything is working except for the time calculations before/after the main event. Is there a way of having KM +/- time from a date set as a variable?

Thanks!

[tiffle]

Hi @Sam_CG - there was a very recent discussion about this. Check it out here:

How to add time in a variable

Ultimately, I'd like to add a random number of minutes to a date variable to trigger a macro. I'm referencing this suggestion since it's similar in nature, but it seems to be picking a random time from NOW not a variable. What I'd like is for the macro to run at a random number of minutes after 5:30P today. And also this to see how string ICUDate time variables are used. To get my answer, I'm trying to work in stages. I'm stuck with trying to convert a date string into a calculation field s…

and here:

Using a Date variable for in ICUDateTimeFor

I want to enter a date variable in the ICUDatTimeFor function. Like: %ICUDateTimeFor%TIME(%Variable%yeartest%, 4, 30)%EEE, MMM d, yyyy, w% this returns : %ICUDateTimeFor%TIME(2022, 4, 30)%EEE, MMM d, yyyy, w% and I want : za, apr. 30, 2022, 17

[Sam_CG]

Thanks @tiffle .

I can't see how to make that work with a variable from a user input - 'ward visit date time is' where the variable which I want to add/subtract time from.

[ComplexPoint]

A date time value needs to be an integer string representing Unix Epoch seconds (if you want to apply any arithmetic to it) so:

1. We capture the initial value in a field with a Date and Time type, and
2. we supply a default in terms of a function like NOW(), which returns an integer string (seconds since the start of 1970)

---

For example:

30 mins before and after entered time.kmmacros (4.2 KB)

[Sam_CG]

That works perfectly. Thank you @ComplexPoint