Date Issue

[jagannalla]

Hello,

I've a test file which contains the data as show below without any column name

05/04/2012 16:05:40 , 48

05/04/2012 16:13:40 , 256

05/04/2012 16:17:47 , 192

05/04/2012 16:26:18 , 431

05/04/2012 16:32:15 , 833

05/04/2012 16:40:29 , 369

05/04/2012 16:49:10 , 748

05/04/2012 16:51:10 , 467

05/17/2012 21:45:01 , 335

05/17/2012 21:51:11 , 457

05/17/2012 21:55:25 , 394

05/17/2012 22:00:59 , 446

05/17/2012 22:05:43 , 449

05/17/2012 22:09:53 , 242

- It i load the data in my qvw file the script is as shown below. I'm trying to get only dates from this but i can't get it exactly. I can able to see single wrong date only.

Main:

LOAD Date(@1,'M/D/YYYY') as TempDate,

     @2 as Value

FROM

C:\Users\Administrator.QLIKVIEW\Downloads\ImgCount.txt

(txt, unicode, no labels, delimiter is ',', msq);

[jagannalla · Accepted solution]

Main:

LOAD Date(Timestamp#(@1,'MM/DD/YYYY hh:mm:ss'),'MM/DD/YYYY') as TempDate,

     @2 as Value

FROM

C:\Users\Administrator.QLIKVIEW\Downloads\ImgCount.txt

(txt, unicode, no labels, delimiter is ',', msq);