DATE/TIME 1

[jmob]

I'm having a tough time selecting rows where the date is > '1/1/2004' in that format.
I am using select * from table where column > '1/1/2004' ;

Any possibilities on why it is saying there is a data type mismatch? It is in DATE/TIME format , and in the short date format matching what I have for the column. I even tried chaning the column to text and doing a like %2004 comparison. the like doesn't return anything.

Any ideaS?. Thanks.

JMoB

 

[r937]

access uses octothorps to delimit its date strings

... where column > #1/1/2004#

r937.com | rudy.ca

 

[jmob]

Thank you so much! Enjoy the Independence Weekend!

 

[r937]

thanks

however, we don't celebrate your independence day in our country

;-)

r937.com | rudy.ca

 

[SilentAiche]

r937,

[way-the-heck-off-topic]

"[purple]Octothorps[/purple]???"

I have never heard of "#" called anything but a Pound Sign. A Canadian thing, perhaps? Or do I just need to get out more?

I'm used to seeing terrific solutions in your posts, but I wasn't expecting a new word for something as simple as a pound sign. Thanks for the boost to my vocabulary!

Tim

[/back-to-topic...]

[blue]_____________________________________________________
If you need immediate assistance, please raise your hand.
If you are outside of Raleigh, raise your hand and say[/blue] [red]Ooh! Ooh![/red]

 

[earthandfire]

Tim,

http://dictionary.reference.com/search?r=2&q=Octothorpe

By the way the pound sign looks like this: £

 

[jmob]

Ahh the bloody English triumph once again. The pound sign over here in the U.S. is the '#' not the ### We keep it simple with many words for many meanings.. back the the cave man days we go. ugghh ughh

 

[SilentAiche]

earthandfire,

Your pound sign makes no cents.


Tim


hmmm, [red]+[/red] = "quadrothorpe" ???

[blue]_____________________________________________________
If you need immediate assistance, please raise your hand.
If you are outside of Raleigh, raise your hand and say[/blue] [red]Ooh! Ooh![/red]

 

[earthandfire]

Very good, SilentAiche but does your octothorpe?