Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

Get month from $([vars/From_Date]))

Avatar

Level 2

Hi team,

How to get month from $([vars/From_Date])) in reports while filtering query.

I tried Month($([vars/From_Date])) ,but getting error while using this function.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi ,

Value coming from vars/From_Date is of date type or Datetime?

If it's datetime, Please try below syntax

Month(ToDate(vars/From_Date))

Do let me know if this works.

Thanks,

Kapil

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hi ,

Value coming from vars/From_Date is of date type or Datetime?

If it's datetime, Please try below syntax

Month(ToDate(vars/From_Date))

Do let me know if this works.

Thanks,

Kapil