Convert DateTime String??!!??

[Dineedshelp]

I have an access database linked to a sql server. Basically all the date in the SQL server are a datetime string. Is there anyway with access I can change these to just dates so I can compare varous dates being pulled accross?

Please help!!! Its driving me mad!! Help files are as useful as a chocolate fire guard!!!!

 

[Appollo14]

Hi Dineedshelp,

had a similar problem meself and requested help to sort it. Here's a link to the posts that helped me get it sorted.

http://www.tek-tips.com/viewthread.cfm?qid=815006

Hope it helps you,
Regards,
Noel.

 

[dhookom]

I would remove the time part of the value using DateValue([YourField]).

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]