# IsValidSqlDate (Date)

| **Name**    | ***IsValidSQLDate***                                                                                                   |
| ----------- | ---------------------------------------------------------------------------------------------------------------------- |
| Syntax      | IsValidSqlDate (Date date)                                                                                             |
| Purpose     | To check if a date time value is a valid SQL Date time value.                                                          |
| Description | Returns true if the specified date time value is within the range of a valid SQL Server date. Otherwise returns false. |
| Return Type | Boolean                                                                                                                |
| Parameters  | date \[System.DateTime] – DateTime value to be checked                                                                 |

![](https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/0%20\(7\).png)

### **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

{% hint style="info" %}
**Note:** Valid SQL server DateTime range is “January 1, 1753” – “December 31, 9999”
{% endhint %}

![](https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/1%20\(7\).png)

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.

![](https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/2%20\(7\).png)