B
Bert_Bert
Hi,
I have created special Form with my own Birthday field of Date/time type.
All my contacts are based on this form and have birthday filled in. I did
not want to use the built-in feature because it puts some records into
calenda\r and is not fully under my control.
OK, now I want to create automatif formating rule to show in RED color all
the contacts, for which their birthdate (i.e. regardless the year) will
happen in 5 days.
So I created the following condition for my user-defined "Birthday"
is between
(Dateserial( year([Birthday]), month(now), day(now) ))
and
(10 days after dateserial( year([Birthday]), month(now), day(now) ))
that is, I am trying to transform current date back to the Birthday to be
able to pass it as a filtered value
Filtering parser does not return any error, however, my contacts that fall
into this scope are not in RED color, there must be some mistake.
I welcome any other tip how to reach this, however, I do not want to bind it
to my Calendar in any way, because I want to keep the possibility to
add/remove contacts and keep the list of birthday up-to date and only at one
single place without scripts, events and difficulties connected with such a
solution.
Thanks for any tips
I have created special Form with my own Birthday field of Date/time type.
All my contacts are based on this form and have birthday filled in. I did
not want to use the built-in feature because it puts some records into
calenda\r and is not fully under my control.
OK, now I want to create automatif formating rule to show in RED color all
the contacts, for which their birthdate (i.e. regardless the year) will
happen in 5 days.
So I created the following condition for my user-defined "Birthday"
is between
(Dateserial( year([Birthday]), month(now), day(now) ))
and
(10 days after dateserial( year([Birthday]), month(now), day(now) ))
that is, I am trying to transform current date back to the Birthday to be
able to pass it as a filtered value
Filtering parser does not return any error, however, my contacts that fall
into this scope are not in RED color, there must be some mistake.
I welcome any other tip how to reach this, however, I do not want to bind it
to my Calendar in any way, because I want to keep the possibility to
add/remove contacts and keep the list of birthday up-to date and only at one
single place without scripts, events and difficulties connected with such a
solution.
Thanks for any tips