Excel: Date format issue since 01/04/2015


Hello I have some VBA code which formats a date field to a certain format. This was all working fine until 1[SUP]st[/SUP] April 2015 ! Input date format = mm/dd/yyyy Output date format = yyyy-mm-ddThh:mm:ss.SSS-05:00 my code.. oE.Range("N" & br).Value = Format(strDateTime, "yyyy-MM-dd") & Format(Now(), "Thh:mm:ss.SSS") & "-05:00" Value of strDateTime =03/23/2015 formats OK as expected to 2015-03-23T09:44:02.022-05:00 Value of strDateTime =04/01/2015 format conversion is incorrect 2015-09-04T10:08:12.1212-05:00 (expected to be 2015-04-09T10:08:12.1212-05:00) Appriciate any help on this Cheers


This question generated 31 answers. To proceed to the answers, click here.

This thread is current as of April 13, 2015.


For more resources for Microsoft Excel