Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Im trying to create a list box for two years previous by month rather than the dates. The expression works below but when I add Month (highlighted in red) it doesnt work.
Any suggestions?
=If(YearStart(Today(),-2)<=YearStart([Car Sales.Date]),Month[Car Sales.Date],)
Thanks
Are you putting ()? Because it seems like you are missing parenthesis.
=If(YearStart(Today(),-2)<=YearStart([Car Sales.Date]),Month([Car Sales.Date]),)
Are you putting ()? Because it seems like you are missing parenthesis.
=If(YearStart(Today(),-2)<=YearStart([Car Sales.Date]),Month([Car Sales.Date]),)
Answer by own query but FYI. Use MonthName rather than Month and it works.
=If(YearStart(Today(),-2)<=YearStart([Car Sales.Date]),MonthName[Car Sales.Date],)