On a Sales Page I have two sales reports that show the "previous month" and the "month before" sales individually in two different reports and I'd like a text section above each report to read December 2021 Sales and November 2021 Sales respectively. Kicker is Id like it to change when the month changes as the reports auto change themselves.
If January 2022 display December 2021
and
If January 2022 display November 2021
Any help is much appreciated.
------------------------------
Michael Knecht
------------------------------
Question
Auto Update the Month Name in a field?
+5This topic has been closed for replies.
+24No problem,
Make a table with one record in it and use various fields which will calculate the words for the previous month and the next month based on today's date.
Then make a couple of reports that just have those respective single fields on the report.
Then go to your dashboard in position does two reports right above your sales reports. That way they will sort of look like headings to the sales reports.
Then make a couple of reports that just have those respective single fields on the report.
Then go to your dashboard in position does two reports right above your sales reports. That way they will sort of look like headings to the sales reports.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.