Most valuable professional
  • Hot Topics

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 1st 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:

This article includes the following tags:

  • Excel
  • Microsoft Excel