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")

```
```
=Replace(Format(CDate(Now()),"MM.dd.yyyy"), ".", "/")

```