suffix ;;E will print your empty field as a blank but will print 7:00
as 7: (no zeros to the right of the colon).
This is guaranteed to work. Create a report variable (RV) based
on the below formula and then print the RV formatted as A5. Your
empty time field will print as blank while all other times will print as
you format in the formula.
Here's the formula (P1F2 is your time field):
if P1F2 = 0 then "" else apply.format["T99:99";P1F2] endif
Here's some sample output:
Field Output
----------------------
1 12:57 12:57
2 03:45 03:45
3 00:00
4 06:06 06:06
5 07:00 07:00
6 00:07 00:07
I hope this helps.
Pat Riley
505-797-9072
At 05:20 PM 10/19/2009, you wrote:
You might use the ::H suffix to hide the field.
Sent from my iPhone
Don Friedman
ProfessionalRecords.Com LCC
413-784-1600
412-784-1615 FAX
On Oct 19, 2009, at 4:34 PM, Michael Iannantuoni <[email protected]> wrote:
Don, Thanks for the suggestion but although the text field would display the way I wanted, wouldn't the original time field still display?_______________________________________________
Michael
Don Friedman wrote:
Michael - offhand I'd say that the most obvious way is to use a computed text field programmed to duplicate the time field unless it reads 00:00 in which case it is empty or reads N/A or something like that._______________________________________________
Good luck.
Don Friedman
Pittsburgh
On Sun, Oct 18, 2009 at 7:57 AM, Michael Iannantuoni <[email protected]> wrote:
- I have a database which includes a Time filed formatted as T99:99 so
- that 24 hour clock times display correctly with leading and trailing
- zeros eg 09:30, however some records do not have time data so the field
- displays 00:00. This can be misleading; is there a way to display time
- fields so that entered data displays, even 00:00, but if nothing is
- entered then the field does not display or displays as blanks?
- Michael
- _______________________________________________
- Dataperf mailing list
- [email protected]
- http://lists.dataperfect.nl/mailman/listinfo/dataperf
--
Don Friedman
ProfessionalRecords.Com LLC
PRS Data Systems
205 S Main Street
Pittsburgh, PA 15215
412-784-1600 - 1-800-PRS-FILE
412-784-1615 Fax
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
