Dates in the Report Writer ????

Moderators: Moderators, Tech Support

Post Reply
Shelley
Posts: 51
Joined: Wed Apr 09, 2008 12:01 pm
Location: Clovis, NM

Dates in the Report Writer ????

Post by Shelley »

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

Zorak
Tech Support
Tech Support
Posts: 3006
Joined: Thu May 13, 2004 9:59 am
Location: PowerChurch Software
Contact:

Re: Dates in the Report Writer ????

Post by Zorak »

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.

Shelley
Posts: 51
Joined: Wed Apr 09, 2008 12:01 pm
Location: Clovis, NM

Re: Dates in the Report Writer ????

Post by Shelley »

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

Jeff
Program Development
Program Development
Posts: 1225
Joined: Fri Sep 05, 2003 11:43 am
Location: PowerChurch Software
Contact:

Re: Dates in the Report Writer ????

Post by Jeff »

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

Shelley
Posts: 51
Joined: Wed Apr 09, 2008 12:01 pm
Location: Clovis, NM

Re: Dates in the Report Writer ????

Post by Shelley »

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

Zorak
Tech Support
Tech Support
Posts: 3006
Joined: Thu May 13, 2004 9:59 am
Location: PowerChurch Software
Contact:

Re: Dates in the Report Writer ????

Post by Zorak »

Use the Print When field. Enter

not empty(born)

Shelley
Posts: 51
Joined: Wed Apr 09, 2008 12:01 pm
Location: Clovis, NM

Re: Dates in the Report Writer ????

Post by Shelley »

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

Post Reply