Converting Date Type

[CP611]

So it is not a date type?


Use CDate() in that case.

Hi there, sadly that didn't work and ended up deleting my output table when trying to convert the data from one table to another

[Micron]

After 2 pages of posts I'd say it's time for you to copy and zip the db and post it. You only need whatever is required to replicate the issue, so any tables/forms/reports/etc. you don't want anyone to see can be removed from the copy. If there is sensitive info in there, consider randomizing. Just don't randomize the date fields involved in your issue.

https://www.accessforums.net/showthread.php?t=77482

[Welshgasman]

Hi there, sadly that didn't work and ended up deleting my output table when trying to convert the data from one table to another

Always, always use a Select first to make sure you have everything correct, then change to an Update/Append query.