Hello everyone,
Trying to use Crystal for the first time and having an issue with dates. The
user tool crashes when I run the report from an active link.
I Created a view (union of some forms) at the database level called foo using
TSQL and using the followings for one of the columns.
convert(char, dateadd(second, convert(int, MIC.Fecha_envío), '01-01-1971'))
"Fecha_envío_char"
In the Admin tool I create a view form called bar which reads the data from
foo. When I view the data in bar in the user tool, the values in the column
have the format of May 9 2007 12:44PM.
If I include this column in crystal to build my report and test from the
client the latter crashes.
Does the column needs further formatting? Any thoughts?
Many thanks in advance
frexpopo
---------------------------------
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"