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: 
Domino1
Contributor II
Contributor II

How to date format a complicated timestamp ?

 Hello,

Here is my timestamp :   

2021-10-05 00:00:00.0000000 +00:00

 

Need to show as  ' MM DDD YYYY' 

Just using Date and floor functions are ineffective.

Labels (1)
1 Solution

Accepted Solutions
vish123
Creator III
Creator III

Hi Domino 1,

Please try this.

Date(Date#(left(date,10),'YYYY-MM-DD'),'MM DD YYYY')

View solution in original post

1 Reply
vish123
Creator III
Creator III

Hi Domino 1,

Please try this.

Date(Date#(left(date,10),'YYYY-MM-DD'),'MM DD YYYY')