|
| |||||||
| Sponsored Links |
 | « Previous Thread | Next Thread » |
| | LinkBack | Thread Tools | Display Modes |
|
#1
July 6th, 2008, 11:43 AM
| |||
| |||
 convert problem Hi, I am using access strsql="SELECT Distinct State from Camps where Convert(datetime,Camp_Date) > getdate()" The Camp_Date field is a text field in table Camps the data for example stored in camp_date is like this 3/3/2009 it gives me an error saying Undefined function 'Convert' in expression can someone tell me what i am doing wrong todd  |
| Sponsored Links |
|
#2
July 6th, 2008, 12:03 PM
| |||
| |||
| Access doesn't have a Convert function for datetime, SQL server does Access doesn't have a function called getDate(), SQL server does What you're looking for is to use CDate as follows Code: strsql="SELECT Distinct State from Camps where CDate(Camp_Date) > Today()" |
|
#3
July 7th, 2008, 02:17 AM
| ||||
| ||||
| lol, what you need is,. Code: strsql="SELECT Distinct State from Camps where CDate(Camp_Date) > Date()"
__________________ If i helped you, make me famous by clicking the  |
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| convert problem | todd2006 | ASP Development | 5 | June 27th, 2008 03:47 PM |
Linear Mode
