# WeekDayName() Function
**YouTube:** [How to Use the WeekDayName () Function in Report Custom Columns?](https://www.youtube.com/watch?v=yagtwJPgjnM)
## How to Use the WeekDayName () Function in Report Custom Columns?
In this tutorial, we'll walk you through designing an expression using the `WeekdayName` function, which returns the **name of the day** (e.g., Monday, Tuesday) from a date field such as *Bill Date*.
***
### Accessing the Expression Designer:
* Navigate to the **Reporting** section.
* Open the **Sales Register Detailed Report** or any **"Report".**
* Go to **Setup Column Attributes**.
* Here, you'll see a list of available columns that can be used to build expressions.
* Click on **"Add/Edit Expression Columns"** where you can write your expression using predefined functions.
* Before adding the expression to the report, go to **Other Settings**.
* Ensure the **Script Editor** is set to **VBScript**.
* Click **Save**.
* *Note: VBScript is the default for new configurations but always verify this setting.*
### Writing Your First Expression
* Every expression must start with the script header: **'#@LSCRIPT**
* Click the (+) Plus icon to create a new expression.
* Fill in the required fields:
* **Expression Name** – A unique name for your expression.
* **Expression Type** – Choose either **Text** or **Numeric** depending on the expected output.
***
### Creating a Simple WeekDayName() Expression
* Double-click your newly created expression to insert it into the script editor.
* Define the expression using the syntax:
* Expression Name = WeekDayName(CDATE(BILL\_DATE))
* `WeekdayName(...)` converts that date into the **day name** like "Wednesday".
* `CDate(BILL_DATE)` ensures the string is interpreted as a proper date.
* Save the expression once defined.
* Scroll down and **check the box** beside the expression name to enable it.
* Save and proceed to check the effect.
* **Refresh the report** to view the final result.
***
### Result:
The new column will now display the **name of the day** for each bill date.\
For example, if the *Bill Date* is `2025-06-09`, the column will display:
> **Monday**
