Skip to content

SQLHelperFunctions — wrong Format masks in toISO #67

@Ben-Gonzalez-97

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