The Community will be undergoing maintenance on Friday January 10 at 2:00pm - Saturday January 11 at 2:00pm EST, and will be "read-only." For assistance during this time, please visit our Help Center.
Hey good afternoon, I wanted to create a view that gives me all the records from the Current Month and Current Day in history. So today being October 28, 2020, I want to be able to dynamically pull all the previous years for October 28th. I am sure I could add a month field and a day field and manually change them everyday as a filter in my view but wasn’t sure if there was anyway to dynamically pull the current date to get the historical values for the current date. Thanks in advance for any suggestions.
Ha, so I figured out an approach after posting. Have a formula on my table that compares todays month and day against the records month and day. Then can use that in the view to filter. Thank you!!!
Ha, so I figured out an approach after posting. Have a formula on my table that compares todays month and day against the records month and day. Then can use that in the view to filter. Thank you!!!