Hello!
I have built a web app for work and in one of the fields, "Week Of", I want to have the upcoming Friday as the default value, but having trouble building an expression to do so. Any help would be appreciated! Thanks!
Hello!
I have built a web app for work and in one of the fields, "Week Of", I want to have the upcoming Friday as the default value, but having trouble building an expression to do so. Any help would be appreciated! Thanks!
look at using the weekday function (google it) this returns the day of the week as a number - depending on the default start of week. This can then be added to date() to give you Friday's date
As ajax said
If week starts with Sunday, then Friday is Day 6,
Date + 6-(weekday(date)) is probably the next Friday