Salesforce

How Do I Retrieve the Name of the Day of the Week of a Given Day? (Magic xpa 3.x)

« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

How Do I Retrieve the Name of the Day of the Week of a Given Day? (Magic xpa 3.x)

It can be very difficult to figure out what day of the week a given date falls on, and more work to translate it into text. There is a nice function to do this though, the CDOW() function.

One of the advantages of using this function is that if your application is being distributed in other countries, it will return the date in the user’s chosen language.

Hint: If you need to do computations based on the day of the week, it is better to use a different function, DOW(). This returns a number representing the day of the week, which is easier to use in programs.

See also

Using the CDOW() function

The syntax of CDOW() is:

CDOW(date)

Where date is any date variable (or a hard-coded date, such as '05/06/2008'DATE, or an expression that evaluates to a date). It returns a string containing the name of the day of the week.

See also

The Online and Rich Client Samples projects (program DT12 and RDT12)

Reference
Attachment 
Attachment