I am working on a cross-tab report and I would like the x axsis to show the date. I have also added a formula that makes that starting day of the week Saturday.
I have created a Stored procedure that produces two fields
TimeHourGroup (varchar) and Volume (INT).
I can't seem to create a forumla in the crystal expert that will allow me to convert the TimeHourGroup (in format 10:00 20/1/2002) back to a datetime. Does anyone know how to do it in the crystal formula?
I have created a Stored procedure that produces two fields
TimeHourGroup (varchar) and Volume (INT).
I can't seem to create a forumla in the crystal expert that will allow me to convert the TimeHourGroup (in format 10:00 20/1/2002) back to a datetime. Does anyone know how to do it in the crystal formula?