Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Converting Timestamp to Number

Looking to convert a date from this format  4/12/2017 15:44:26 to this format 42826.315277778. I've tried to use a couple different functions such as num(), but no luck thus far. Any guidance would be appreciated!

1 Reply
swuehl
MVP
MVP

Maybe like

=Num(Timestamp#( '4/12/2017 15:44:26','M/D/YYYY hh:mm:ss'))

but you need to check the format of your input value, is it a numeric or text format?

Why don’t my dates work?