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)
If you want date and time separate then use below expressions: 
[Date and Time Expression](https://i.stack.imgur.com/SBWP8.png)

**Expression1** for current date : **=formatdatetime(today)** 
its return date is = 11/15/2016 

**Expression2** for current time : **=CDate(Now).ToString("hh:mm tt")**
its return time is = 3:44 PM 

This report printed on **Expression1** at **Expression2** 

Output will be : 
[Output of Both Expression](https://i.stack.imgur.com/BHtZq.png)

This report printed on **11/15/2016** at **3:44 PM**