Hi,
Could you please let me know why this formula is giiving an error?
It says that "A value used in the formula is of the wrong data type"
Thakns

p.s. the fields inside the curly brackets are field values which the system picks up.

here is the formula:
=IF(AND(DATEVALUE("{COM_ShGrnted}")>=DATEVALUE("{CX_ASSIGNMENTSTARTDATE}"), DATEVALUE("{COM_ShGrnted}")<=DATEVALUE("{CX_ASSIGNMENTPROJECTEDENDDATE}")), "{CX_HOSTCOUNTRY}","{CX_HOMECOUNTRY}")