Get Previous Month today's date

[paulwalker]

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:

Date	Client	Amount
01/02/2017	AAA	2500
03/02/2017	AA	2300
24/02/2017	A	1500
25/02/2017	A1	200
01/03/2017	BBB	900
03/03/2017	BB	612
24/03/2017	B	315
25/02/2017	B1	160
01/04/2017	CCC	526
03/04/2017	CC	789
24/04/2017	C	1250
25/04/2017	C1	165
01/05/2017	DDD	9000
03/05/2017	DD	4000
24/05/2017	D	9533

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..

[sunny_talwar]

May be like this

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

[kamal_sanguri]

Hi,

Pls refer this..