PI 7.4 Date mapping functionality

[former_member233999]

Hi Experts,

I wish to add the following date functionality to a scenario:

Whereby if a date is less than or greater than 52 weeks over the current date, then for pi to pass the current date, else use the supplied date.

I was thinking I could use the if statement, and an OR statement, but I'm not sure what the best/most effective way to do this would be!

I was thinking datebefore and dateafter might be used, but not sure why they would have two inputs and just the one output.

Can anyone suggests what I might do?

[Former Member]

As Inaki mentioned you can use standard date function. "dateTrans" and use output format as ww to get the week number..with if else combination...

[iaki_vila]

Hi George,

With DateTrans function you can work with weeks as well. Check this blog , it could be helpful to work with dates.

Regards