Previous Month Year from Max Month Year

[User12321]

Hi,

I want to compute the sum of amount of the previous month year from the max month year.

Can someone help please. Thank you.

[abhijitnalekar · Accepted solution]

Hi @User12321,

Make sure that your field Monthyear has the proper data type required for the AddMonth function.    

Or try below

Create this field in the script and use this in the expression.

Date(MakeDate(left(Monthyear,3), right(Monthyear,4), 1), 'MMM-YYYY') as Date

[User12321]

Hi @abhijitnalekar ,

I'm able to resolve my issue based on your inputs. Thank you so much!

[abhijitnalekar]

Great!!.. You are welcome