topic Re: Script in QlikView

Script

mario-sarkis — Fri, 22 May 2015 07:51:37 GMT

hey all ,

need help and this is my Question :

i have this Field

DateTime

6/1/2014 6:30:20PM

6/1/2015 7:30:20AM

10/1/2013 8:30:20PM

6/1/2015 5:30:20PM

8/1/2012 6:30:20PM

This an example of a field i have, how can i extract the Date and time separetly in the Script

i used already this >>>>>date(floor(timestamp#(Interaction_Dttm,'M/D/YYYY h:mm:ssTT'))) as Date

But it give me an null Field .

Hope anyone Can help in this

Thank you in advance.

Re: Script

jonathandienst — Fri, 22 May 2015 08:13:53 GMT

Date(Floor(Date#(DateTime, 'M/D/YYYY h:mm:ssTT'))) As Date,

Time(Frac(Date#(DateTime, 'M/D/YYYY h:mm:ssTT'))) As Time

Re: Script

jonathandienst — Fri, 22 May 2015 08:16:39 GMT

Have you got leading spaces in DateTime?

Date(Floor(Date#(Trim(DateTime), 'M/D/YYYY h:mm:ssTT'))) As Date,

Time(Frac(Date#(Trim(DateTime), 'M/D/YYYY h:mm:ssTT'))) As Time

Re: Script

mario-sarkis — Fri, 22 May 2015 08:37:16 GMT

HI Jonathan

it still give me an empty fields

but when i put ur expression in the list BOX that contain The DateTime

it Give me like this

DateTime

6/1/2014-

6/1/2015 -

10/1/2013 -

6/1/2015 -

8/1/2012 -

can you help More ?

Re: Script

MayilVahanan — Fri, 22 May 2015 09:47:53 GMT

Try like this

Load DateTime, Date(Floor(Date#(Date, 'M/D/YYYY h:mm:ssTT'))) AS Date, Time(Frac(Date#(Date, 'M/D/YYYY h:mm:ssTT')),'h:mm:ss') AS Time;

Load *, Trim(DateTime) As Date Inline

[

DateTime

6/1/2014 6:30:20PM

6/1/2015 7:30:20AM

10/1/2013 8:30:20PM

6/1/2015 5:30:20PM

8/1/2012 6:30:20PM

];

Re: Script

mario-sarkis — Fri, 22 May 2015 11:48:55 GMT

Hi Mayil Date Time is already a field that i have in my data i didnt understand the INLINE part please can you explain and why in your opinion while using the function that u gave the new field shows empty

Thank you hope you can help