User Support Forum

I am working on a directory. I have included birthdays, but don't have the dates for everyone. I have selected "Remove line when blank," but it prints the "/" whenever the birth date is missing. How do I fix this?

Better yet is there a way to print "mm dd" or "dd mm" instead of dd/mm?

Shelley

Double click the born field (birthday) to open the field properties.
Click on the Format tab.
Select Date, then check the "Blank if empty" box.

I don't see a way to remove the slashes in the valid dates, though.

I have tried that and I still get the slash.

I did not phrase my second question very well. Instead of the dates reading 07/09, I would prefer July 9 or even 9 July instead. I see I can do that and include the year (09 July 1995), but is there a way to do it without the year?

Shelley

Shelly, to do what you want to do, you will have to enter an expression instead of the just the field. Double click the field in the layout that says born. A field properties box should open, change the expression from:

born

to:

CMONTH(born) + " " + TRANSFORM(DAY(born))

This should display the date like: May 19

Thank you Jeff. I prefer that format. I am still having trouble printing nothing and eliminating the line when I don't have the information for a given member. As stated previously, when using the mm/dd format the slash would be left behind. Using the Month day format, I get "0*bad date*" when the born field is empty. What am I doing wrong and how do I fix it?

Double click the born field (birthday) to open the field properties.
Click on the Format tab.
Select Date, then check the "Blank if empty" box.

I have followed this instruction and the "Remove line when blank box is checked."

Shelley

Use the Print When field. Enter

not empty(born)

Thank you. I did exactly what you said and it worked, but I don't understand why and what I just did. I understood it when I applied them to the text labels as addressed in another thread and it made sense to me, but I don't get this and why it worked.

Shelley