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 个回答
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
