Skip to main content
Topics#Sales And MarketingQuestion de Donne Kerestic
Donne Kerestic a posé une question dans #Sales And Marketing
15 juil. 2013, 20:44

Day of the week formula

I am looking for help on a formula for Day of the Week for Lead Created Date.

 

I found this one online, but it is not working properly.

 

CASE

 

(

 

MOD(DATEVALUE( LEFT( TEXT( CreatedDate ),10) ) - DATE(1900, 1, 7),7),

 

0, "Monday",

 

1, "Tuesday",

 

2, "Wednesday",

 

3, "Thursday",

 

4, "Friday",

 

5, "Saturday",

 

6, "Sunday",

 

"Invalid Day")
5 réponses
  1. Steve Molis (You Owe Me a Beer, Inc.)
    15 juil. 2013, 20:49
    I would just use:

     

    CASE(

     

    MOD( DATEVALUE(CreatedDate) - DATE(1900, 1, 7), 7),

     

    0, "1. Sunday",

     

    1, "2. Monday",

     

    2, "3. Tuesday",

     

    3, "4. Wednesday",

     

    4, "5. Thursday",

     

    5, "6. Friday",

     

    6, "7. Saturday", "Error")
Rédiger une réponse...
0/9000