Comparing timestamp attribute with current period in IBP

[former_member380205]

What is the Syntax or the process to compare a timestamp attribute (such as "Releasedate") with the current date/period?

I have tried the below syntax,

KF2@PERPRODCUST = IF("RELEASEDATE" > "$$PERIODIDCU$$", KF1@PERPRODCUST,0)

Although the planning area gets activated it gives me a "Error in refresh sheet" error when i try to load the KF2 in the Excel planning view

[tin_dinh_trung · Accepted solution]

Hi,

I have same situation like your.

And below solution works for me last time, please try and give feedback.

KF2@PERPRODCUST = IF("RELEASEDATE" > NOW(), KF1@PERPRODCUST,0)

Thank.

[former_member367912 · Accepted solution]

Hi Tin,

Thanks for sharing this information, Its highly useful

I have checked in my system and it works perfectly specially the comparison to current date.

Regards,

Akhilesh Agarwal