I am using some AppleScript to get a date from an Excel spreadsheet. I then need to convert that date into an ICU format to enter into an online form. To do this I use: [Screenshot 2023-11-17 at 11.46.59] However, the %ICU...% doesn't recognise the clipboard as a date, so returns the stock '1 Ja…

Converting a string into an ICU date

Airy November 17, 2023, 4:01pm 3

I believe that will work, but an alternative approach is to convert the string to Unixtime inside the macro, and this thread explains the technique:

1 Like