Show Seasons

[SuperNam]

How can I show the season for the date that I have inserted? Any help would be great. Thanks! 

[IamNatoyThatLovesYou]

Hello @SuperNam,

You can try creating a Formula or calculated value/field then insert the code below.

CASE WHEN ( (Month('[@cbParamVirtual1]')) >= 3 )

AND ( (Month('[@cbParamVirtual1]')) <= 5 )

THEN  'Spring'

 

 WHEN ( (Month('[@cbParamVirtual1]')) >= 6 )

AND ( (Month('[@cbParamVirtual1]')) <= 8 )

THEN  'Summer'

 

 WHEN ( (Month('[@cbParamVirtual1]')) >= 9 )

AND ( (Month('[@cbParamVirtual1]')) <= 11 )

THEN  'Fall'

 

 WHEN ( (Month('[@cbParamVirtual1]')) <= 2 )

OR ( (Month('[@cbParamVirtual1]')) = 12 )

THEN  'Winter'

END

 

-Natoy

[IamNatoyThatLovesYou]

Just to add more information. You may also check this link for reference regarding Case Statements.

-Natoy

[RuisiHansamu]

I agree with Natoy, you can use CASE statements with this. However, 

Regarding on the SQL Queries, I believe it is not directly. But we can create a View to join the tables, then create a Report DataPage to retrieve data from this view, in which we can apply further filters. You may write SQL Statements to do subqueries from the results returned by your Report DataPage. Also, SQL Statements can be used in tables, and calculated values.

This video from Caspio helped me as well about using SQL in the Bridge : 

I hope this helps. Cheers!