Forum Discussion
Dynamically Filtering TRUNC(SYSDATE) - 1 Without Breaking Query Folding
I have read several questions related to filtering dates without breaking query folding, but none seem to help with my issue. In Oracle I would write: DateColumn BETWEEN TRUNC(SYSDATE, 'YYYY')...
Try DateTime.FixedLocalNow()
each Date.IsInPreviousYear([DateColumn]) and [DateColumn] < Date.From(DateTime.FixedLocalNow())