CREATEDATE (date the document was created)

<< Click to Display Table of Contents >>

CREATEDATE (date the document was created)

Syntax:

CREATEDATE()

Description:

This returns the date/time the current document was created.

Example:

If a document was created on 31st of July, 2018 at 4:03 PM, the following applies:

CREATEDATE() returns 07/31/18 4:03 PM

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 does not exist in Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced with their current result as a fixed value.

See also:

NOW, TODAY