Printing report item into header

[Aartibhilare]

Hi team i want to print the date into the header its happening but same time i want to change the format of date to particular format it's not happening and shows like below

i want in Sun, 30/Dec/2018 format

[Anonymous]

Hi @Aartibhilare 

Thank you for your patience. From the steps outlined below, please let us know if anything was helpful to you, so that we can convert it into a formal answer. If so, we would appreciate it if you could Accept it as a solution and drop a 'Kudos' so other members can find it more easily.
Thank you.

[Aartibhilare]

Hi Team

I have the report like attached screenshot

I want to print the Total staff ( which basically base on filter of the date for perticular date how many employee are empty and how many filled) in body EXPR 

right now if i select two dates , I am getting two date total filled and total employeed

="Total staff shifts for " & Fields!date.Value & ": " &
Count(Fields!EmployeeName.Value, "DataSet1") &
" (" &
Count(IIf(Not IsNothing(Fields!EmployeeName.Value) And Trim(Fields!EmployeeName.Value) <> "", 1, Nothing), "DataSet1") &
" filled)"

[Aartibhilare]

Thanks its done now

[Anonymous · Accepted solution]

Hi @Aartibhilare 
Thanks for reaching out microsoft fabric community forum

If you want to see it in this format"Sun, 30/Dec/2018", use this:

=Format(CDate("2018-12-30"), "ddd, dd/MMM/yyyy")
Here is the syntax

To format a field YourDateField to show the date as "Sun, 30/Dec/2018", use the below syntax

=Format(CDate(Fields!YourDateField.Value), "ddd, dd/MMM/yyyy")

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thank you