Skip to Content
0
Sep 15 at 09:28 AM

How to compare 2 Date fields in the same date dimension in SAC?

58 Views Last edit Sep 15 at 09:46 AM 3 rev

Hi All,

I have a requirement where i have to compare the fields Apr 2021 and May 2021 in Dimension BOM_FROM in the example below. If these 2 are not the same Date, the result of April should be written up to May and the result of May should be written up to Dec.

Can anyone please suggest how to achieve the comparison of these dates within the same dimension?

I tried to use the DATEDIFF functionality but i think this is incorrect as i can only use this across 2 separate Time dimensions.

Any suggestions would be greatly appreciated

Result

Attachments

source-data.jpg (47.7 kB)
result-set.jpg (56.3 kB)