VBA-SQL-Library icon indicating copy to clipboard operation
VBA-SQL-Library copied to clipboard

SQLHelperFunctions — wrong Format masks in toISO

Open Ben-Gonzalez-97 opened this issue 3 months ago • 0 comments

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

  1. Print toISO(Now) and compare minutes field.

Actual

  • Minutes are incorrect.

Proposed Fix

  • Use mm for month and nn for minutes.

Ben-Gonzalez-97 avatar Oct 16 '25 13:10 Ben-Gonzalez-97