Minus month from the Month column

[SH_94]

Dear community,

I would like to ask how do we minus one month if we have the data below :

I have attached in the excel file below for the reference as well.

Many thanks

[gabrielvilella · Accepted solution]

Hey @SH_94, you need to convert to a date then you can remove one month from it.

PadLeft(ToString(DateTimeMonth(DateTimeAdd(ToDate('2022-'+[Month]+'-01'),-1,'month'))),2,'0')

[Qiu]

@SH_94 
A different approach can be like this.

[danilang]

And for a 3rd different approach, try this

if month="01" then
	"12"
else
	padleft(tostring(tonumber([Month])-1),2,"0")
endif

Dan