Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All, I have 2 columns in my table: AccountNumber and ServiceDateTime for the last 10 years.
I only want the table to display the Account Numbers that are in the current month & year.
All the topics I found here were either Sum or Count but I just simply want to display them.
I don’t want to edit the script as I need the rest of the data in other charts.
Thanks!
=only({<ServiceDateTime = {">=$(YearStart(Today()))<$(=monthend(Today())"}>}AccountNumber )
try to change the date format remove the time