I have following informaiton that I need to import from CSV file, mixed with dates and times as below.
How can I just import the dates since I cannot use left function...?
thanks for your help!
In your load, use something like
Date(Daystart(Timestamp#(YOURFIELD,'D/M/YYYY hh:mm'))) as Date,
In your load, use this script
Date(YOURFIELD,'M/DD/YYYY') as Date,
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!
Retrieving data ...