Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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