You’re offline. This is a read only version of the page.
Announcements
Hi all,
i'm kinda new to powerapps and need some help with a date calculation.
So i have a table with 2 columns and i need to calculated the next_report_date based on the information of Frequency and Created_date.
Functional description is: It should always be the upcoming wednesday that could be today or in the future (i added the days in the table to clarify).
So if the created date is 21-mar and the frequency is weekly, the next_report_date should be wednesday 22-mar (after 22-mar the next_report_date should change to 29-mar)
If the created date is 24-mar and the frequency is bi-weekly, the next_report_date should be wednesday 05-apr (after 5-apr, the next_report_date should change to 19-apr)
If the created date is 16-feb and the frequency is monthly, the next_report_date should be wednesday 12-apr
If the created date is 3-jan and the frequency is bi-monthly, the next_report_date should be wednesday 19-apr
| Frequency | Created_date | Next_report_date | Next | etc |
| Weekly (7 days) | 2023-03-21 | 2023-03-22 | 2023-03-29 | |
| Bi-weekly (14 days) | 2023-03-21 | 2023-04-05 | 2023-04-19 | |
| Monthly (28 days) | 2023-02-16 | 2023-04-12 | 2023-05-10 | |
| Bi-monthly (56 days) | 2023-01-03 | 2023-04-19 | 2023-06-14 |
Anyone knows how to calculated this?
Share
Report
All responses (
Answers (
717
