Get next Saturday Date

[microwin88x]

Hello,

I have a Listbox with dates, for example:

11/10/2017

11/11/2017

11/12/2017

11/13/2017

11/14/2017

11/15/2017

...

If I select any date, I need to know which is the next Saturday for that date.

For example: I select 11/15/2017 (Wednesday)> then I get 11/18/2017 (Saturday).

     If I select 11/13/2017 (Monday)> then I get 11/18/2017 (Saturday).

     If I select 11/19/2017 (Sunday)> then I get 11/25/2017 (Saturday).

Is there any way to do that?

Thank you!!!

[sunny_talwar · Accepted solution]

Assuming you have this in the script

SET FirstWeekDay=6;

Try this

WeekEnd(Max(DateField))

[Monicalingan]

Hi

Used a text object to display the weekend and used the expression =WeekEnd(Date)

See attached.

Hope it helps.

Thanks,

Monica