M maya Registered User. Local time Today, 14:52 Joined Jun 11, 2003 Messages 139 Sep 22, 2003 #1 How do i sort serach results by date and time? i tried to sort by date and it works but when i sort by date and time, the time gets sorted but the date gets jumbled up again. Pls help, thanks
How do i sort serach results by date and time? i tried to sort by date and it works but when i sort by date and time, the time gets sorted but the date gets jumbled up again. Pls help, thanks
W WayneRyan AWF VIP Local time Today, 14:52 Joined Nov 19, 2002 Messages 7,120 Sep 22, 2003 #2 Maya, Do you have a date field and a time field? Wayne
M maya Registered User. Local time Today, 14:52 Joined Jun 11, 2003 Messages 139 Sep 22, 2003 #3 yes the date and time field is separated
W WayneRyan AWF VIP Local time Today, 14:52 Joined Nov 19, 2002 Messages 7,120 Sep 22, 2003 #4 maya, If they each appear to work individually, then just sort by the date, then the time: order by TheDate, TheTime Wayne
maya, If they each appear to work individually, then just sort by the date, then the time: order by TheDate, TheTime Wayne
M maya Registered User. Local time Today, 14:52 Joined Jun 11, 2003 Messages 139 Sep 22, 2003 #5 tried yes, i tried that way and the date gets jumbled up... Order BY [MyDate] AND [MyTime] thats the syntax i used and it does not work...only the time gets sorted and i tried Order By [MyDate] AND Order By [MyTime] noithing comes out....
tried yes, i tried that way and the date gets jumbled up... Order BY [MyDate] AND [MyTime] thats the syntax i used and it does not work...only the time gets sorted and i tried Order By [MyDate] AND Order By [MyTime] noithing comes out....
W WayneRyan AWF VIP Local time Today, 14:52 Joined Nov 19, 2002 Messages 7,120 Sep 22, 2003 #6 Maya, Do not put the word AND between them, just a comma: order by date, time Just a comma. Wayne
M maya Registered User. Local time Today, 14:52 Joined Jun 11, 2003 Messages 139 Sep 22, 2003 #7 u saved my day...thanx
