anoobs

Get Upcoming date of Saturday and sunday!

Discussion created by anoobs on Jun 18, 2018
Latest reply on Jun 21, 2018 by philmodjunk


Hi,

 

I have 3 Date fields and 1 text field

Category

start_Date

End_Date

Celebration_Date.

I entered current date in start_Date and inserted a date from december 2018 on End_Date. If Category field = "DJ" the Celebration_Date automatically enter the upcoming date of the saturday and if If Category field = "Rock" the Celebration_Date automatically enter the upcoming date of the Sunday. and if If Category field = "work" i could manually enter any date i want.

which means for a time period of months i need  Celebration_Date to show automatically the dates of upcoming saturday and sunday based on the value in Category Field. Also the Celebration_Date is capable of recieving manual entry if the Category has another value besides DJ and Rock! The Dates of upcoming saturday and sunday automatically update right after the previous saturday and sundays are over!

 

Grazie!

Outcomes