Forum Discussion

lornafnb's avatar
lornafnb
Helper I
4 years ago
Solved

Create a new concatenated field using text and Date fields

Good day,

 

Beginner here :). I want to concatenate a Text field and a date field to create a new fields (which is just for informational purposes, wont be used for navigation)

 

usual syntax would be (if both were text, I guess) = [name] & " " & [GoLive_date], but because the GoLive_date is a date, it fails.

 

Please assist?

Thanks

Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Make it

     

    = [name] & " " & Text.From([GoLive_date])

     

    If you want date in a particular format, you can use format code in Date.ToText. Below is an example for yyyy-MM-dd format

     

    = [name] & " " & Date.ToText([GoLive_date],"yyyy-MM-dd")

     

1 Reply

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional
    4 years ago

    Make it

     

    = [name] & " " & Text.From([GoLive_date])

     

    If you want date in a particular format, you can use format code in Date.ToText. Below is an example for yyyy-MM-dd format

     

    = [name] & " " & Date.ToText([GoLive_date],"yyyy-MM-dd")