Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Bad date format string Post Reply Post New Topic
Author Message
Paul 72
Newbie
Newbie
Avatar

Joined: 09 Nov 2011
Online Status: Offline
Posts: 4
Quote Paul 72 Replybullet Topic: Bad date format string
    Posted: 09 Nov 2011 at 8:20am
I have a report that works at work on a PC.However at home on the laptop it shows an error Bad date format string.
Is there a setting within options that i need to tick.
As this report works ok on my PC.Confused
Thanks for your time and help
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 09 Nov 2011 at 9:30am
this is more likely to do with the data set of returned values in the report when it is being run.
IP IP Logged
Paul 72
Newbie
Newbie
Avatar

Joined: 09 Nov 2011
Online Status: Offline
Posts: 4
Quote Paul 72 Replybullet Posted: 10 Nov 2011 at 11:11pm
Thanks for your reply
But i am new to crystal reports and i do not know where to correct this error.
 
Could you please explain in more detail.
 
Thank you
Thanks for your time and help
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 11 Nov 2011 at 3:04am
Do you have a formula to convert a string into a date?
Usually the bad format error is when a formula is trying to convert a string into a date field but it finds a particular row of data that cannot be converted into a valid date. If you have a formula that is doing this you can use an isdate() function to check if the result is a valid date or not.
IP IP Logged
Paul 72
Newbie
Newbie
Avatar

Joined: 09 Nov 2011
Online Status: Offline
Posts: 4
Quote Paul 72 Replybullet Posted: 11 Nov 2011 at 3:26am
The crystal Report works fine , i have tested it on 3 other computers.The problem is that when i try to run it on my laptop it comes up with Bad date format string.
So therefore it has to be a setting on my laptop or on the crystal report programme. (i think)
Thanks for your time and help
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 11 Nov 2011 at 3:32am
It is possible but I would not know where to look for that setting.
When you run it on your lap top are you using the exact same set set of data as on the other computers? If any row is different that can cause the error.
IP IP Logged
Paul 72
Newbie
Newbie
Avatar

Joined: 09 Nov 2011
Online Status: Offline
Posts: 4
Quote Paul 72 Replybullet Posted: 11 Nov 2011 at 3:37am
It is the same settings as i have even selected it from the intranet. And tried to refresh the report.Confused
Thanks for your time and help
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.018 seconds.