help with a formula within a text box

[Swifey]

For my text box on my form I have been shown the subsequent Default formula to calculate last months date – the screen view shows 200402

=IIf((Month(Date())-1)<9,Year(Date()) & "0" & Month(Date())-1,Year(Date()) & Month(Date())-1)

I would like to create a further text box on my form to calculate the prior months date. ie same month last year - screen view to show 200302

I have tried to modify the above formula but failed
Could you please help.

Kind regards

 

[bat17]

Your formula returns a text answer not a numeric one which is probably why your other text boxes did not work.

=IIf((Month(Date())-1)<9,Year(Date())-1 & "0" & Month(Date())-1,Year(Date())-1 & Month(Date())-1)

Will return last year as text, if you wrap the formula's in the cLng function you will turn them back into numbers

=CLng(IIf((Month(Date())-1)<9,Year(Date())-1 & "0" & Month(Date())-1,Year(Date())-1 & Month(Date())-1))

HTH

Peter

 

[bat17]

Or perhaps a neater function

=Format(DateAdd("m",-1,Date()),"yyyymm")-100

Peter

 

[Swifey]

That is far better - Thank you very much