You can check the check box in the Section Expert that says "Suppress Blank Section" to suppress the entire section
To suppress a field you can right click on the field and click Format Field and press the formula button (x+2) next to the suppress check box on the common tab and then enter your formula to use as the suppression logic. To this simply put in a function that would return a boolean value where a returned value of true would suppress the field and false would show the field. Remember that you don't need to check the suppress check box if you have a formula entered. Hope this helps.
I believe the conditional statement fails immediately if you encounter a NULL, so your formula needs to test IsNull({tarPrintInvcHdrWrk.Posted}) before it tests equality with "1".
If you have a way of parsing the memo field to separate the date and time out, then you can use the DateTime(date, time) function to combine them together into a date time. Then you should be able to use the CSTR or TOTEXT function to put the datetime in the format that you want.
Something like this should work (or be close to working haha)
Best Answer
You can check the check box in the Section Expert that says "Suppress Blank Section" to suppress the entire section
To suppress a field you can right click on the field and click Format Field and press the formula button (x+2) next to the suppress check box on the common tab and then enter your formula to use as the suppression logic. To this simply put in a function that would return a boolean value where a returned value of true would suppress the field and false would show the field. Remember that you don't need to check the suppress check box if you have a formula entered. Hope this helps.