Jiwa

Hi, My version of Crystal 2013 won't see the DateTime format option for our Jiwa DateTime fields?? as one example SO_PrintLog.SysDateTime is only recognised as Date.
If I use a formula 'ToText({SO_PrintLog.SysDateTime} , "dd-MM-yyyy hh:mm:ss") it prints out as 13-12-2016 hh:mm:ss
Is there an easier way them me having to split fields?

Hi Doug,

I created a new report, added a datasource to my 7.00.175.00 database and added SO_PrintLog using the database expert, then created a formula with the content "ToText({SO_PrintLog.SysDateTime} , "dd-MM-yyyy hh:mm:ss")" and it all worked as expected.

I'm not using Crystal Reports 2013 - I'm using crystal reports developer version for visual studio 2015 - which may be different in behavior, but that would surprise me if that is the case. Attached is the report I created and tested with - can you download it and open it with your Crystal Reports 2013, and see if you see the same or different results.

Mike

Hi Mike, thanks for the rapid reply and effort. I downloaded your report and repointed it to my JiwaDemo db and Crystal recognises it as a DateTime field!!
What is really strange is my report sees it as DATE only! and even recognises DB_Main.LastSavedDateTime also as a DATE field? Screenshots attached.
The 2 reports are looking at the identical tables? I have checked in Sql and the design shows as DateTime obviously.
I have also checked other standard reports and they all show Date only for DateTime stamped fields SO it looks like a Crystal 2013 developer issue!
I have emailed Crystal as nothing listed on the web.
Thanks for the help anyway.

I have attached screenshot now.

Hi, Any idea how I can get this info out?? I can't seem to find the correct syntax to split time out. Thanks.

What is weird is my version of Crystal sees ALL DateTime fileds as Date - in DB_Main for instance LastSavedDateTime, LastPurchaseDate, LastPaymentDate are all shown as DATE in Crystal yet in the MNT30000 stored proc the RECORDDate is recognised as DateTime ??
Very odd.

Solved. Didn't find the answers 1st few times I tried. Cheers

This behavior occurs because the report was created with the 'Convert Date-Time Field' box set to 'To Date' or 'To String'. To display the date and time portion of the field, set the 'Convert Date-Time Field' box to 'To Date-Time'.