Liberum Help Desk
The free, open source solution for the web-based help desk.

Converting to UK date formats

rated by 0 users
This post has 8 Replies | 4 Followers

Top 100 Contributor
Posts 3
laurencechilds Posted: 06-08-2010 4:32 AM

Hi All

I'm very impressed with the LHD system

one small snag for me is that i am using the system in the UK and all the date formats on pages, search pages etc. are in US format

my HTML editing skills are very poor

has anybody tweaked the system for us in the UK and could they give me pointers as to what needs changing?

thanks

 

Laurence

Top 10 Contributor
Posts 40

Good point Laurence!

I'm quite happy with the US format date as quite  few of our systems use DICOM which natively uses that format, we switch between them quite automatically.
Shouldn't be too difficult though, I'll have a look at hacking up an install on my lappy when I have a few spare minutes ;)

Top 10 Contributor
Posts 71

If they got carried over here from the old forums, there were quite a few posts on manipulating dates, particularly between US and UK formatted dates.  You might try searching these forums.

 

Doug G

Top 100 Contributor
Posts 3

Hi Nick

thanks for the offer, will keep my eyes open for your reply

regards

Laurence

Top 100 Contributor
Posts 3

Hi Doug

i did a search through the forums but could not see any posts relating to this

i couldn't see an archive anywhere, could you point me to where it may be?

thanks

Laurence

Top 150 Contributor
Posts 2

Hi

Look for the file public.asp in the root and change this line near the bottom


    ' ###### CHANGE THIS STRING TO MATCH LOCAL DATE FORMAT ######
    strLocalDate = "mm/dd/yyyy"
    ' ###########################################################

to


    ' ###### CHANGE THIS STRING TO MATCH LOCAL DATE FORMAT ######
    strLocalDate = "dd/mm/yyyy"
    ' ###########################################################

And it will change to UK format

Dgwebbie

 

Top 200 Contributor
Posts 2

My database is hosted in Europe where the date format is mm/dd/yy, I am a UK user. We have been using the datase for some time now with the date format as mm/dd/yy, but would like to move to the UK format of dd/mm/yy. Will I have issues with mm and dd being in the wrong format if I change it now  or does it just sort itself out ?

 

Hosster

Top 150 Contributor
Posts 2

You should have no problem worked straight away for me on a server in britain

Top 200 Contributor
Posts 2

So just to clarify, you had data in the database already  in the mm/dd/yyyy format, made the changes to the asp file to dd/mm//yyyy format and there were no issues with the date data formats in the database, from historical or new data ?

 

thx

Hosster

Page 1 of 1 (9 items) | RSS
Copyright © Doug Luxem 2000-2010
Powered by Community Server (Non-Commercial Edition), by Telligent Systems