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: 
smilingjohn
Specialist
Specialist

Dt

Hi All ,

I have date formate like below

01-MAY-17 12:45:00

Iam using below script to get like this

01-05-2017 ( wanted to remove the time )

But after reloading this dont show any value

Date(Date#(BillingDate,'DD-MMM-YY hh.mm.ss'),'DD-MM-YYYY')as BDT,

How to rectyfy this

Thanks in Advance

10 Replies
its_anandrjs

Yes sure it convert your date into pure date with Date function after using slice and dice on the Date fields. Of coursers it works for you.