Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have problem with timestamp format dates. Below you'll see some examples.
What I need is a date (DD.MM.YYYY).
I've tested so far almost everything I can find from here. Nothing works. Any good ideas?
try tis.
Date(Floor( Date(DATE_FIELD)),'DD/MM/YYYY') as DATE
-Nilesh
Try This
=Date(Yourdatefield,'DD.MM.YYYY')
or
your date field in text try like this
=date(num(date#(Yourdatefield,'DD.MM.YYYY')),'DD.MM.YYYY')
Hi Nilesh,
Unfortunately that didn't work either...
Hi
Date(Floor( Date#(DATE_FIELD)),'MM.DD.YYYY hh:mm') as DATE
or
Date(Floor( Date#(DATE_FIELD)),'M.D.YYYY hh:mm') as DATE
HTH
Jonathan
Use this:- It might help u
SubField (TimeStamp1,' ', 1)
Thanks
D J
try this
Sorry, neither of those didn't work
=Date(FLOOR(YourDateField),'DD.MM.YYYY')
That works!!! Thanks for your help! I mean all of you!