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)
```
=Replace(Format(CDate(Now()),"MM.dd.yyyy"), ".", "/")

```