topic Re: date & time feild in QlikView

date & time feild

Anonymous — Wed, 24 Jan 2018 04:26:06 GMT

hi,

i have feild with date & time (08-01-2018 15:39:03) , i want to make only date.

i write "date(ontdate)" as date

the result is - new feild "date" with the date , but i can't chose one date for all the data.

if i click on 08-01-2018 i only get 1 row that , not all the rows that happend on 08-01-2018.

hope it's undestood.

thanks'

yarin.

prma7799 — Wed, 24 Jan 2018 04:44:19 GMT

Have you tried this

Date(date#('08-01-2018','MM-DD-YYYY'))

Date(date#('08-01-2018','MM-DD-YYYY') , 'MM-DD-YYYY')

tamilarasu — Wed, 24 Jan 2018 04:44:31 GMT

Hi Yarin,

Try this.

Date#(Subfield(ONDATE,' ',1),'DD-MM-YYYY') as Date

Date(Date#(Subfield(ONDATE,' ',1),'DD-MM-YYYY'),'DD-MM-YYYY') as Date

Anonymous — Wed, 24 Jan 2018 04:48:32 GMT

i used the function

MakeDate(Year(ondate),Month(ondate),Day(ondate))

and it's working good.

thanks'