Importing a date field that includes min, secs...

Hello.

I am having problems trying to import from a text document a date field that includes minutes and seconds. The text format is as follows:

2002-06-13 00:00:00.000

I cannot get the date to import at all. I only need the date data and not the time data.

How do I get this to import?

Comments

  • : Hello.
    :
    : I am having problems trying to import from a text document a date field that includes minutes and seconds. The text format is as follows:
    :
    : 2002-06-13 00:00:00.000
    :
    : I cannot get the date to import at all. I only need the date data and not the time data.
    :
    : How do I get this to import?
    :
    You can't import it directly to a date field. You'll need to import it to a string and then operate on it (using the Left() and Right() and similar functions) to pull the date information out and store it into whatever date field you like.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion