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