Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Dolly123
Creator II
Creator II

Date

Qlikhub_0-1672830833442.png

change in Date formart DD/MM/YYYY 

and remove the time stamp in qliksense

 

2 Replies
Mark_Little
Luminary
Luminary

Hi

This seems to do the job

DATE(DATE#(REPLACE(LEFT([Created Time],12),',',''),'MMM DD YYYY'))

BrunPierre
Partner - Master II
Partner - Master II

Hi

Perhaps as below.

Date(Floor(TimeStamp#("Created Time", 'MMM DD, YYYY hh:mm TT')),'DD/MM/YYYY')