Date format change

[TillyDoyle]

My Date column shows the date in American format ie mm/dd/yyyy. how to I convert to English ie dd/mm/yyyy? I have tried DATE function DATE('datecolumn','dd/mm/yyyy') but the output colum remains blank (I get the green tick once formauls entered)...
thanks

[Ken]

Hi there,

Two solutions:

1) If you are using American English settings on Windows, you may wish to switch the language settings to a country/language that formats the way you want it to. Strata should switch its display accordingly.

2) If you're just looking for a one-off adjustment for display purposes, there are no "preferences" for this in the software. However, you could convert a date field to a character field that displays in the dd/mm/yyyy format, using a calculated field as follows:

Code: Select all

to_char(<datefield>,"DD/MM/YYYY")

[where "datefield" is your date column name]

PLEASE NOTE -- the output will be considered a character field so you will no longer be able to use it in date calculations. This is not typically recommended, but might be fine for a one-off change for reporting or something.

All the best,
ken