How to Find the DAY of the Week

By | September 17, 2016

This function is one of the date function which will return the DAY number of the week from which we will be able to perform the other functionality.


dayn(Date): The “dayn” function excepts one parameter which we need to pass the date for which we need to find the weekday number.


Day of week


These function will return you the integer value which lies between 1(Monday)-7(Sunday)

We executed the above code on the monday which takes the current date (i.e. Date$)

get day of week

These functionality will help us to find the position of day in the week, which will helps us to calculate the other expressions.

Hope this helps.

About Us


Greytrix is one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product, system integrations, third party add-on development and implementation expertise.

Greytrix have some unique solutions of Sage X3’s integration with Sage and Magento eCommerce. It also offers best-in-class Sage X3 customization and development services to Sage business partners, end users, and Sage PSG worldwide.

For more information on Sage X3 Integration and Services, please contact us at .We will be glad to assist you.

Other Related Blogs:

– How to know Month name from the given date?

– How to get number of day and name from the date?

– How to know the start date of week of any year ?

– How to restrict users from modifying the X3 connection date?

– How to Modify the Posting Date of Sage X3 Transactions?