Correct Format for date

[Hypermommy]

Hi all,

I'm trying to run the following first in the query builder then I'll put it in my CSP page.

select si_id, si_name, si_starttime, si_endtime from ci_infoobjects where si_progid = 'CrystalEnterprise.Report' and si_children = 0 and si_instance_object = 1 and si_starttime >= '7/21/2003'

I'm getting 0 objects returned and I know I just ran a report (successfully, if it matters) so I should get at least one. I'm figuring something's wrong with the format I've used for the si_starttime parameter in the where clause becuase if I take that off, everything works fine (except for I get 100s of records).

What am I doing wrong? Thanks!

-= Hypermommy =-

 

[synapsevampire]

What database is your APS in?

This doesn't look like Crystal Enterprise, it looks like Crystal Info, this is a Crystal Enterprise forum.

What are you expectijng to be in si_startime?

Browse the table and check out what's in there, that's a very old version of Info, perhaps there's an olde timer around that recalls...

-k

 

[Hypermommy]

It's CE... (at least if I understand what all is included in CE). I go to Launchpad and then click on CSP Query Builder and then put that query in the textbox.

-= Hypermommy =-

 

[synapsevampire]

Ahhh, OK, the CSP Query builder doesn't use the real database structure, sorry, that threw me because I don't use it.

si_starttime isn't a column in the table, so a straight query against it probably won't work, it's a property contained within a field.

I can't offer much beyond this, though I did try a few tricks. Perhaps someone else has a solution.

-k

 

[pelajhia]

This worked for me: '21-jul-2003'

The rest of your query is ok, I think.

 

[Hypermommy]

Thankee much all!!

-= Hypermommy =-