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
Using th local one, it returns the error
what happen after refreshing the data for the second one, there will be new data coming
Hi ask
It will update as new data comes in because it is based on your original column. So no data or dates will be lost.
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?