This function returns the day number of the month (integer 1 to 31) that corresponds to the specified date
- Library: PQL \ Spreadsheet \ Date & Time
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
- Solve: This function can be used with the Solve plug-in: both as part of the objective function and constraint functions
Specify the date argument as a number (as in 37806.5) a string (as in "7/4/2003 12:00"), or a DateTime object, as in DATE(2003,7,4)
This function is the same as the Microsoft Excel 'DAY' function - using the same inputs, logic and outputs.