CREATEDATE (date the document was created)

<< Click to Display Table of Contents >>

CREATEDATE (date the document was created)

Syntax:

CREATEDATE()

Description:

Returns the date/time the current document was created.

Example:

In a document created on the 24th of August, 2018 at 9:03 AM:

CREATEDATE() returns 08/24/18 9:03 AM

Tip: By selecting a suitable date format in the dialog box of the ribbon tab Home | group Number group_arrow, you can determine whether only the date, only the time or both should be displayed.

Compatibility notes:

This function is not supported by Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced by their last result as a fixed value.

See also:

NOW, TODAY