I am new to SQL Server Report Builder 3.0 and need some support in creating a report, if that is ok with you. First things first, I am not great with coding nor with SQL etc, please be patient with me and I will also do my best to learn out of this :)

**OBJECTIVE**

The objective is to generate a report from a SharePoint Calendar to show in a different view compared to the actual calendar. 

**CALENDAR VIEW**

The following information are asked to be entered for a new entry:

[New entry in SP Calendar](https://i.stack.imgur.com/tQXMo.jpg)

**What it should be in the Report**

Now, this is what the report should be displaying, or something close to that.

[what it should be looking like](https://i.stack.imgur.com/GklWu.jpg)
The above excel was created manually and my thoughts were to utilise the SP Calendar and somehow create/generate a report and show the relevant data.

**What I have done so far?**

I have created a custom report in SQL Server Report Builder but I am failing to modify the dates to show the WEEK DAY rather than the actual date e.g. instead of 14/12/2016 09:26:00AM I like to show Wednesday.

```
=Fields!Start_Time.Value

```

I added this `=FormatDateTime(Fields!Start_Time.Value,"dd/MM/yyyy hh:mm tt")` which modifies the date/time format but unsure how to convert that to the actual day-name of the week.

I am very sorry I am limited to 2 links I can attach otherwise I would show more screenshots to make it more clear.