Parsing datetime

building reports webintelligence
1

In our database, the report schedule start date is a datetime field. I am trying to parse it to extract the “year”. “month”, “day” and “hour”, for grouping purpose.

In SSMS, this one works…
Datepart(hour,CMS_INSTANCE.SCHED_BEGIN_DATE)

However, when I created a report level variable and added to the report, it
is not displaying the parsed data. Instead, it is only showing the formula. What had I done wrong?

Please help. TIA.

2

Never mind, I figured it out. The report level variables need to be linked to the Query 1 for them to display values. I also changed the function from Datepart to FormatDate. It is working now.