0

I have dates of ISO 8601 type in VBA like:

2021-01-19T08:28:31+09:00

how can I convert to normal date type in VBA.

I found solution for other program languages but I couldn't find them for VBA.

I also found solution for convertion on excel sheet. But I would like to know how to get it done in macro in Excel.

Angus B.
  • 23
  • 1
  • 8
  • https://stackoverflow.com/questions/4896116/parsing-an-iso8601-date-time-including-timezone-in-excel – FunThomas Feb 23 '21 at 14:08
  • Does this answer your question? [Parsing an ISO8601 date/time (including TimeZone) in Excel](https://stackoverflow.com/questions/4896116/parsing-an-iso8601-date-time-including-timezone-in-excel) – FunThomas Feb 23 '21 at 14:32
  • It depends on, how you wish the time zone offset handled. Ignore? Convert the date/time value to remote time? Convert the date/time value to local time? – Gustav Feb 23 '21 at 16:28

0 Answers0