DictionR › Snippets

Change the format of a date · #31

Last updated on May 26, 2022 by Olivier Simard-Casanova

This snippet needs the following libraries: base · How to load the right library →

To change the format of a date, use format().

format(var, "%d/%m/%Y")

Dive deeper

There is a lot of operators you can use to fine tune the format of a date. Here is below a list of common operators.

Let's consider the following date and time: 25 April 2025 at 19:52:07.

Full dates:

%x: date in numeric format according to the current langage of your computer (requires an input date formatted as %y/%m/%d)
%D: date in numeric US format, equivalent to %m/%d/%y (US format, 04/25/22)
%F: date in numeric format equivalent to %Y-%m-%d (2022-04-25)

Day:

%d: day of the month as decimal number (25, from 01 to 31)
%A: full name of the day in the current langage of your computer (Monday, Lundi, Montag…)
%a: abbreviated name of the day in the current langage of your computer (Mon, Lun…)

Month:

%m: month as decimal number (04, from 01 to 12)
%B: full name of the month in the current langage of the computer (April, Avril…)
%b (or %h) : abbreviated name of the month in the current langage of the computer (Apr, Avr…)

Year:

Full time:

%X: time formatted according to the current langage of your computer (requires an input time formatted as %H:%M:%S)
%r: 12 hours format with AM/PM and seconds, equivalent to %I:%M:%S %p (07:52:07 PM)
%T: 24 hours format with seconds, equivalent to %H:%M:%S (19:52:07)
%R: 24 hours format without seconds, equivalent to %H:%M (19:52)

Hours:

Minutes:

Seconds:

Timezone: