Two Trciky Questions

[Guest_imported]

Hi
I have two simple but tricky questions when dealing with the field formulas.

1) I want my dates to display Am and PMs but not Military time.

I have used following field formula to do that, but what i see is ... 13:30PM-14:30 pm like that!!!

but i need 1:30PM-2:30PM likewise....

can anybody help me!!!

2) second one is------------->>>>

I have to display Days as M-MOnday,T-tuesday ...like wsie
in a row as 'MT....'

what I have to do is i have to put a comma between them if more than one day exists..like M','T...
and if only one field exists then this comma should not appear.

the code is as follows::
if {@mon} <> ' ' or {@tues} <> ' ' or {@wed} <> ' ' or {@thurs} <> ' ' or {@fri} <> ' ' or
{@sat} <> ' ' or {@sun} <> ' ' then
totext({@mon}) + totext({@tues}) + totext({@wed}) + totext({@thurs}) + totext({@fri}) +
totext({@sat}) + totext({@sun})
else
&quot;TBA&quot;

I have to add a comma if more than one day exists!!!

help appreciated

 

[kenhamady]

1) If the field is a date field, you can format it any way you like without formulas. Select the field and use menu options &quot;Foramt - Field&quot;

2)Do you have multiple dates in the same record (very rare) or are you doing this once per group? Will the dates be consecutive or could you have T,W,F Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com