topic Re: Date Function in QlikView

Date Function

Fri, 20 Nov 2020 18:02:30 GMT

hi all,

I am new to QV,I stucked with these date function.9/22/2015 12:00:00 AM ,i want to show these date like 9/22/2015 excluding time stamp.I have tried these but it is not working =date(date#('9/22/2015 12:00:00 AM','M/DD/YYYY h:mm tt'),'MM/DD/YYYY').

Can any one help on these

Regards,

Sruthi

Re: Date Function

maxgro — Tue, 24 Mar 2015 16:54:00 GMT

use floor function for date part

=floor(date#('9/22/2015 12:00:00 AM','M/DD/YYYY hh:mm:ss tt'))

and frac for time

Re: Date Function

Gabriel — Tue, 24 Mar 2015 16:57:51 GMT

Hope this help

=Date(Floor('9/22/2015 12:00:00 AM'),'MM/DD/YYYY')

Re: Date Function

Anonymous — Tue, 24 Mar 2015 18:26:09 GMT

Try this.

=Date( Timestamp#('9/22/2015 12:00:00 AM','MM/DD/YYYY hh:mm:ss tt'),'MM/DD/YYYY')

Re: Date Function

Wed, 25 Mar 2015 05:28:37 GMT

Hii

Try this expressions

dual( Date('YYYY-MM-DD') & time('hh:mm:ss').

floor(TimeStamp) will give data.

TimeStamp - Floor(TimeStamp) will give Time

Both will have to be formatted.

=timestamp(Your Field,'h:mm:ss TT')

Re: Date Function

senpradip007 — Wed, 25 Mar 2015 05:33:56 GMT

Use this

=date(date#('9/22/2015 12:00:00 AM','M/DD/YYYY h:mm:ss TT'),'MM/DD/YYYY')

Re: Date Function

Anonymous — Wed, 25 Mar 2015 05:43:15 GMT

Sruthi,

Just go through HIC blog .. you will be clear on date functions .

The Date Function

Thanks

BKC