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
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

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

siddheshj442972
Level 2
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
kapilKochar
Correct answer by
Community Advisor
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
kapilKochar
Correct answer by
Community Advisor
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