-
Notifications
You must be signed in to change notification settings - Fork 17
Open
Description
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 FunctionExpected
Public Function toISO(dt) As String
toISO = Format(dt, "yyyy-mm-dd") & "T" & Format(dt, "hh:nn:ss")
End FunctionSteps to Reproduce
- Print
toISO(Now)and compare minutes field.
Actual
- Minutes are incorrect.
Proposed Fix
- Use
mmfor month andnnfor minutes.
Metadata
Metadata
Assignees
Labels
No labels