Dates format change after loading into table

[srehman]

Hi team,

As defined Data Type "date " in PQ looks everything perfect, after loading into table Dates will appear as number. any suggestion. Thanks

Date	Create Date
44235​	44232​
44235​	44232​
44235​	44232​
44235​	44232​
44236​	44235​
44237​	44235​
44240​	44239​
44235​	44230​

 

[Zot]

I guess you just need to format the cell as date.

 

[srehman]

i am doing it as a temporary solution, but after next refresh its turn back to number. i am thinking to change sheet.

 

[Zot]

i am doing it as a temporary solution, but after next refresh its turn back to number. i am thinking to change sheet.

I see. I'm not familiar with PQ at all.