Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Avry_th
Frequent Visitor

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

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. 
Avry_th_0-1660720666255.png

 

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 

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@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 

 

1.PNG

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
Avry_th
Frequent Visitor

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

you are welcome





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




ryan_mayu
Super User
Super User

@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 

 

1.PNG

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.