UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> Convert text date to date format    
 
   
swaziman1
post Nov 7 2007, 05:10 AM
Post #1

UtterAccess Ruler
Posts: 1,063
Hi,

I have a table where the month field shows as eg.'Nov-07' , however this is a text field
and I want to convert it to a Date/Time field but still have it show as mmm-yy,
does anyone have any suggestions how I can do this? I have tried cDate but this just gives me an error.

Thanks
Go to the top of the page
 
+

Posts in this topic
- swaziman1   Convert text date to date format   Nov 7 2007, 05:10 AM
- - Peter46   Re: Convert text date to date format   Nov 7 2007, 05:15 AM
- - swaziman1   Re: Convert text date to date format   Nov 7 2007, 05:26 AM

« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Switch to: Standard · Switch to: Linear+ · Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 20th May 2013 - 01:24 AM