
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to convert timestamp to date format
Hi all,
I have problem with timestamp format dates. Below you'll see some examples.
- 1.1.2013 08:00
- 10.1.2014 14:30
- 31.12.2013 21:30
- 1.11.2013 01:15
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?
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try tis.
Date(Floor( Date(DATE_FIELD)),'DD/MM/YYYY') as DATE
-Nilesh

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Nilesh,
Unfortunately that didn't work either...


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use this:- It might help u
SubField (TimeStamp1,' ', 1)
Thanks
D J


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try this

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sorry, neither of those didn't work

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=Date(FLOOR(YourDateField),'DD.MM.YYYY')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That works!!! Thanks for your help! I mean all of you!

- « Previous Replies
-
- 1
- 2
- Next Replies »