cystal reports datetime field become string

Question

0.00/5 (No votes)

See more:

I use sql server 2008 when I put a datetime field into crystal reports it become string type. When I browse the field object it shows as a string type. So that I have issues when I pass a date in selection formula crystal report doesn't recognise as a date. Any reason for this is happening changing the data type from datetime to string in crystal reports?

Posted 27-Jul-12 19:46pm

Reji Ab

Add a Solution

Comments

Kenneth Haugland 28-Jul-12 1:48am

What does it look like in the database and what does it look like in the crystal report. I would guess that it is custom to write datetime.ToString("MM/dd/yyyy") to a document...

Reji Ab 29-Jul-12 10:54am

In the database the data type is datetime(yyyy/mm/dd hh:mm:ss)
It appears as same format in crystal report as well but the data type is string

Kenneth Haugland 29-Jul-12 11:06am

I think this is a common problem, you need to format then string to Crystal Report, and if you want to save a new DateTime youll have to write a formmated DateTime.tostring("MM/dd/yyyy") as the database normally stores the datetime in american culture, and you are pobarbly running on british culture on your machine?

Reji Ab 29-Jul-12 10:48am

if you put DateValue({myTable.strDate}) in the selection formula it
shows an error message "bad date format". My question is why the datetime type changed to string type in crystal report?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

SamarRizvi · Answer 1 · 2012-07-28T16:55:00

Solution 1

You could try the DateValue function:

C#

DateValue({myTable.strDate})

Posted 28-Jul-12 16:55pm

SamarRizvi

Comments

Giorgi Tsagareishvili 12-Feb-20 14:05pm

Tanks... Best solution!