How will you write a query to target all profiles that have been created in the current month and year?

Question

Mariusz Lewandowski · Accepted Answer

Year(@created) = Year(GetDate()) AND Month(@created) = Month(GetDate())

Mariusz Lewandowski · Answer

Year(@created) = Year(FindDate()) AND Month(@created) = Month(FindDate())

Mariusz Lewandowski · Answer

Year(@created) = Year(TodayDate()) AND Month(@created) = Month(TodayDate())

Mariusz Lewandowski · Answer

Year(@created) LIKE Year(GetDate()) AND Month(@created) LIKE Month(GetDate())

List of questions