Date formating issue

[Guest_imported]

Hi folks,

My database return date result formatted mm/dd/yyyy
How can I cahnge this to dd/mm/yyyy ?

Thanks in advance

Kiryan

 

[princeshri]

Put this @ the top of the asp scripts,

<%@ LCID = 2057 %>


HTH,


Shri

 

[Guest_imported]

This works fine thanks, but on the other hand, it creates a conflict with my calendar.

Any idea why such a line:
<%@ LCID = 2057 %>
could stop something that handles date from an access database to work?

 

[cmmrfrds]

You can control the format when you retrieve the date. What database are you using? Access? SQL Server? Other?

 

[princeshri]

actually, LCID is a locale definition for the UK so, it is possible to have conflicts. I am not sure that you mean by your calendar but if you dont want to use LCID, you could also try the fmtDateTime() function from,

http://www.aspfree.com/authors/kevin_turner/datetime.asp

these links might also be useful

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q306044

HTH,


Shri

 

[Guest_imported]

dear cmmrfrds,

I use access


Dear princeshri,

thanks for the kinks,
I'll surely take a look at it this evening.
Thanks for your answers,

Mrkiryan