VBA-SQL-Library
VBA-SQL-Library copied to clipboard
SQLHelperFunctions — wrong Format masks in toISO
SQLHelperFunctions: correct toISO Format masks (mm vs nn)
- Component:
src/Modules/SQLHelperFunctions.bas(top)
Problem
- Uses month/minute masks incorrectly; minutes display as month.
Snippet (actual)
Public Function toISO(dt) As String
toISO = Format(dt, "YYYY-MM-DD") & "T" & Format(dt, "HH:MM:SS")
End Function
Expected
Public Function toISO(dt) As String
toISO = Format(dt, "yyyy-mm-dd") & "T" & Format(dt, "hh:nn:ss")
End Function
Steps to Reproduce
- Print
toISO(Now)and compare minutes field.
Actual
- Minutes are incorrect.
Proposed Fix
- Use
mmfor month andnnfor minutes.