Topics Search

Converting Date to Text

Converting Date to Text
Views: 19
I have the following Sql code that I would like to use in Access. What would the syntax be. I tried using Text inplace of convert but have not had any luck.

convert(char(8), bookdate
Sponsored Links:

More topics

 

Converting Integar date to normal date.

Preview
I imported some data into an Access table and it is a Long Integer. ex. 20091209. I tried converting the field to a Date/Time and it wouldn't let me. What would be the best way to convert this to 12/09/09? I could create a new field in the table and run an Update query using the Format command possibly?

I tried converting it on the form but no Date options were available
 

Converting a Text Date String to a Date for Calculations

Preview
I'm just jumping into Access and have the following question. In my Purchase Order Table, I have a date field calcualated as text, i.e. "01/12/04". I need to convert this to a date format in my queries so I can do calculations, i.e. 01/12/04 - 01/05/04 = 7 days. Can someone help me with how to convert this text date to a date format
 

Converting text date to number date

Preview
I'm currently having trouble with the Cdate(expression). I don't quite understand how to apply it.

I have a table that contains a field titled LD with the following date format: "2011-01-12 11:00", but in text format.

Does anyone know How to eliminate the time and convert the text date into a number date so that I can apply conditional formatting to it?
 

converting yyyymmdd dates to serial date number

Preview
I have two tables that I want to append to each other.But in one of them the date column has the yyyymmdd format and in the other it is a serial date number.How can I make them consistent by either converting yyyymmdd to date number or by converting the date number to yyyymmdd
 

Converting yyyymmdd dates to serial date number

Preview
I have two tables that I want to append to each other.But in one of them the date column has the yyyymmdd format and in the other it is a serial date number.How can I make them consistent by either converting yyyymmdd to date number or by converting the date number to yyyymmdd
 

Coverting Text (02Jan2011) to Date (01/01/2011)

Preview
I am having trouble in converting text 02Jan2011 to date 02/01/2011.
Can anyone tell me how I can conveert a column in a table from text to date. please
 

Converting Text column with a date/time to a Date column with only the date.

Preview
I have a text column with a date/time that loos like the example below.

1/22/2009 12:00:00.000000 AM

I would like to populate a column with just the date in the date format.

1/22/2009

Would CDate work? If so, how would I write it VBA format or SQL (not very familiar with it though)?
 

Converting text to date

Preview
I am importing data from a text file, some of the imported data are dares, written in the following format:
12mar2009

The problem is that the data is stored as text and not as date type of data, which makes it difficult to do mathematical procedures on that type of data
is there a function/way to convert that to "real" date data
 

Converting text string to Date Format

Preview
I imported a file to Access in text format. I now need to convert several fields to date format xx/xx/xxxx.

I'm not familiar with how to write the expression needed to use CDate in an Update Query
 

Converting a string to date/time

Preview
I have a large text file to be imported into Access 2010. Several of the fields are date/time fields. The text file formatting of the date/time is as follows:

20120412092134

I can take this string and convert it so that it looks like this

04/12/2012 09:21:34

but when I use any of the builtin conversion functions I normally use all I actually get is the date the time gets stripped off. Is there a builtin conversion function for this that I'mnot finding or do I need to build one myself?