You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

how to get the names of week day in fast formula

edited Jan 5, 2025 1:22PM in Workforce Management 9 comments

Summary:

I need to get the Name of the day based on date.

Content (please ensure you mask any confidential information):

I need to get the Name of the day based on date, to be used in "Global Absence Entry Validation" formula.

for example, I need to check the name of the day i.e. Sunday, Monday…. etc. base on Start date of absence, I used the functions TO_TEXT(IV_START_DATE,'DAY'), TO_CHAR(IV_END_DATE,'DAY') , TO_TEXT(IV_START_DATE,'DY'), TO_CHAR(IV_END_DATE,'DY'), but instead of returning the name of day it returns the number of day of week i.e. 1,2,3,4,5,6,7

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!