Date = Month

[knightwriter]

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

[sinanozdemir · Accepted solution]

Are you putting ()? Because it seems like you are missing parenthesis.

=If(YearStart(Today(),-2)<=YearStart([Car Sales.Date]),Month([Car Sales.Date]),)

[knightwriter]

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],)