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
Dates in the Report Writer ????
Moderators: Moderators, Tech Support
-
- Tech Support
- Posts: 3015
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: Dates in the Report Writer ????
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.
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.
Re: Dates in the Report Writer ????
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
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
-
- Program Development
- Posts: 1225
- Joined: Fri Sep 05, 2003 11:43 am
- Location: PowerChurch Software
- Contact:
Re: Dates in the Report Writer ????
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
born
to:
CMONTH(born) + " " + TRANSFORM(DAY(born))
This should display the date like: May 19
Re: Dates in the Report Writer ????
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?
Shelley
I have followed this instruction and the "Remove line when blank box is checked."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.
Shelley
-
- Tech Support
- Posts: 3015
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: Dates in the Report Writer ????
Use the Print When field. Enter
not empty(born)
not empty(born)
Re: Dates in the Report Writer ????
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
Shelley