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

siddheshj442972

Level 2

Solved

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

Forum|Forum|6 years ago
June 23, 2019
2 replies
2701 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by kapilKochar

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

siddheshj442972Author

Level 2

kapilKocharAccepted solution

Level 6

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