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: 
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)
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.