topic Re: help on weekstart in QlikView

help on weekstart

Anonymous — Tue, 28 Jul 2015 11:58:25 GMT

Hi all,

i have below code

let vstart = '01/07/2015';

let vend = '31/07/2015';

i have to find the weekstart for these dates

i tried with below script on text boxes but it'not giving correct results

=weekstart(vstart)--- giving same start date .

Thanks

Anonymous — Tue, 28 Jul 2015 12:11:34 GMT

Try this:

let vstart = date#('01/07/2015', 'DD/MM/YYYY');

let vend = date#('31/07/2015';'DD/MM/YYYY');

sunny_talwar — Tue, 28 Jul 2015 12:16:26 GMT

or may be this:

=WeekStart(Date#($(vstart), 'DD/MM/YYYY'))

Bill_Britt — Tue, 28 Jul 2015 12:36:46 GMT

Here is a sample. The value let vstart = date#('01/07/2015', 'DD/MM/YYYY'); posted above will give you an incorrect date.

Bill

Anonymous — Tue, 28 Jul 2015 13:02:17 GMT

Hi Bill ,

The correct syntax is

=WeekStart(Date#(vend,'DD/MM/YYYY'))

Thanks

Bill_Britt — Tue, 28 Jul 2015 13:07:32 GMT

HI,

The let vend = date#('31/07/2015';'DD/MM/YYYY'); did work, but the let vstart = date#('01/07/2015', 'DD/MM/YYYY'); didn't.

Bill

Anonymous — Tue, 28 Jul 2015 13:25:43 GMT

This will also works

=WeekStart(Date#(vstart,'DD/MM/YYYY'));