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.