I have a date field that is pulling from my database as "MM/DD/YYYY".  I have converted the date field to a text date range and have no problems with the dates appearing except when the day field is not populated.  So in the database, it may appear as "11//2012".  I have tried conditional formatting to no avail.  I am trying to figure out a custom style in the Format Editor to see if the day is blank/null to replace the day with the text "TBD" but only partially works.  I have tried conditional formatting, but does not work since I have already converted the date to text.

Hi Dell,

thanks, I tried that but I suspect I am trying this in the wrong place. I have the dates in a subreport.  I then added the dates to a text box and changed the format of the dates from YYYY/DD/MM to "January 1, 2012" format.  The dates are linked via two keys in the subreport in order to link (the dates correctly to the venue (see below).


When I then add run the report, everything is linked properly and all dates appear correctly except if the date appears as "2013-05-" due to a partial date being entered in the database (instead of appearing as 2013/05/20".  If the later is the date that is pulled from the database, no issues.  If it is the former, then the date does not appear on the final report.

I changed the field in the database for the value to appear as text (per suggestion from database people), but that only repeated the information multiple times and the information wouldn't appear.  So went back to original format and trying to figure out in the design phase how to read the dates if crystal sees the dates as "2014-05-" to actually pull the information and change it to "May 2014".   In your experience, where would you insert such a string?  Thanks.

-Maureen

you can evaluate for len, if no date is there,

if len(date)<> 10 then
add the TBD :)

Hi there,

the dates are date type tables. In the db itself, they can appear as below:


When adding the field to the report on the db side, I change the table to read as text upon exporting in the CSV files.  So in the CSV file they appear as two different tables with the data appearing as below.

InfVenueEndDate0_key	eloans_key	InfVenueEndDate	InfVenueStartDate
1	1	2013-10-	2013-05-
2	1	2/16/2014	11/17/2013
3	1	6/22/2014	3/15/2014
4	2	2014	2014-01-
5	3	7/13/2014	3/8/2014

So the issue is that in crystal, the data is not pulling for the first because it does not recognize that as a date because in crystal, I have changed the format for the field from a MM/DD/YYYY date/time stamp to appear as "January 01, 2012" text format.  For some reason crystal just suppresses the first incomplete dates so when I run the preview, the field is empty for the corresponding record.  If the date has the correct date format, the full dates appear in the report.  So it is definitely on the crystal side that is is suppressing.

Here is my linking for the fields:


Since I am getting the information from the CSV files, it is definitely something in crystal with how it is reading the data.  Ugh, this is frustrating.

oops, images didn't make it over. 

Start Date	End Date
05//2013	10//2013
11/17/2013	02/16/2014
03/15/2014	06/22/2014