importing partial string of data

[#1]

Hello,

I have following informaiton that I need to import from CSV file, mixed with dates and times as below.

5/1/2012 9:00

5/1/2012 9:00

5/1/2012 10:30

5/2/2012 9:30

5/10/2012 14:00

5/17/2012 9:00

5/21/2012 11:00

How can I just import the dates since I cannot use left function...?

thanks for your help!

[swuehl · Accepted solution]

In your load, use something like

LOAD

...

Date(Daystart(Timestamp#(YOURFIELD,'D/M/YYYY hh:mm'))) as Date,

...

from Table;

[perumal_41]

Hi

In your load, use this script 

LOAD

...

Date(YOURFIELD,'M/DD/YYYY') as Date,

...

from Table;

[#4]

Thank you all for your response!

I know I should've checked but here at my work, it is everyday emergency situation!

swuehl, it worked perfect!

thank you both again!