DATE function for key figure calculation

[andrew_craven]

Hi all,

My S&OP planning area has lowest buckets in months. However I would like to extract the current day (ie 25 when today is 25th May) within a key figure calculation. This would typically be some kind of date function. Anyone done this before/ have any suggestion?

Regards

Andrew

[parveen_kumar6 · Accepted solution]

Hello Andrew

Can you try the function now()? It should return the current date and time (localtime of the server timezone) as date.

Thanks

Parveen Kumar

[sourojit_pal · Accepted solution]

Hi Praveen,

Can we use this function in TREX command?

Regards,

Sourojit

[andrew_craven]

Thanks colleagues for your prompt response. As discussed I will raise an incident on this for more detailed analysis.

Regards

Andrew

[kimon_stergakos]

did you ever get an answer?

[kimon_stergakos]

did you get an answer on your question?

[yeushengteo]

Hello Andrew

Try IF ((to_char((utctolocal(now(),'CET')),'DD')) = '25') works?

Regards.

YS