Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm trying to filter a set expression by year. The issue is that the data base only have a field compound by DD-MM-YY (InventoryFrozenInventoryDate).
Does anyone knows what can I do?
Thank you,
Sofia
Try this
Sum({<InventoryFrozenOrdType -= {'PRS'}, InventoryFrozenInventoryType = {'FINISH'}, InventoryFrozenStat ={'B'}, InventoryFrozenInventoryDate = {"$(='>=' & Date(YearStart(Max(InventoryFrozenInventoryDate)), 'DD-MM-YY') & '<=' & Date(Max(InventoryFrozenInventoryDate), 'DD-MM-YY'))"}>} InventoryFrozenTon)
Thank you Sunny! This works!