Question: on SSRS report I need to show `todays date and current time` 

i tried this `=FormatDateTime(Now,"MM/dd/yyyy hh:mm tt")` but this is not working for me giving an error.

Anyone please help me for `expression` ?

I want output display like `4/12/2013 12:05 PM`

Answer: 
I am using following in SSRS 2005

```
=Format(Globals!ExecutionTime,"MM-dd-yyyy" & " ") 
& CStr(Hour(Globals!ExecutionTime))  & ":"
& CStr(Minute(Globals!ExecutionTime))

```

Or 

```
=Format(Globals!ExecutionTime,"MM-dd-yyyy" & " ") 
& Right("00" & CStr(Hour(Globals!ExecutionTime)), 2)
& ":"
& Right("00" & CStr(Minute(Globals!ExecutionTime)), 2)

```

Based on comment:

```
=Format(CDate(Globals!ExecutionTime), "MM-dd-yyyy hh:mm.ss") 

```

OR

```
=Format(CDate(Globals!ExecutionTime), "MM-dd-yyyy HH:mm.ss")

```
First go to your control panel , select Date , time and Number Format . Now select English(United Kingdom) from the drop down list. 

Make sure the shor date field is equal to 'dd/mm/yyyy'. Press Apply. Now go to SSRS and right click on the report in the empty space and select properties.

If you are using visual studio then set Language property equal to =User!Language. 

If you are using Report Builder then Language property will appear in Localization section.