topic Help with calculating 2 weeks Prior Date in QlikView

Help with calculating 2 weeks Prior Date

nadkalyan — Wed, 13 Jul 2011 19:16:10 GMT

Hi,

I am trying to write a expression in a list box based on date to acheive a date prior 2 weeks.

Here is my expression -

=Date(Date#((LoadedDate -14), 'DD/MM/YYYY'))

I get no results when tried above expression.

Can someone please explain me what is the correct expression to acheive this.

Re: Help with calculating 2 weeks Prior Date

johnw — Wed, 13 Jul 2011 20:33:31 GMT

Assuming you're using the default date format:

date(LoadedDate-14)

If you need to override it:

date(LoadedDate-14,'DD/MM/YYYY')

The date#() function converts text into the numeric representation of the date. You don't have text. You have a number. So the date#() function isn't what you need.

This is all assuming your LoadedDate is already a QlikView date, and isn't itself a text field.

Help with calculating 2 weeks Prior Date

nadkalyan — Wed, 13 Jul 2011 20:41:19 GMT

Thanks John,

date(LoadedDate-14) works exactly i wanted. I was confused by date# function.