Get Previous Month today's date

paulwalker — Wed, 25 Nov 2020 16:16:04 GMT

HI COmmunity,

How i can get Previous month date from Current date based on selection.

Suppose today's date 24/05/2017,

If i am select March it should be 24/03/2017

Example: this expression returns only last month current data, but my requirement based on selection.

=Date(AddMonths(Today(),-1))

Example:

Textbox: bydefault it should be 24/05/2017

Sum({<Date={'24/05/2017'}>}Amount) = 9533

when i make selection Month= Feb

Sum({<Date={'24/02/2017'}>}Amount) = 1500

How to write expression?

Thanks in Advance..

Re: Get Previous Month today's date

sunny_talwar — Wed, 24 May 2017 08:37:23 GMT

May be like this

=Date(MakeDate(Year(Today()), Month(If(GetSelectedCount(Date) = 0, Today(), Max(Date))), Day(Today())))

kamal_sanguri — Wed, 24 May 2017 08:42:01 GMT

Hi,

Pls refer this..