cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vjnvinod Member
Member

error for new coloumn formula

Hi Team,

 

i am facing some error, let me know if anyone can help, below is the error and my tablenewerror.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: error for new coloumn formula

Hi @vjnvinod 

 Create a column like

column = 
IF([event_date]=BLANK(),"upcoming",
IF([event_date]<DATE(YEAR(today()),MONTH(today()),1),"YTD",
FORMAT([event_date],"mmm-yyy")))

9.png

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 REPLIES 3
Community Support Team
Community Support Team

Re: error for new coloumn formula

Hi @vjnvinod 

What is the "current month","previous month"?

For example, when event date=2018/11/15, is this date equal to "previous month" or not?

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

vjnvinod Member
Member

Re: error for new coloumn formula

@v-juanli-msft 

 

Current month is basically June 2019 and anything prior to June 2019 is previous month

Community Support Team
Community Support Team

Re: error for new coloumn formula

Hi @vjnvinod 

 Create a column like

column = 
IF([event_date]=BLANK(),"upcoming",
IF([event_date]<DATE(YEAR(today()),MONTH(today()),1),"YTD",
FORMAT([event_date],"mmm-yyy")))

9.png

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.