Quote:
Originally Posted by ownedbycats
Question: I have datetime formatted as MMM d yyyy. How do I set a predefined date with specific time?
|
The easiest is to enter the date & time in ISO format.
Code:
program:
d = "20250421T13:42:01";
'The date and time are ' & format_date(d, "MMM d yyyy hh:mm:ss ap")
produces
Code:
The date and time are Apr 21 2025 01:42:01 pm