how to display date field values conditionally?

[Akina0929]

Hi,

I have one date field,I want to display in that field

if the date field value is lastmonth, it has to display same date

else condition '-'

[sushil353]

Try this:

if(Month(DateField) = Month(Addmonths(today(),-1),DateFiled,null())

[Akina0929]

Hi sushil,

         it,s showing error.

[rahulpawarb]

Hello AB,

Month function takes 1 parameter. Corrected the expression to add closing bracket for month function.

//Old Code:

=if(Month(saledate) = Month(AddMonths(Today(),-1), saledate, null())

//New Code:

=if(Month(saledate) = Month(AddMonths(Today(),-1)), saledate, null())

Hope this will be helpful.

Regards!

Rahul