DAY function
This topic describes the formula syntax and usage of the DAY function in the Data Quality Execute Formula transform.
Description
Converts a serial number to a day of the month.
Syntax
DAY(serial_number)Example
Formula:
Day([Date])| Date (date field) | Serial number (integer) | Result |
|---|---|---|
| 2021-08-15 | 44423 | 15 |
| 1954-02-03 | 34733 | 3 |
| 2022-06-05 | 44717 | 5 |