If the message isn’t delivered, the Receive Date column (using “@D08-” ) shows unwanted characters because the value is zero. The Clarion docs warn against this, but don’t suggest an alternative.
How do I get the browse form to display “-” or something a little less buggy? How do I do some conditional formatting?
All suggestions welcome. Thanks in advance.
Donn
One advantage of the String is you can use words like ‘Today’, ‘Yessterday’, ‘4 Days Ago’ that make it easy to spot recent data without having to read the Date and think of Today’s date
IF Msg:ReceiveDate = 0
RcvString = ''
ELSE
DaysAgo = TODAY() - Msg:ReceiveDate
CASE DaysAgo
OF 0 ; RcvString='Today'
OF 1 ; RcvString='Yesterday'
OF 2 TO 9 ; RcvString=DaysAgo &' Days Ago'
ELSE
RcvString = FORMAT(msg:ReceiveDate,@D08-)
END
END
An alternative would be if its 2 to 6 days ago you show the Day of Week. So if today is Tuesday instead of showing ‘4 Days Ago’ show ‘Friday’. Seems easier to understand ‘4 Days Ago’.
Thanks everyone for the suggestions. For now, I am using the @D08-B date picture, and a similar one for the “receive time” and “delay” pictures. But I will keep the other suggestions in my bag of tricks for future projects or improvements.