Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Format a column from text to date

Hi all,   I like to change the format of a column to date with the following values:   EndPricingPeriod May 2021 202108 202107 202107 202108   May 2021 May 2021   M...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    Add a custom column with the following code then change Data TYpe to Date

    =try Date.From( [EndPricingPeriod] & "01" ) otherwise [EndPricingPeriod]

     



Fowmy's avatar
Fowmy
Super User
5 years ago

Anonymous 

Add a custom column with the following code then change Data TYpe to Date

=try Date.From( [EndPricingPeriod] & "01" ) otherwise [EndPricingPeriod]

 



  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Nice and easy solution! Thank you!