Forum Discussion

ask's avatar
ask
Icon for Helper III rankHelper III
9 years ago
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...
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    This code should work below.

     

    =[#"Day"] & "/" & [#"Month"] & "/" & [#"Year"]

    Then once you have that column created, convert the data type to Date

ask's avatar
ask
Icon for Helper III rankHelper III
9 years ago

yes

ask's avatar
ask
Icon for Helper III rankHelper III
9 years ago

Using th local one, it returns the error

  • ask's avatar
    ask
    Icon for Helper III rankHelper III
    9 years ago

    what happen after refreshing the data for the second one, there will be new data coming

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      9 years ago

      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.

      • ask's avatar
        ask
        Icon for Helper III rankHelper III
        9 years ago

        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?