Hi

I'm am in the beginning fase of creating a Scheduler module for an application. We have used LLBLGen through the whole application.

But I can´t see how I can do the follwing with LLBL. (I want to let the database do the job)

In pseduo SQL

select * from booking where "tablefield.creationdate+3 month" > parameter.today

So I want to add a timespan to a date field on the database and then filter on the result by the predicate.

Is that possible?.(I really hope!) If so can you give a hint?

Thanks Alot!

Anders, Denmark

Hi,

You can try:

date = today - 3 month

"tablefield.creationdate" > date

How does that map to LLBLGen? I might have misunderstood your answere or the otherway around. Thanks

Anderskj1 wrote:

How does that map to LLBLGen? I might have misunderstood your answere or the otherway around. Thanks

I think he meant:

DateTime date = DateTime.Now().AddMonths(-3);

and then pass 'date' as the value for a CompareValue predicate on creationdate