Skip to main content
Topics#Data ManagementPregunta de Donne Kerestic
Donne Kerestic ha preguntado en #Data Management
2 jul 2013, 18:40

IF Statement with Created Date

I need a formula that will assign a "Retail Calendar Week" based on Created Date.

 

IF(AND(DATEVALUE(CreatedDate >= 2013-02-11,CreatedDate <= 2013-02-17)),"Week 8 - 2013",

 

IF(AND(DATEVALUE(CreatedDate >= 2013-02-18,CreatedDate <= 2013-02-24)),"Week 8 - 2013","NONE"))

 

I am using a Text Formula Field.  I need to see if the Created Date is between two specified dates and apply the appropriate text based on a match.
3 respuestas
  1. Deepak K Anand (‎‎‎‎‎‎Zoom Communications, Inc.)
    2 jul 2013, 18:46
    Hey Donne,

     

    You should be good with this:

     

    IF(

     

       AND(

     

           DATEVALUE(CreatedDate) >= DATEVALUE('2013-02-11'),

     

           DATEVALUE(CreatedDate) <= DATEVALUE('2013-02-17')

     

       ),

     

       "Week 8 - 2013",

     

       IF(

     

           AND(

     

               DATEVALUE(CreatedDate) >= DATEVALUE('2013-02-18'),

     

               DATEVALUE(CreatedDate) <= DATEVALUE('2013-02-24')

     

           ),

     

           "Week 8 - 2013",

     

           "NONE"

     

       )

     

    )

     

    Best,

     

    Deepak
Escribir una respuesta...
0/9000