Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!
Assuming you have this in the script
SET FirstWeekDay=6;
Try this
WeekEnd(Max(DateField))
Assuming you have this in the script
SET FirstWeekDay=6;
Try this
WeekEnd(Max(DateField))
Hi
Used a text object to display the weekend and used the expression =WeekEnd(Date)
See attached.
Hope it helps.
Thanks,
Monica