How do convert a date/timestamp to text? In excel, I can change the format, I cannot do that here.

[vlruch67]

I've tried filtering on the those that need correcting and using the filtergram into text but that does not work. The only way I can find to fix is to use custom value and insert the correct number but I have to use the original excel file to refer to. 

[sayyar]

@vlruch67 Are you looking for a change of display format for the dates in Paxata? If yes, we always display the formats in the way @ebarre's comment above shows it. If you want to view it in a different format like yyyy/mm/dd you can do certain other computed columns like:  

concatenate(year(@date_column@), "/", month(@date_column@), "/", day(@date_column@))

Please let us know if this is what you're looking for. We can discuss this in detail if needed.

Regards,

Shyam Ayyar

[vlruch67]

I mean the results produced were incorrect

[ebarre1]

Hello @vlruch67,

When you say it did not work, do you mean that the results produced were incorrect, that nothing happened or that you get an error?

The screenshot below shows what the output should be like once you apply the "Change into Text":



Notice the datatype symbols have changed and the values in the column are now left-aligned and black instead of right align and green.

[vlruch67]

I tried that and it did not work

[bstephens]

On each column, at the top right is a triangle. On the column that you want to transform, hover on that triangle and select the "CHANGE into text" option.



Thanks,
BIll