Forum Discussion
Solved
Date Format
Hi, date format in the original data source is text format as shown below . 30/05/2017 I want to convert it into US date format as date type. It returns error : (even though I use th...
This code should work below.
=[#"Day"] & "/" & [#"Month"] & "/" & [#"Year"]
Then once you have that column created, convert the data type to Date
I create a year column by using Add Column - Custum Column
Year = right([Date],4)
Expression.Error: The name 'right' wasn't recognized. Make sure it's spelled correctly.
Any direction?
i use the split column function to get the Year, month and day.
i try to create a new date by using
date= datevalue(CONCATENATE((CONCATENATE([Month],[Day])),[Year])) from create Add Custom Column.
It returned error:
Expression.Error: The name 'datevalue' wasn't recognized. Make sure it's spelled correctly.
This code should work below.
=[#"Day"] & "/" & [#"Month"] & "/" & [#"Year"]
Then once you have that column created, convert the data type to Date