Version:2.2.1 +





The Formula FormatDate converts a date to a string with a specified text format.



This is the date that has to be converted.


This is the desired text format.

Culture (23.11+):

This is the desired culture in which the date is presented. See also 'Formats and cultures' below. If this parameter is empty, the culture from the configuration will be used.


Examples format

In the following table you will see specified formats and there results for the date March 5, 2013.

Format Output
dd MMMM yyyy 05 March 2013
dd MMM yyyy 05 Mar 2013
dd-MM-yyyy 05-03-2013
dd-M-yyyy 05-3-2013
d MMMM yyyy 5 March 2013
d MMM yyyy 5 Mar 2013
d-MM-yyyy 5-03-2013
d-M-yyyy 5-3-2013
dd MMMM yy 05 March 13
dd MMM yy 05 Mar 13
dd-MM-yy 05-03-13
dd-M-yy 05-3-13
d MMMM yy 5 March 13
d MMM yy 5 Mar 13
d-MM-yy 5-03-13
d-M-yy 5-3-13

More detailed format

In the situation that you want to save files that you created, it can be useful to save the file with the current timestamp in the filename. Therefore the formula 'Now ()' is available. This formula shows the current time. In this situation you probably want to save more accurate the time then only the day when the file is saved. This is possible: you can also show minutes, seconds and even thousandths of a second. For these options we also use standard notation:

HH: for the display of a hour

mm: for the display of a minute

ss: for the display of a second

ff: for the display of hundredths of a second

fff: for the display of thousandths of a second

In general: 'How higher the amount f, how more accurate the representation of the time is'.

Formats and cultures

The actual way in which a date will be presented depends on the chosen format, but also on the chosen Regional Settings Culture. The culture can be set in the chapter Configuration Format. In the example above the culture 'en-US' is used. If the culture is, for instance, 'nl-NL' then the format will remain the same, but the representation of the date will follow the dutch date notation. From version 23.11 it is also possible to set the culture in a parameter of the formula. This way the culture can be set on a formula level instead of an application level, to ensure bilingual usage.

Related Topics

FormatNumber: To convert real numbers to  text

External Links Further explanation on the text format.

Updated: 2013-03-25