Forum Discussion
Solved
DATEDIFF Not Working in Custom Column
I am tyring to add the column as follows = Table.AddColumn(#"Added Custom", "OrderAge", each DATEDIFF ([DateTimeCreated],TODAY(),DAY)) But I get the meaasge Expression.Error: The name 'DATE...
DBATTIN I guess you have DateTimeCreated field as DateTime datatype which also needs to converted into Date type. So please try this...
Duration.Days(Duration.From(DateTime.Date(DateTime.LocalNow())-DateTime.Date([DateTimeCreated])))
PattemManoharthe formula is now
OrderAge = Duration.Days(Duration.From(DateTime.Date(DateTime.LocalNow())-[DateTimeCreated]))
This is now showing no syntax errors but returns an error value in the custom column. Have I done something wrong?
DBATTIN I guess you have DateTimeCreated field as DateTime datatype which also needs to converted into Date type. So please try this...
Duration.Days(Duration.From(DateTime.Date(DateTime.LocalNow())-DateTime.Date([DateTimeCreated])))
PattemManoharthank you thats brilliant :smileyhappy: