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

130 likes

Total Posts

144 posts

Correct reply

45 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

130 likes

Total Posts

144 posts

Correct reply

45 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