Skip to main content
Question

Calendar Report

  • March 31, 2023
  • 0 replies
  • 69 views

Hello,

I need help with quickbase calendar report. I currently have a field called start date which has list of companies. I have a another field called frequency which is multiple choice field consisting of daily weekly semi-monthly and monthly. I want to have calendar show the records which falls in the freqency range from start date. Can it be achieved in quickbase?



------------------------------
XYZ
XYZ
------------------------------
    This topic has been closed for replies.

    • RameshSingh
    • Author
    • Registered
    • April 3, 2023
    I am currently working on an app where we want to do a CALENDAR REPORT based on the start date and frequency. This seems kind of unachievable on my part. I tried this formula for the occurrence based on the start date but somehow it displays wrong data. 
    If([Frequency] = "Daily",
        ToText([Start Date]),
        If([Frequency] = "Weekly",
            ToText(ToDate(Month([Start Date]) & "-" & ToText(DayOfWeek([Start Date]) + 7) & "-" & Year([Start Date]))),
            If([Frequency] = "Semi Monthly",
                ToText(ToDate(Month([Start Date]) & "-" & If(Day([Start Date]) > 15, "01", "16") & "-" & Year([Start Date]))),
                If([Frequency] = "Monthly",
                    ToText(ToDate(Month([Start Date]) + 1 & "-01-" & Year([Start Date]))),
                    ""
                )
            )
        )
    )
    Could you please provide some insights?


    ------------------------------
    XYZ
    XYZ
    ------------------------------
    Terms & ConditionsAccessibility statement