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

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

Avatar

Avatar
Validate 1
Level 1
siddheshj442972
Level 1

Likes

4 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 1
siddheshj442972
Level 1

Likes

4 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
siddheshj442972
Level 1

23-06-2019

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.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

128 likes

Total Posts

140 posts

Correct Reply

43 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile

Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

128 likes

Total Posts

140 posts

Correct Reply

43 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
MVP

23-06-2019

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

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 1
siddheshj442972
Level 1

Likes

4 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 1
siddheshj442972
Level 1

Likes

4 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
siddheshj442972
Level 1

23-06-2019

query.PNG