Date Format

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Date Format

Description

Changes the date format of dates in 1 or more columns.

 

Inputs

1.

 

Options

Check the columns you wish to transform.

Supply the existing date format in Format from (see below).

Supply the new date format in Format to (see below).

The following date formats are supported for input and output:

 

Format

Meaning

d

The day as number without a leading zero (1 to 31)

dd

The day as number with a leading zero (01 to 31)

ddd

The abbreviated localized day name (e.g. 'Mon' to 'Sun'). Uses the system locale to localize the name.

dddd

The long localized day name (e.g. 'Monday' to 'Sunday'). Uses the system locale to localize the name.

M

The month as number without a leading zero (1 to 12).

MM

The month as number with a leading zero (01 to 12)

MMM

The abbreviated localized month name (e.g. 'Jan' to 'Dec'). Uses the system locale to localize the name.

MMMM

The long localized month name (e.g. 'January' to 'December'). Uses the system locale to localize the name.

yy

The year as two digit number (00 to 99).

yyyy

The year as four digit number. If the year is negative, a minus sign is prepended in addition.

 

Notes

You can also use Split Col to split a date into its component parts. For example to split "31/1/2019" into day, month and year components using the "/" delimiter.

 

Example

To change from "31/1/2019" to "02-31-19" set Format from to "d/M/yyyy" and Format to to "MM-dd-yy".

 

See also

Num Format