Days till birthday

[Ronji]

Hi there all you amazing geniouses (if thats correct)

I need a calc that will tell me how many days till a birthdate.

I have tried this (Get(CurrentDate)-BirthDate)/365.2425 but if the date is passed it does some strange things.

Any help will be greatly appreciated regards Ron

[BobWeaver]

I didn't test this, but I think it should work:

Let([

Today=Get(CurrentDate);

A= Date(Month(Birthdate),Day(BirthDate),Year(Today))-Today;

B= Date(Month(Birthdate),Day(BirthDate),1+Year(Today))-Today];

Case(A>=0;A;

If today is your birthday, the formula will give you a value of zero, if you want it to give 365, then change the last line to:

Case(A>0;A;:)