19. september 2001 - 16:18Der er
10 kommentarer og 2 løsninger
search for date and show results
Hi There Im working on a script that does a search of people in my SQL database, the basic search is done but I am having craps loads of problems trying to do a search of the dates in the database
has anybody had any experience with this ? the date comes from an input area and is in the following format
18-08-2001
when it get passed to my search script I request it then run it thru this Function GetMyDate2 GetMyDate2 = FormatDateTime(Keyworda, 1) End Function
the value that then gets inserted into my search script looks like this 20. august 2001
My problem is this If fx I insert this date 20-08-2001 then I get the correct results back
However if i insert this date 20-03-2001 then i get the following error \"Syntax error converting datetime from character string.\"
It only happens when I edit the month ?? Please if anybody has a good idea or has had the same problem and help would be great Thanks Guzzie
I dette særtema ser vi på, hvordan cloud og AI bliver fundamentet for virksomhedernes digitale forretning, og hvordan de nye muligheder for automatisering og forretningsværdi kan udnyttes uden at miste overblik, sikkerhed og menneskelig kontrol.
Hu there dfens I have tried that already :( It produces the same result. The db is set up as short date dd-mm-yyyy I can allways throw up some source code if it would help my explanation ? Guzzie
guzzie> This question has been brought up a number of times. The correct way to SELECT a date from a SQL database is to you the U.S date format which is MM-DD-YYYY.
For example; SELECT Mydate from myTable where MyDate = #12-31-2001#
Function ConvertDate(MyDate) Dim MyDateArray MyDateArray = Split(MyDate,\".\") ConvertDate = MyDateArray(2) & \"-\" & MyDateArray(1) & \"-\" & MyDateArray(0) End Function
ok thanks guys I will split the points between you 2, terry> thanks for the info about SQL and US date format dfens> thanks for the split function it works just fine PS. dfens you have only \"Kommentar\" on my question and not a \"Svar\" so I cant split the points ? Guzzie
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.
