topic Where Condition in App Development

Where Condition

danny4202001 — Thu, 06 Oct 2022 14:12:43 GMT

hello friends,

How to change the below where condition if we need data starting last week to future infinite everything available in the source

Weekstartdate = WeekStart(Now(),-1,0)

Thanks,

QFabian — Thu, 06 Oct 2022 14:15:16 GMT

Hi @danny4202001 maybe this :

Where

datefield >= today()-7

Weekstartdate = WeekStart(Now(),-1,0)

danny4202001 — Thu, 06 Oct 2022 16:59:06 GMT

Hello Fabian,

Thank you for the reply, What if you need data from YTD?

Thanks

QFabian — Thu, 06 Oct 2022 19:21:32 GMT

datefield >= yearstart(today())