Databases
StackOverflow2013
Postsdbo
POConvert a Text to a DateTime in access
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POConvert a Text to a DateTime in access
    primarykey
    data
    text
    <p>So i have a field that datatype is a text which is feed into the database. What it returns is something along the lines of this:</p> <blockquote> <p>ddd MMM dd hh:mm:ss yyyy</p> </blockquote> <p>What i would like for it to do is be displayed as something like this:</p> <blockquote> <p>ddd MMM dd yyyy hh:mm:ss</p> </blockquote> <p>I can achive this by using Format() which would look like this:</p> <pre><code>Format(alarmdet.AlarmStart, "ddd MMM dd yyyy hh:mm:ss) AS AlarmDateTime </code></pre> <p>So that is all well and good, however; i want to beable to convert this value into a datetime. I've tried using CVDate, CDate, DateValue and every time i get returned an error claiming a mismatched datatype. How would i go about converting this exact string into a datetime?</p> <p><strong>Note:</strong></p> <p>So you are aware, i am able to get it to convert successfully when in the English(united states) locale, but i am attempting to get this to work in the Portuguese(portugal) locale. In this locale i get the mismatch datatype error which i think has something to do with how access reads the abrivated months. Is there something i am missing to make this successfully work in an international setting?</p> <p>Also i would like to convert something similar to this in a different field to have it appear as so:</p> <blockquote> <p>MM/dd/yyyy</p> </blockquote> <p>Again i know i can get this using Format(), but i would like to to be converted into a DateTime. How would i go about doing this?</p> <p>Any help or suggestions are greatly appreciated.</p> <p>Thanks.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJames213
    1. USJames213
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COWould you add an example of what the text strings really look like, please? If the MMM values are the same as English month names, this could be part of the problem. You might need to Format the string as a US datetime, then use CDate to save it as a date time, then set your locale to Portugal, and do the formatting one more time to fit Portugese naming for months.
      singulars
      1. POConvert a Text to a DateTime in access
      1. USJennifer S
    2. COThis is a presentation-level issue, not a SQL issue. Why do you think you need this format in SQL?
      singulars
      1. POConvert a Text to a DateTime in access
      1. USDavid-W-Fenton
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload