Data View problem - can't filter or format calculated date fields

J

Jose

I use FP to customize Sharepoint Services pages. I use the Sharepoint Data
View Web Part extensively. I have a problem that I believe is caused by a bug.

I use Data View to display the contents of an SP List data source. The list
has 3 calculated columns: Two are numeric and one is a date. I then use these
fields to filter and set conditioned formatting in the Data View.

There is no problem using the numeric calculated field for the purpose.
However, operations in the calculated data field do not work.

Conditioned Formating - If I set conditioned formatting based on the
calculated date field, the result of the formatting shows in the Data View at
design time, but the formatting dissapears when the page is displayed in IE
6.0. For example, if I set the date field lower than a given date to display
as bold red, the fields with these criteria will show red and bold at design
time, but they will revert to regular font when displayed in IE

Filtering - Filtering works when I set the filter at design time using the
filter wizard. However, filtering does not work from the Filter/Group/Sort
tool bar at run time.

By the way, the calculated date field is pretty simple: =[TODAY] + 10

I also tried =DATE(YEAR([Due Date]),MONTH([Due Date]),DAY([Due Date])+10)

I also tried a second date column that simply copied the contents of the
first. None works

In contrast, the calculated numeric fields are very elaborate, and they work
fine.

Any help will be appreciated
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top