Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
jhjzdff
Contributor
Contributor

cant convert datatype to num

I use  adani stock dataset for analysis https://www.kaggle.com/datasets/swaptr/adani-stocks

 I try to convert unix timestamp to normal timstamp , I try to convert timestamp field (text) -> (num)->  date

but I cant convert text to num  type 

 

 

Labels (1)
1 Reply
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

 

To convert text to num is Num#() founction.

 

To convert epoch I have found this formula :

timestamp((YourEpochDateField/1000/ 86400) + 25569)

Help users find answers! Don't forget to mark a solution that worked for you!