Joined: 14 Feb 2012
Location: United States
Online Status: Offline
Posts: 2
Topic: Crystal reporting 11 Posted: 14 Feb 2012 at 6:23am
Hi everyone,
I'm having issues converting a date/time field which displays as:"20120214 09:15:00" into 02/14/2012 09:15 AM. I tried using 2 formulas to convert the string into a datetime value but they both failed.
i used "dateTimeValue({field from DB}) and also tried cDateTime({field from DB}).
Can anybody tell me what i'm doing wrong here? When i check the formula it passes but while trying to run the report, the report fails.
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
IP Logged
