Date format issue since 01/04/2015

[vinnie01]

Hello

I have some VBA code which formats a date field to a certain format. This was all working fine until 1^st 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

 

[Jonmo1]

You're welcome.