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: 
If the date and time is in its own cell (aka textbox), then you should look at applying the format to the entire textbox. This will create cleaner exports to other formats; in particular, the value will export as a datetime value to Excel instead of a string.

Use the properties pane or dialog to set the format for the textbox to "MM/dd/yyyy hh:mm tt"

I would only use Ian's answer if the datetime is being concatenated with another string.
In SSRS 2016 There is an option under the properties header "Localization" called "`Calendar`", if you click on this it gives you these 2 options:

* Gregorian (dd/mm/yyyy)
* GregorianUSEnglish (MM/dd/yyyy)

This works brilliantly when referencing data from a tables aswell

alternatively if this does not work for you, specify one of these formats under "Number" and in the cell "`Format`":

`dd/MM/yyyy` or `MM/dd/yyyy`

[![printscreen](https://i.stack.imgur.com/y8tRR.png)](https://i.stack.imgur.com/y8tRR.png)