I have a brain drain problem with how I should set up a dynamic date formula, I have 2 tables in a base, one for odd weeks and one for even weeks. They both just contain 5 records, one for each workday. I have separate fields where the current date is shown, current weekday, current week number and if the current week is odd or even (it shows 0 for even and 1 for even). Now to the tricky part.
I want to show in a field in the even table (week 50), lets say today Wednesday the 14th of dec. I want todays date to be visible in that field, on Tuesday the 13th should be visible and on tomorrow the 15th and so on. And I also want if the dates in the odd table shows next weeks date, and then when it becomes an odd week the even table updates the dates to the week after the odd. Any of you geniuses have a solution in mind?
Solved! Go to Solution.
Hi @Andrey_Kovalev sorry but that didn't do the trick. Since there are 2 tables, one for odd weeks and one for even weeks they get the same date hence the auotnumber is the same 1-5. So I don't really know how to get forward
The formulas for the name, week and Odd even works fine.
Hi @Andrey_Kovalev , The formula doesn't work like I want to, maybe I explained it wrong. The 2 weeks calendar should be "rolling", i.e today the 14th will after midnight local time change the date to Wednesday in 2 weeks time, the 28 th. Any ideas would be much appreciated?
HI @Andrey_Kovalev , thank you for your time. There are just 10 records (2 weeks of workdays) , the 14th will be replaced with a new date, just a date change when passing midnight on the right day. As you see in the picture I now use the same table for both odd and even weeks. So the 14th should have changed date to 28th yesterday midnight because its the next upcoming even Wednesday.