Hi,
I am stuck at how to find most recent friday of the week.
Previous Sunday = Today.AddDays(- (Weekday(Today) - 1))
similarly , i am looking for previous friday code. Can anyone help me with this ?
Check this link Return date from previous week
Below expression returns Friday from previous week:
DayOfWeek WeekFriday = DayOfWeek.Friday;
int offsetDays = (int) WeekFriday - (int) DateTime.Now.DayOfWeek;
DateTime lastWeekFriday = DateTime.Now.AddDays(-7 + offsetDays);
or
DayOfWeek WeekFriday = DayOfWeek.Friday;
DateTime lastWeekFriday = DateTime.Now.AddDays(-7 + ((int) WeekFriday - (int) DateTime.Now.DayOfWeek));
4 Likes
Hi @ramees.pk,
@neetha’s solution is a perfect one if you would like to get the Friday of last week.
In order to get the recent Friday, we need to make an alteration to @neetha’s code.
DayOfWeek WeekFriday = DayOfWeek.Friday;
int offsetDays = cint(WeekFriday) - cint(DateTime.Now.DayOfWeek)
If(offsetDays <=0)
then, DateTime lastWeekFriday = DateTime.Now.AddDays(offsetDays);
Else, DateTime lastWeekFriday = DateTime.Now.AddDays(-7 + offsetDays);
Warm Regards,
Nimin
3 Likes
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.