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.
In the following table you will see specified formats and there results for the date March 5, 2013.
|dd MMMM yyyy
||05 March 2013
|dd MMM yyyy
||05 Mar 2013
|d MMMM yyyy
||5 March 2013
|d MMM yyyy
||5 Mar 2013
|dd MMMM yy
||05 March 13
|dd MMM yy
||05 Mar 13
|d MMMM yy
||5 March 13
|d MMM yy
||5 Mar 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'.