Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Date Conversions

Hi All,

I have date fields like OrderDate in the format 09-10-19 11:49:20.237000000 PM  all dates are same format 

if dates are in this format how to convert into normal dates like Date has contain DD/MM/YYYY, DD-MM-YYYY

 

and how create master calendar by using these dates  Kindly help by providing logic 

please find the attached date formats 

Thanks a lot.... 

 
 

 

3 Replies
Highlighted
Partner
Partner

Hi Narayana,

You can try the following formulas:

Date(Floor([OrderDate]),'DD/MM/YYYY')

OR

Date(Date#(Left([OrderDate],8),'DD-MM-YY'),'DD/MM/YYYY')

Jordy

Climber

Work smarter, not harder
Highlighted
Creator
Creator

Thanks you Jordy

it is working fine

 

Highlighted
Partner
Partner

Great, please close the ticket if it's solved!

Jordy

Climber

Work smarter, not harder