Forums
This topic is locked
Date problem, drives me mad
11 May 2002 07:10:04 Garo Maka posted:
Im having a dateformat problem. Have tried several sugestions, but no solution yet. Meaby its because I dont know how or where to insert the code. Its actually begining to feel as a inferiority complex <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>Im making an event calender. The date in the databse shows correct that is dd-mm-yyyy, the resultsPage shows also correctly. But it searches for mm-dd-yyyy.
I read a couple of guys in the forum having the same problem, but there was no asnver.
I figure that the date format pased from the search to the database is in wrong format, I just dont understand how this can be. Or how to change it, should I make a dateformat code in the form or textfields?
Its driving me crazy, please help
Thanks
Garo
Replies
Replied 13 May 2002 17:15:58
13 May 2002 17:15:58 Julio Taylor replied:
have you tried pulling the date from the database using the SQL DATE() functions? You didn't say if you're using MySQL or Access, but if you're storing your date in MySQL format you can use the following functions to resolve date items.
for exmaple, you can use DAYOFWEEK(fieldname), and it will return 'Monday' etc. You can use other functions like YEAR, DAYOFMONTH, MONTH and so forth.
If you're using access then i suggest you look at the regional settings of the server vs. the client/production server and see if it's due to some manky unreported shitty microsoft bug which has been wildly under-documented.
i hope it helped (i doubt it)
P.S. i killed kenny
for exmaple, you can use DAYOFWEEK(fieldname), and it will return 'Monday' etc. You can use other functions like YEAR, DAYOFMONTH, MONTH and so forth.
If you're using access then i suggest you look at the regional settings of the server vs. the client/production server and see if it's due to some manky unreported shitty microsoft bug which has been wildly under-documented.
i hope it helped (i doubt it)
P.S. i killed kenny