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
------------------------------
Original Message:
Sent: 03-31-2023 17:33
From: XYZ
Subject: Calendar Report
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
------------------------------