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
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