Hi, I am fetching Yesterday’s data from outlook and processing on it but I am stuck on weekends.
I need Friday’s data on Saturday’s run but not Saturday’s data on Sunday as Weekends are off.
And on Monday I don’t want to run my job as last day is Sunday and no one suppose to send email on Sunday.
Overall I want to run my job from Tuesday to Saturday.
Are you asking for assistance in scheduling/triggering a job to run Tuesday to Friday or are you asking for assistance with the logic in the process when checking the email?
For a Cron it would similar to the following where 2 would be Tuesday and 7 is Sunday.
15 09 * * 2-7
Typically Sunday is referenced with 0 or 7. Should also be able to use short form like TUE-SUN.
!Correction! UiPath doesn’t use what I am familiar with as it has seconds as well as Sunday starts at 1 and Saturday is 7 rather than Sunday being 0 or 7. With that in mind Tuesday would be 3 and Saturday would be 7.
you must be doing now.AddDays(-1) to get yesterdays date.
but if yesterday turned out to be Sunday then what? is your query
so what u can do id put if block activity and your condition would be Now.AddDays(-1).DayOfWeek.Equals(“Sunday”) then now.AddDays(-2) this would give you Saturday’s data on Monday instead of Sunday’s
Yes, that would be accepted and interpreted as “At 05:00 AM, only on Tuesday, Wednesday, Thursday, Friday, and Saturday”. When you enter in your Advanced/Cron expression, it validates it and will produce an error if it is not valid.
To shorten the expression you could use 0 0 5 ? * TUE-SAT which give you the same outcome but read as “At 05:00:00 AM, Tuesday through Saturday”.
┌─────────────seconds (0 - 59)
│ ┌───────────── minute (0 - 59)
│ │ ┌───────────── hour (0 - 23)
│ │ │ ┌───────────── day of the month (1 - 31)
│ │ │ │ ┌───────────── month (1 - 12 or JAN - DEC)
│ │ │ │ │ ┌───────────── day of the week (1 - 7 or SUN - SAT)
│ │ │ │ │ │ ┌───────────── year (1970 - 2099 or blank)
│ │ │ │ │ │ │
│ │ │ │ │ │ │
* * * * * * *
Alternatively, what you are looking for does not require the Advanced option you can simple select Weekly with your specific days.