IsValidSqlDate (Date)

Example

In this example, we will pass various SQL DateTime values to the function transformation object using a Variables object_,_ along with the Normalize object so that different values can be passed to the function transformation object at once.

Where,

date1 = 1 January, 2003

date2 = January, 2003

date3 = 1/2/1991

date4 = 1991/2/4

date5 = 0000/00/00

Note: Valid SQL server DateTime range is “January 1, 1753” – “December 31, 9999”

In the output window, you can see that the Boolean value, True, has been returned for values that are present in the valid SQL server DateTime range, and the value, False, has been returned otherwise.

© Copyright 2023, Astera Software