Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Subtract 14 days from a date

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



1 Solution

Accepted Solutions
disqr_rm
Valued Contributor III

Subtract 14 days from a date

Try this:

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



4 Replies
disqr_rm
Valued Contributor III

Subtract 14 days from a date

Try this:

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



Not applicable

Subtract 14 days from a date

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



Not applicable

Subtract 14 days from a date

Sorry!

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

Your suggestion works!

Thanks once again.

Mariana

Not applicable

Subtract 14 days from a date

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.