Discussion board where members can get started with QlikView.
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!
Go to Solution.
=date(OriginalDate-14, 'DD.MM.YYYY hh:mm:ss.fff')
I already tried it and it creates random dates but these dates have nothing to do with OriginalDate -14.
Any more suggestions?
I was looking for the wrong field...I think I'm just too tired ...
Your suggestion works!
Thanks once again.
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.