Skip to content

SQLHelperFunctions — wrong Format masks in toISO #67

Description

@Ben-Gonzalez-97

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions