Error:An argument of function 'DATE' has the wrong data type or the result is too large or too small

hi, Ashish_kumar12 

This error is because there are blank value in field_date_of_birth column, just adjust your formula as below:

DOB_View = IF(ISBLANK(Union_Table[field_date_of_birth])=FALSE(),
IF (
    WEEKNUM (
        DATE ( YEAR ( TODAY () ), MONTH ( Union_Table[field_date_of_birth] ), DAY ( Union_Table[field_date_of_birth] ) ),
        2
    )
        = WEEKNUM ( TODAY (), 2 ),
    "This Week",
    "All Others"
)
, "All Others")

Result:

BeforeAfter

Best Regards,

Lin

Hi Lin,

Thank you for your help. It works and i managed to make this column.

Regards,

Ashish