Unable to fetch data withing particular date range through repoint

Anjali_Joshi

Hi All,

We are using DA 6.5.

I am trying to execute below query in repoint (Repository Interrogation Utility EMC Developer Network 2008) and it is not returning any result .(no errors also)

Select count(*) as docs,d.object_name,fr.r_folder_path,d.owner_name,d.r_creation_date from dm_document (ALL) d,dm_folder_r fr where FOLDER('Folder path',descend) AND (ANY d.i_folder_id = fr.r_object_id) and r_creation_date > Date('09/19/2012','mm/dd/yyyy') and fr.r_folder_path is not null group by fr.r_folder_path,d.owner_name,d.r_creation_date,d.object_name

Same query runs fine in DA and returns no of rows as result.

Now in the above query if i change (r_creation_date > Date('09/19/2011','mm/dd/yyyy') )  r_creation_date year from 2012 to 2011 it runs fine in repoint also.

I am unable to get this behavior of repoint.

Have anyone experience this before??