topic Most used date functions in QlikView

Most used date functions

Wed, 30 Apr 2014 07:43:15 GMT

Hi all ,i need most used date functions in QV with examples ,,, can any one reply .. examples must be simple understanding method ,please reply

Re: Most used date functions

Wed, 30 Apr 2014 07:45:02 GMT

you should check this in the qlikview help. there all functions descriped pretty good and understandable.

regards,

Re: Most used date functions

its_anandrjs — Wed, 30 Apr 2014 07:46:17 GMT

Read this master calendar document there you find all date functions

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar

Creating A Master Calendar

Master Calendar in QlikView | Learn QlikView

Re: Most used date functions

vijetas42 — Wed, 30 Apr 2014 08:02:17 GMT

Hi,

Please refer these threads to use date functions,

http://community.qlik.com/message/401069#401069

http://community.qlik.com/message/477865#477865

Re: Most used date functions

martinpohl — Wed, 30 Apr 2014 08:12:01 GMT

Examples:

date(datefield,'YYYY-MM-DD') as date -> load the field datefield and formats it into YYYY-MM-DD

date(date#(datefield,'YYYYMMDD'),'YYYY-MM-DD') as date -> load the field datefield with formatted YYYYMMDD and formats it into YYYY-MM-DD

year(datefield) as year -> returns the year from the datefield

year(date#(datefield,'YYYYMMDD')) as year -> returns the year from the datefield formatted YYYYMMDD

so there are many examples, look at the help / time functions

Re: Most used date functions

Wed, 30 Apr 2014 08:15:04 GMT

What is the use of date() and Date#() will any one explain,,, with simple examples

Re: Most used date functions

its_anandrjs — Wed, 30 Apr 2014 08:16:24 GMT

I think you got correct answer from the thread so mark the thread as correct or helpful for others reference.

Regards

Re: Most used date functions

martinpohl — Wed, 30 Apr 2014 08:19:51 GMT

with date(datefield,'YYYY-MM-DD') you set the format settings from the field to the defined format (to use on visualation e.g. in listbox)

with date#(datefield,'YYYY-MM-DD') you set the format of the format settings from the field which are not equal to your standard settings of the os.

The syntax in words:

load the field datefield as a date field but the format of this field is YYYY-MM-DD

Regards

Re: Most used date functions

its_anandrjs — Wed, 30 Apr 2014 08:20:16 GMT

Suppose you have date as format 30042014 which is not in the date format so for date format you need to convert it into date format but first in current format convert it into date number like

Date#(3004214,'DDMMYYYY') So you convert this into 30042014 date format

and after that if you want to convert its date format then use

Date(Date#(3004214,'DDMMYYYY'),'DD/MM/YYYY')

Re: Most used date functions

Wed, 30 Apr 2014 08:34:30 GMT

Thanks

Re: Most used date functions

anbu1984 — Wed, 30 Apr 2014 08:43:23 GMT

QlikView Date fields

Re: Most used date functions

its_anandrjs — Wed, 30 Apr 2014 08:49:37 GMT

Hi,

Closed the thread by appropriate answer like correct / helpful for references.

Regards