Skip to main content

system.kanoa.utilities.formatDatesForSP

This function requires KanoaCore module

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 Example​

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