Issue filtering dates in set analysis

[Anonymous]

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

[sunny_talwar · Accepted solution]

Try this

Sum({<InventoryFrozenOrdType -= {'PRS'}, InventoryFrozenInventoryType = {'FINISH'}, InventoryFrozenStat ={'B'}, InventoryFrozenInventoryDate = {"$(='>=' & Date(YearStart(Max(InventoryFrozenInventoryDate)), 'DD-MM-YY') & '<=' & Date(Max(InventoryFrozenInventoryDate), 'DD-MM-YY'))"}>} InventoryFrozenTon)

[Anonymous]

Thank you Sunny! This works!