help on weekstart

[Anonymous]

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 · Accepted solution]

Try this:

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

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

[sunny_talwar]

or may be this:

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

[Bill_Britt]

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]

Hi Bill ,

The correct syntax is

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

Thanks

[Bill_Britt]

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]

This will also works

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