Skip to main content

system.kanoa.utilities.formatDatesForSP

Description

When passing a date to a stored procedure, it needs to be converted to the timezone of the SQL Server (kanoaCore).

Syntax

formatDatesForSP(datesIn)
  • Parameters
      datesIn (List) - List of dates to be converted (e.g., [startDate, endDate]).
  • Returns
      datesOut (List) - List of converted dates.

    • Code Examples​

    # Example Usage:
    converted_dates = system.kanoa.utilities.formatDatesForSP([startDate, endDate])