Discussions

 View Only
  • 1.  Auto Update the Month Name in a field?

    Posted 01-19-2022 11:55
    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
    ------------------------------


  • 2.  RE: Auto Update the Month Name in a field?

    Posted 01-19-2022 12:51
    No 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.




    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------