cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mhodges720 Frequent Visitor
Frequent Visitor

Expand function changes date format

I have two tables that I need to link by date and serial number.  I have created a custom column that concatenates the two fields together.  Since one field is date field my concatenation is I created a new column for the date field that was text only.  The resulting field works fine:

 

 

SN & FailDate Concatenation.PNG

 

After the expand the date format has changed:

SN & FailDate Concatenation After Expand.PNG

 

Has anyone else seen this issue?  I've tried all the formatting options and nothing solves the problem.

 

Thanks,

Mark

 

5 REPLIES 5
Super User
Super User

Re: Expand function changes date format

Hi @mhodges720,

 

I can't replicate the issue on my computer, check if have any Changed Type step on your query that is maing that transformation after the expanding or just before.

 

Regards,

MFelix

 



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Community Support Team
Community Support Team

Re: Expand function changes date format

Hi @mhodges720,

 

How did you expand something? Can you share a sample?

 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
mhodges720 Frequent Visitor
Frequent Visitor

Re: Expand function changes date format

I had a merge query add a couple of fields from one database table another.  Once the merge was done I had to expand the merged table and select the fields I wanted added to my original data.

 

I hope this helps.  Let me know if I haven't answered your question.

 

Cheers,

Mark

Community Support Team
Community Support Team

Re: Expand function changes date format

Hi Mark,

 

Can you share a sample file that can show up the issue? According to my test and your information here, it should work. 

Please download the demo in the attachment. I would suggest you format the [Faild] column first.

[text] & "-" & Text.From([textdate], "en-us")

Expand-function-changes-date-format

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Expand function changes date format

Hi @mhodges720,

 

Could you please mark the proper answers as solutions?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.