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

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> 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
 
+
Peter46
post Nov 7 2007, 05:15 AM
Post #2

UtterAccess VIP
Posts: 7,397
From: Oadby Leics, UK
Cdate("01-" & fieldname)
Go to the top of the page
 
+
swaziman1
post Nov 7 2007, 05:26 AM
Post #3

UtterAccess Ruler
Posts: 1,063
perfect , thanks
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

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

Jump To Forum:
 

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

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

RSS Go to Top  ·  Lo-Fi Version Time is now: 24th May 2013 - 03:34 PM