Using Date functions in free conditions

Technical support

Moderators: Bob Cergol, Data Access, Cintac

Using Date functions in free conditions

Postby Bob Cergol » Tue Aug 24, 2010 7:53 pm

Hello,

I'm wondering if it is possible to use Dynamic AI's extensive pre-defined date functions in free conditions. If so, I can't seem to get the syntax correct and get an error when running the report:
EntDate = @prevw()

I've never tried to use them in free conditions before but am trying now because I want to test doing some conversion of date values from a problem-prone database where using the function on the normal column/condition line works only in certain circumstances.

Other Examples:
lg_EntryDateTime between @mth-1()
Datepart(month,lg_EntryDateTime) = @mth-1()
(Datepart(month,lg_EntryDateTime)) = (@mth-1())
Convert(char,lg_EntryDateTime,101) = @mth-1()
Cast(lg_EntryDateTime as SmallDateTime) = @mth-1()

Regards,
Bob
User avatar
Bob Cergol
Certified Dynamic AI Professional
 
Posts: 359
Joined: Fri Dec 11, 2009 5:48 pm

Return to Technical Support

cron