Get last weekday

Help Studio
, ,
1

Hi there,
Please assume there is a textbox that requires user to enter a weekday (Sunday/Monday/Tuesday/Wednesday/Thursday/Friday/Saturday).
Based on the input, select the last weekday.

2

Hi @niro

Do you always want a last a previous Tuesday?

3

Hi @niro

You can use this Today.AddDays(-4-Weekday(Today))
Assign it to a datetime variable.

Thank you,
Prashant

4

Hi Prasanth, I just edited my question to a better one. I would want the day to be dynamic, so I can’t use constant such as AddDays - digit. I need some other way to identify the intended previous weekday

5

Try You can use this Today.AddDays(-4-Weekday(Today))
Assign it to a datetime variable.
this

6

It is dynamic in nature.

7

Quick n dirty Demo on the Main Logic of retrieving the previous Workday
grafik

Sunday: -3
Mo: -4
Tue-Fr: -1
Saturday: -2
grafik

Running test:

grafik
grafik753×137 60 KB

Kindly note: Topic Title: previous Workday vs. Description Friday-Tuesday. However the offset can be adopted within the Array: First Position (0) = Sunday, Mon, Tue…, Sat)

3 Likes
9

I’m sorry, I just had a tough time explaining. How would this work for the below?
Please assume there is a textbox that requires user to enter a weekday (Sunday/Monday/Tuesday/Wednesday/Thursday/Friday/Saturday).
Based on the input, select the last weekday.

10

@niro
please give us exact details on your case, selectbox …

the substraction should be done on todays date?

2 Likes
11

based on the input by user. if user enters Monday, the robot should return last Monday. it does not matter what day it is today, it should just return the previous weekday according to the user input

12

Ok, but is a different requirement. So case is about:

  • Select dayname from input dialog
  • return day of dayname from last week

Right?

13

Yes. Return the date of dayname from last week

14

ListCheckDate.xaml (9.0 KB)
Check this and let me know if it is working as expected.

1 Like
15

@niro
Variables:

grafik
grafik874×167 51.8 KB

Flow:
grafik

idxDay = Array.IndexOf(arrDayNames,selectedDayName) + 1
Offset =(idxDay - IF(today.DayOfWeek=6,7,today.DayOfWeek)) - 7
DateLastWeek = Today.AddDays(Offset)

Find starter Help here:
GetLastWeekDay_ByDayName_FromToday.xaml (6.5 KB)

3 Likes
16

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.