Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sri4
Contributor II
Contributor II

Extract date from Monday, 18.March 2021 07:52:01 CET to DD/MM/YYYY fomrat

 
Labels (2)
1 Solution

Accepted Solutions
BrunPierre
Partner - Master
Partner - Master

Possibly this.

Date(Timestamp#(Replace(SubField(Field,', ',2),'CET',''),'DD.MMMM YYYY hh:mm:ss') ,'DD/MM/YYYY')

View solution in original post

2 Replies
BrunPierre
Partner - Master
Partner - Master

Possibly this.

Date(Timestamp#(Replace(SubField(Field,', ',2),'CET',''),'DD.MMMM YYYY hh:mm:ss') ,'DD/MM/YYYY')

Sri4
Contributor II
Contributor II
Author

@BrunPierre  ...Thanks for solution....