How do I show the date in the SSRS report?

Question

I want to show Todays date as report generated date in SSRS report.

How can i do this?

should any variable be used?

Please help me. I am new to SSRS.

For example, this image:

Answer 1

date column 1: = formatdatetime (today)

Answer 2

Try the following:

 =FORMAT(Cdate(today), "dd-MM-yyyy") 

or

 =FORMAT(Cdate(today), "MM-dd-yyyy") 

or

 =FORMAT(Cdate(today), "yyyy-MM-dd") 

or

 =Report Generation Date: " & FORMAT(Cdate(today), "dd-MM-yyyy") 

You must format the date in the same format that your client (internal or external) wants to see the date . For example, on one of my servers it works in the American date format (MM-dd-yyyy), and in my reports I have to make sure that the displayed dates are European (yyyy-MM-dd).

Answer 3

You can also drag the Runtime item from the Built-in Fields list.

Answer 4

To display the date and time, try the following:

 =Format(Now(), "dd/MM/yyyy hh:mm tt") 

Answer 5

In the text box that contains the title, you can use the expression to get the date. Try something like

  ="Report Generation Date: " & Today() 

right click in the text box in the layout. At the bottom of the list you will see an expression option. There you can enter the code. This option allows you to avoid adding a second text field.

Answer 6

You can put a text field in the report and add an expression with the following value:

 ="Report generation date: " & Format(Globals!ExecutionTime,"dd/MM/yyyy h:mm:ss tt" ) 

Answer 7

Simple use

 =Format(today(), "dd/MM/yyyy") 

will solve your problem.

Not difficult,

Answer 8

• Insert a test window in the SSRS report design area.
• Right-click on the text field and scroll down and click on the Expression tab
• just enter this expression in the expression area: = format (Today, "dd / MM / yyyy")