jasonboetcher
asked on
Changing from Date to DateTime datatype
I'm using an Active Date ttx file in Crystal Reports 6. I have a field defined as date type and I need it to be datetime. I tried changing the type to datetime in the ttx file but it still only shows up as date when I create the report. How can I have this field display as datetime format?
ASKER
I changed the line in my ttx from:
Date_Entered date 04/22/02
to:
Date_Entered datetime 04/22/02
and then verified the database and the date field still shows as a date and not a datetime....
Date_Entered date 04/22/02
to:
Date_Entered datetime 04/22/02
and then verified the database and the date field still shows as a date and not a datetime....
What do you mean it is showing as a date in the report and not a datetime?
If all you did was change the field to a datetime from a date the time part probably doesn't have any data in it and it will still look like a date. Change the value of one of the fields to include a time and see what you get.
Also check to ensure your fields in the report aren't formatted to show only a date. If they are change the format to include the time.
good luck
mlmcc
If all you did was change the field to a datetime from a date the time part probably doesn't have any data in it and it will still look like a date. Change the value of one of the fields to include a time and see what you get.
Also check to ensure your fields in the report aren't formatted to show only a date. If they are change the format to include the time.
good luck
mlmcc
ASKER
This is what I need to know -----> " If they are change the format to include the time." How do I do this in version 6?
In CR you can right click on the field and select Format. From there you can set the format the way you want. Ensure the selected format includes the date and time formats.
In the database select a record and change the datetime field to 04/22/02 11:55:03AM
good luck
mlmcc
In the database select a record and change the datetime field to 04/22/02 11:55:03AM
good luck
mlmcc
Another thought in CR ensure you don't have save data with report selected under the file menu. If you do unselect it and resave the report.
mlmcc
mlmcc
ASKER
This does not work:
"In CR you can right click on the field and select Format. From there you can set the format the way
you want. Ensure the selected format includes the date and time formats."
When I select the field, it is only a date field, so it only lets me change the date format.
I am now passing the field in as a string initially, then converting it to a datetime field using the Crystal conversion formulas. This seems to be working how I need it to.
"In CR you can right click on the field and select Format. From there you can set the format the way
you want. Ensure the selected format includes the date and time formats."
When I select the field, it is only a date field, so it only lets me change the date format.
I am now passing the field in as a string initially, then converting it to a datetime field using the Crystal conversion formulas. This seems to be working how I need it to.
Need anything more?
mlmcc
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified abandoned. I will make a recommendation to the moderators on its resolution in a week or two. I appreciate any comments that would help me to make a recommendation.
Unless it is clear to me that the question has been answered I will recommend delete. It is possible that a Grade less than A will be given if no expert makes a case for an A grade. It is assumed that any participant not responding to this request is no longer interested in its final disposition.
If the user does not know how to close the question, the options are here:
https://www.experts-exchange.com/help/closing.jsp
mnye
EE Cleanup Volunteer
Unless it is clear to me that the question has been answered I will recommend delete. It is possible that a Grade less than A will be given if no expert makes a case for an A grade. It is assumed that any participant not responding to this request is no longer interested in its final disposition.
If the user does not know how to close the question, the options are here:
https://www.experts-exchange.com/help/closing.jsp
mnye
EE Cleanup Volunteer
Under the DATABASE menu select VERIFY DATABASE.
good luck
mlmcc