Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.