General

Re: Calculate previous month

Vanessa Larsen — Wed, 23 Feb 2011 01:04:26 GMT

Awesome, thanks so much for your help :-)

Re: Calculate previous month

Jimmy — Tue, 22 Feb 2011 07:11:48 GMT

Rule:

Condition: substring(today(), 6, 2) = 1

Year = substring(today(), 1, 4) - 1

Month = 12

Condition: substring(today(), 6, 2) != 1

Year = substring(today(), 1, 4)

Month = substring(today(), 6, 2) - 1

Or without conditions:

Year = substring(today(), 1, 4) - (substring(today(), 6, 2) = 1)

Month = substring(today(), 6, 2) - 1 + 12 * (substring(today(), 6, 2) = 1)

Calculate previous month

Vanessa Larsen — Tue, 22 Feb 2011 06:57:30 GMT

Hi all,

I'm currently developing a (InfoPath 2010) form where there is the requirement to automatically populate the field with the previous month e.g. January 2011. I know that an easy way to calculate this would be to use today()-30, however this doesn't cater for months where there are 31 days - and the users typically submit these forms at the end of the month.

I was hoping someone would know of a smarter (code-free) way to calculate the previous month?

Cheers,

Vanessa