Current Date in Transfer Rules Formula Editor

[Former Member]

Hi!

Anyone aware how to get todays' date in the Transfer Rules Formula Editor?

Aim is to calculate ones actual age based on a given birthday-month-year using the dateDifference function.

Cheers

[Former Member · Accepted solution]

Hi,

The summary of both posts:

Use a formula

DATE_DIFF( SYST-DATUM, BDAY)

As you understand, the difference will be in days.

Best regards,

Eugene

[Former Member · Accepted solution]

Any clever way (available series of formulae) to turn this into years without having to go through all of the maths?

Tnx,

[Former Member · Accepted solution]

Hi,

I think

TRUNC (Diff / 365 + 0.5) is a good nearest integer value.

Best regards,

Eugene

[Former Member · Accepted solution]

Sure,

but this doesn't take into account leap years. I was hoping there was DATE functionality that takes into account all of these. DATEDIFF does this to get to the correct number of days, so when calculating back to years there should be a way to apply leap year calculations too.

Tnx,

A

[Former Member · Accepted solution]

How many decimals do you want to have in calculated age?

The difference between results while dividing by 365 or 366 is around 0.07%.

Moreover, you can use 365.25 instead of 365 for more accurate calculation.

Best regards,

Eugene

[Former Member]

Inside the Forula editor,

you can access the birtday field and SYST-DATUM ( current datum )

So write as follows--( by double clicking on the fields =

SYST-DATUM - BDAY INfoobject

regards,

Hari