Zum Hauptinhalt gehen



IF function on data field


2 Kommentare

  • Avatar
    Peter Thane

    You could create a VB script routine to do this but the simplest way would probably be to add a second substring to your text field both linked to the expiry field in your database. 

    String 1 should have a Date set as the Type using the Custom format to set it to dd MMM yy

    Sting 2 can be left as the default but with the Transform set to suppress the string if the Previous string is not empty.


    At print time this will result in this (bottom field on the label previews):


  • Avatar
    Dee Laverack

    Thank you Pete, what a great idea!  that worked perfectly.  So much you can do with this software, we don't give it the love it deserves...




Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.