Kirix Support Forums

Date format change

Please post any help questions, requests or other feedback here.

Date format change

Postby TillyDoyle on Wed Mar 21, 2012 6:47 am

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
TillyDoyle
Registered User
 
Posts: 4
Joined: Wed Jul 20, 2011 4:17 am

Re: Date format change

Postby Ken on Fri Mar 23, 2012 12:56 pm

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
Ken Kaczmarek
Kirix Support Team
User avatar
Ken
Kirix Support Team
 
Posts: 147
Joined: Mon Dec 19, 2005 10:36 am

Return to Strata Help & Feedback