topic Re: how to get the date ?? in QlikView

how to get the date ??

suvechha_b — Tue, 16 Jul 2013 08:19:28 GMT

How can I caluclated in qlikview a date ??

How to achieve this ??

I have a fieldname batch_expiry = 2013/06/12

I have another field days like 60,90,30

I have to subtract 2013/06/12 - 60 and get the date ??

The answer should be 2013/04/12

Re: how to get the date ??

jonathandienst — Tue, 16 Jul 2013 08:33:07 GMT

If your date is a normal QV date field, then the date is just a number, so you can do

=Date(Batch_Expiry - 60)

The Date() function ensures that the result still shows in date format, rather than number format

Hope that helps

Jonathan

Re: how to get the date ??

alexandros17 — Tue, 16 Jul 2013 08:34:09 GMT

To add a number of days, transform your date to numeric format: num(myDate) and subtract the quantity; at the end transforma again in date:

Date(num(myDate)-30)

Hope it helps

Re: how to get the date ??

pennetzdorfer — Tue, 16 Jul 2013 08:37:22 GMT

Does Qlikview recognize your datefield (batch_expiry) as date? You can check that by creating a listbox and changing the number format to integer ...

If not, you will have to convert your date field in the script:

date(date#(batch_expiry,'YYYY/MM/DD'),'YYYY/MM/DD') as batch_expiry

For further information on date fields, see Henric Cronströms Technical Brief: http://www.qlikcommunity.com/docs/DOC-3102

Regards,

Florian

Re: how to get the date ??

er_mohit — Tue, 16 Jul 2013 08:59:28 GMT

try this in text object

=Date(Date#('2013/06/12','YYYY/MM/DD')-60,'YYYY/MM/DD')

Re: how to get the date ??

saumyashah90 — Tue, 10 Dec 2013 06:17:37 GMT

Hi Jonathan

Can you please look at this

http://community.qlik.com/thread/101146?start=0&tstart=0

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

Re: how to get the date ??

Tue, 10 Dec 2013 07:51:18 GMT

Please find the solution given below:-

Regards

Vineet

Re: how to get the date ??

Tue, 10 Dec 2013 07:54:15 GMT

Please stop refering to your own post in other topics. They will get answered if someone got an solution

Re: how to get the date ??

Anonymous — Tue, 10 Dec 2013 07:57:54 GMT

What Jonathan is saying is 100 % correct i have also tested it.

anant

Re: how to get the date ??

Tue, 10 Dec 2013 08:09:07 GMT

Yes vineet is correct