#datetimezone

Generates a datetimezone value using numeric inputs for the year, month, day, hour, minute, (fractional) second, (fractional) offset-hours, and offset-minutes. If any of the following conditions are n...

Syntax

#datetimezone(year as number, month as number, day as number, hour as number, minute as number, second as number, offsetHours as number, offsetMinutes as number) as datetimezone

About

Generates a datetimezone value using numeric inputs for the year, month, day, hour, minute, (fractional) second, (fractional) offset-hours, and offset-minutes. If any of the following conditions are not met, an error will be displayed: - The year should be between 1 and 9999 - The month should be between 1 and 12 - The day should be between 1 and 31 - The hour should be between 0 and 23 - The minute should be between 0 and 59 - The second should be less than 60 - The sum of offset-hours and offset-minutes divided by 60 should range from -14 to 14.