topic Subtract 14 days from a date in QlikView

Subtract 14 days from a date

Sun, 23 May 2010 19:09:51 GMT

Hi,

I would like to subtract 14 days from a dates with the format 'DD.MM.YYYY hh:mm:ss[.fff]' and obtain as a result a date with the same format but 14 days earlier.

I believe this might be simple to solve but I'm struggling with this and I would appreciate if anyone could help me.

Thanks in advance!

Mariana

Subtract 14 days from a date

disqr_rm — Sun, 23 May 2010 19:25:19 GMT

Try this:

=date(OriginalDate-14, 'DD.MM.YYYY hh:mm:ss.fff')

Subtract 14 days from a date

Sun, 23 May 2010 19:32:53 GMT

Hi,

I already tried it and it creates random dates but these dates have nothing to do with OriginalDate -14.

Any more suggestions?

Thanks,

Mariana

Subtract 14 days from a date

Sun, 23 May 2010 19:39:33 GMT

Sorry!

I was looking for the wrong field...I think I'm just too tired ...

Your suggestion works!

Thanks once again.

Mariana

Subtract 14 days from a date

Sun, 13 Nov 2011 21:42:49 GMT

Hi, did you know how to get avegare sales of 14 days ago? It just like getting sales daily but only 14 days ago... 🙂 thanks.

Re: Subtract 14 days from a date

naveen409 — Fri, 07 Dec 2018 16:08:01 GMT

Hi Disqr_rm,

I am having similar question like this.

I want to See like First 7 Days of a month and 14 , 21, 28 days of a month

Can You help me?

Thanks in advance