Edit

Share via


NULLDATETIME ER function

Note

Community interest groups have now moved from Yammer to Microsoft Viva Engage. To join a Viva Engage community and take part in the latest discussions, fill out the Request access to Finance and Operations Viva Engage Community form and choose the community you want to join.

The NULLDATETIME function returns a DateTime value that represents the null date/time value (January 1, 1900) in Coordinated Universal Time (Greenwich Mean Time [GMT]).

Syntax

NULLDATETIME ()

Return values

DateTime

The resulting date/time value.

Example

DATETIMEFORMAT( NULLDATETIME(), "O") returns the string value 1900-01-01T00:00:00.0000000+00:00 when it's called during a process that was initiated by an application user who has the time zone value (GMT) Coordinated Universal Time in the Language and country/region preferences section.

Additional resources

Date and time functions