Where Clause DateTime formats

[KidFix]

ello all

thanks for reading my thread. Can anyone tell me what format DateTime fields can be passed into a report in the where clause?

I've got a few reports that pass in dates like this:

{SDK_VW_WorkOrdersReporting.DateTimeCreated} >= Date(2003,02,13)

but none that handle DateTimes

Thanks

 

[Naith]

DateTimes are represented as DateTime(yyyy,MM,dd,hh,mi,ss).

e.g.: DateTime(2003,03,13,14,00,01) for 2:02pm today.

Naith

 

[KidFix]

Great thanks!

 

[cmpgeek]

try this:

{SDK_VW_WorkOrdersReporting.DateTimeCreated} >=

DateTime (YYYY,MM,DD,HH,MM,SS)

 

[KidFix]

one last thing, is this the only format that it'll accept