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

[Avry_th]

Hello There, 

I have been searching for how to solve the DATE have wrong data type or the result is too large or too small, however couldn't get mine solved. 

My case is i only want the date that  have the current Year, current month and the Day of my Start date column. i have tried the below: 

NewDate = DATE(YEAR(TODAY()),MONTH(TODAY()),DAY('Commission Agent'[start_date]))

but it throw the error. 

i tried to the same with my Dim Date and it working fine. i am not sure what wrong with my start date column.

Could anyone help me with this please ?

Thanks 

[Avry_th]

@ryan_mayu , ah, yes my start date column had null values. thanks for helps 🙂

[ryan_mayu]

you are welcome

[ryan_mayu · Accepted solution]

@Avry_th 

are there any null values in the date column? 

If the date is null, day() can't return the whole number and you can build the new date column