Custom date and time format strings

Custom date and time format strings format dates in Date/Time fields.

Format: Specify the desired format for this field. A valid format is composed of the following pattern letters.

Note: All lower case and upper case characters not mentioned in the table below are reserved.

Format Representation Description
%a Abbreviated weekday name
%A Full weekday name
%b Abbreviated month name
%B Full month name
%C Century number
%d The day of the month (00 – 31)
%e The day of the month (0 – 31)
%H Hour (00 – 23)
%I Hour (01 – 12)
%j Day of the year (000 – 366)
%k Hour (0 – 23)
%l hour (1 – 12)
%m month (01 – 12)
%M minute (00 – 59)
%n a newline character
%p “PM” or “AM”
%P “pm” or “am”
%S second (00 – 59)
%s number of seconds since Epoch (since Jan 01 1970 00:00:00 UTC)
%t a tab character
%U, %W, %V the week number
%u the day of the week (1 – 7, 1 = SUN)
%y year without the century (00 – 99)
%Y year including the century (for example 1979)
%% a literal % character