Hi, I'm trying solve a calendar printing problem where I want to only print the start time on a weekly agenda format. To do this, I create a custom day/week/month view, and then set the start and end columns to both be start. This creates a zero length appointment that when printed only shows the start time. The problem is that reoccurring appointment uses the reoccurrence start/end fields and thus does still prints the start and end time on the weekly agenda view. I thought I could create a UDF based on a formula that would return the start time regardless if the appointment was reoccurring or not.
My formula would be something like this: Format( IIf ( [Recurring], [Start], [Start] ), "DDD mm/dd/yy h:mm AM/PM" )
The appears to work in list view and returns a the start time. When I try to add this UDF to a custom view with the day/week/month format, it's not found, I'm assuming because the day/week/month format is looking for date/time fields.
Does anyone know if there is a way to set a formula as a date/time format so that I can add it to a day/week/month format view?
Thanks,
Ken
My formula would be something like this: Format( IIf ( [Recurring], [Start], [Start] ), "DDD mm/dd/yy h:mm AM/PM" )
The appears to work in list view and returns a the start time. When I try to add this UDF to a custom view with the day/week/month format, it's not found, I'm assuming because the day/week/month format is looking for date/time fields.
Does anyone know if there is a way to set a formula as a date/time format so that I can add it to a day/week/month format view?
Thanks,
Ken