I have a document library which has a calculated column (in a date format) and I am unable to query using this.

What I need to do is to report on which documents are due to be reviewed based columns added to the library.

• Issue Date [Date]
• Review Period [Number]
• Next Review Date [Calculated Date = Issue Date + (Review Period*365) ]

When I use the Query Builder this field has a value type of 'Calculated' and appears to operate like a text value rather than a date value and so I can't compare against a given date correctly.

<query>

 

<Where>

 

<Leq>

 

<FieldRef Name="Next_x0020_Review_x0020_Date" />

 

<Value Type="Calculated">date('now')</Value>

 

</Leq>

 

</Where>

 

</query>

 

 

How can I read the calculated column as a date value and be able to query properly

 

Thanks

 

 

 

Hi,

Glad you could solve the problem.

Will add a bug in our database so that calculated columns default to their target data type rather than "calculated".

Regards,

---

Frederic LATOUR
ENESYS

Hi Bill,

If I understand correctly what you want, you want to have the parameter drop down list to be filled with all the values available in the list. Then, you select a value from the drop down list to get only items where "ReportTrack" is equal to the selected value?

If it's the case, you will need to have two datasets:

1. The first dataset will query the list and return all the "ReportTrack" values available in this list.
2. The second dataset will be the one you give us just above. The "track" parameter's available values should be filled by the values of the "ReportTrack" column from the first dataset. For more information, you can see the "In Operator" report sample provided as part of the solution.
   In this report, the "param" parameter's values are filled by the values returned by the "DistinctCategories" dataset.
   
   

Regards,
Marien MONNIER
Enesys