Forum Discussion
Chayce, for some reason this is no longer working. Only showing May of 2023 and not May 2024 now. Did something change to render this inoperable?
What part is not working? If you look at your entries in a table report and show the formula check box, is the box checked on the records you would expect? Also, it's June so it shouldbe showing June 23/24 right?
- TonyGonzalez8 months agoQrew Trainee
It's only showing 2023, not 2024. There are no June numbers. It is setup to show last month, since we wouldn't have numbers for June until July.
There isn't a table report to look at because this is a formula report, so it won't show up in the table. Right?- MikeTamoush8 months agoQrew Commander
For testing purposes I would make a stand alone formula checkbox field, with the formula in it. Then add that to a table report. If the checkbox isn't checking for May 24, then we can troubleshoot the formula and keep checking. You don't actually need the stand alone field for the report (report formula is fine), but it is much easier to troubleshoot with it.
You may even want to make a formula date field for testing and break it down into pieces.
However, one thing I noticed is the current date and year prior date use the first date of the month, and then check that against the date field in your record. But I think it should be checking against FirstDayofMonth([Date in your Record])
- TonyGonzalez8 months agoQrew Trainee
Mike, you are on to it. If I change the dates on the records in May of 2024 to 05-01-2024 (they were various dates), then it works. I CAN make this work, but it would be better if the formula worked for ANY day in May (and subsequent months). If your suggestion above makes that work, I need a little bit more clarification.