C
Cessna172
My company is going to send everyone a card and gift on their birthday, so
staff in admin want to see whos birthday is due. I created a view
containing name, address, category (only certain categories receive a card)
and birthday (from the details tab of the contact form).
However, all of the date formats I can use in a view contain the year, so I
can't group each months birthdays together. so, I created a new field from
a formula to create the month and day as seperate columns, but I can't sort
on them!!
How can I give admin a view that shows birthdays grouped into months? Will
I need to export the data and do the report in onother application like
outlook?
staff in admin want to see whos birthday is due. I created a view
containing name, address, category (only certain categories receive a card)
and birthday (from the details tab of the contact form).
However, all of the date formats I can use in a view contain the year, so I
can't group each months birthdays together. so, I created a new field from
a formula to create the month and day as seperate columns, but I can't sort
on them!!
How can I give admin a view that shows birthdays grouped into months? Will
I need to export the data and do the report in onother application like
outlook?