Forum Discussion

JuliePlummer's avatar
JuliePlummer
Qrew Trainee
7 years ago

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.e., week ending date instead of week numbers.  This app will be used for multiple years, so I can't hard-code the dates.  Does anyone have a suggestion on how to make this work?  I am using if for capacity, demand, and the difference between the 2.  Thank you!
App builders
Tables and fields

15 Replies

Sort By
Show More
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    OK, so its a table report, not a summary report.  What is the field type of the fields in the report.  Are they in fact formula rich text field type?  You said you were color coding, so they must be formula Rich Text - is that right?
  • MichelleChapman's avatar
    MichelleChapman
    Qrew Assistant Captain
    7 years ago
    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.
    • MichelleChapman's avatar
      MichelleChapman
      Qrew Assistant Captain
      7 years ago
      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?
    • TylerParker's avatar
      TylerParker
      Qrew Assistant Captain
      7 years ago
      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)