Sonoma uses a different CodePoint for "space" when DateTime values are retrieved as String

[Jeremie_L]

There was another post on the forum about Sonoma and time formatting.
The space between the digits and AM/PM isn’t a space anymore but a non-breaking space.

So it makes sense that using Instr(s," ") wouldn’t work anymore.

Odd character output from DateTime.ToString on macOS Sonoma

The space between the time and “pm” is a Unicode Non-Breaking Space. This is a feature of typesetting that tells the rendering system “don’t break up these two pieces of text even though they have a space in between them”. So you’ll always see: 1:09 pm and never 1:09 pm You can safely replace it with a single space for use in your PDF: pdfText = ReplaceAll(timeText, Chr(&hE280AF), " ")