cancel
Showing results for 
Search instead for 
Did you mean: 

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

Image Sensor
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. 
Labels (1)
0 Kudos
5 Replies
Highlighted
Linear Actuator
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.

Image: https://us.v-cdn.net/6030933/uploads/editor/jt/av8p757fcyte.png

Thanks,
BIll
0 Kudos
Highlighted
Image Sensor
I tried that and it did not work
0 Kudos
Highlighted
NiCd Battery
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":

Image: https://us.v-cdn.net/6030933/uploads/editor/p6/poqvw6r3dg0q.png

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

0 Kudos
Highlighted
Image Sensor
I mean the results produced were incorrect
0 Kudos
Highlighted
Linear Actuator
@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

0 Kudos