topic Re: script in QlikView

script

mario-sarkis — Fri, 22 May 2015 12:03:54 GMT

please help

i have this field

DateTime

1/6/2015 06:10:32PM

i need to extract only 1/6/2015 .

and please that this function didn't work it gives me a empty field:

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

so i am thinking to use the index function if it works and how to write it is it like this ?

Left(DateTime,index(DateTime," ") as Date ?

then i will get 1/6/2015 ?

Thank you ,

salto — Fri, 22 May 2015 12:13:06 GMT

Hi,

did you try:

Date(DateTime,'DD/MM/YYYY') as Date

HTH.

sunny_talwar — Fri, 22 May 2015 12:14:10 GMT

Try this:

Date(Floor(Date#(DateTime, 'M/D/YYYY hh:mm:ss tt')), 'M/D/YYYY') As Date

Gysbert_Wassenaar — Fri, 22 May 2015 12:14:15 GMT

Your format string isn't correct. There's a preceding 0 before the 6, so the format should have hh:mm instead of h:mm.

Or perhaps your DateTime function is already a timestamp. Have you tried simply date(floor(DateTime),'M/D/YYYY')?

Fri, 22 May 2015 12:24:11 GMT

Hi Mario,

Try this if you want to use the Index function:

Left(DateTime,Index(DateTime,' ')-1) as Date

mario-sarkis — Fri, 22 May 2015 12:29:34 GMT

Well Thank you Guyz it works with me like this

Makedate(year(DateTime),Month(DateTime),Day(DateTime)) as Date.

But i need to know why it works like this.

Clever_Anjos — Fri, 22 May 2015 12:37:53 GMT

Please test:

Date(Date#(subfield(DateTime,' ',1),'M/D/YYYY'))