Forum Discussion
Ashish_kumar12
Helper I
Helper IError:An argument of function 'DATE' has the wrong data type or the result is too large or too small
Hi All, I am trying make an new column where i want to compare today's week num and year with Date of birth of candidates (i.e 18-sep-1989 with today's date(18-Sep-2019). However i am getting an err...
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
Ashish_kumar12Helper I
Helper IHi Amit,
Thank you for your revert.
Do you changed the data type from text to Date?
As it still giving me the same errors. Please see below screenshot for the same
v-lili6-msft
Community Support
Community Supporthi, 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
- Ashish_kumar12
Hi Lin,
Thank you for your help. It works and i managed to make this column.
Regards,
Ashish