Dt

[smilingjohn]

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

[its_anandrjs · Accepted solution]

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.