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: 
User12321
Contributor III
Contributor III

Convert Datetime to Date

Hi,

I have a datetime field named Completion time containing value like 10/10/2020 1:23:45 AM.

I only want to get the date in the load.

Can someone help please. Thank you.

Labels (1)
1 Solution

Accepted Solutions
abhijitnalekar
Specialist II
Specialist II

Hi @User12321 ,

Please try below

Date(Completion time,'DD-MMM-YYYY')

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!

View solution in original post

1 Reply
abhijitnalekar
Specialist II
Specialist II

Hi @User12321 ,

Please try below

Date(Completion time,'DD-MMM-YYYY')

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!