Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Cast custom properties in the where clause

  Asked By: Anish    Date: Mar 22    Category: Sharepoint    Views: 721

I have a custom property from my document library, its type is Date and
Time, and I want to use it in the SQL's where clause. My question is,
do I need to cast it? and if so, what is the syntax to do it? I tried

CAST("URN:SCHEMAS-MICROSOFT-COM:OFFICE:OFFICE#BAHCAST" AS "date")<=CAST
("2006-05-03" AS "date")

but it doesn't work, what is wrong...?

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Cast custom properties in the where clause Or get search suggestion and latest updates.




Tagged: