I need dates instead of week numbers
I am working on a resource planning app. We need this done a weekly basis. I currently created fields for week 1 - week 52. This would work great if we used week numbers, but I really need dates, i...
Forum Discussion
I have the opposite issue, I need to convert the "Process Date" to show what week it falls in. First day of the year would be 12/30/2018, First day of the Week is Sunday...I'm new to QuickBase and struggling with Functions.
- I could even use the same set up as last day of the week being Saturday so the first week ending of the year would be 1/5/19. How do I convert this from the "Process date" within a week to identify the week in my "Week" field?
- It would be really long... but off the top of my head, if you already have a field named [Date] and make a formula-text field called [Week #] this should work for 2019, provided your desired output is "##-2019". The bad part is typing out all the options, but this should give you ideas.
Case([Date], Date(2018,12,31),"01-2019", Date(2019,1,1),"01-2019", Date(2019,1,2),"01-2019", Date(2019,1,3),"01-2019", Date(2019,1,4),"01-2019", Date(2019,1,5),"01-2019", Date(2019,1,6),"01-2019", Date(2019,1,7),"02-2019", ..., ..., null)