Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Formula for formatting UNIX Time Post Reply Post New Topic
Author Message
Daniel1313
Newbie
Newbie
Avatar

Joined: 31 Mar 2009
Location: United States
Online Status: Offline
Posts: 2
Quote Daniel1313 Replybullet Topic: Formula for formatting UNIX Time
     Posted: 31 Mar 2009 at 2:11pm
I have a column of data that is stored in UNIX TIME format to the millisecond. Does anyone know of a formula that will convert the data to proper format
 
I am extremely new to Cyrstal and how gotten this far
 
dateadd("s",{DOCUMENT_A.PUBLISHED},datetime(1970,1,1,0,0,0))
 
When I go to verify, it's looking for a number, where the table is located.
 
Doe's anyone have a solution
 
Newbie to the max!!!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 31 Mar 2009 at 7:13pm
try:
dateadd("s",tonumber({DOCUMENT_A.PUBLISHED}),datetime(1970,1,1,0,0,0))
IP IP Logged
Daniel1313
Newbie
Newbie
Avatar

Joined: 31 Mar 2009
Location: United States
Online Status: Offline
Posts: 2
Quote Daniel1313 Replybullet Posted: 01 Apr 2009 at 1:41pm
That solved my issue.
Thank you very much!!!!!!Thumbs%20Up
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.