G
Guest
Target Date is
my control source
=DateAdd("m",-2,[Forms]![frmProjects]![BuildDate])
I need some help I can't figure out the field value less than, between or
??...
what I am trying to do is:
when I am within 30 days or less of the builddate turn yellow
DateAdd("d",-30,Forms!frmProjects!BuildDate)
within 14 days or less I want to turn maroon
DateAdd("d",-14,Forms!frmProjects!BuildDate)
But if the target date is earlier than calculated date from the build date
it has expired red
Can someone help me I keep trying different combinations but the -# is
making me crazy.
Thanks
my control source
=DateAdd("m",-2,[Forms]![frmProjects]![BuildDate])
I need some help I can't figure out the field value less than, between or
??...
what I am trying to do is:
when I am within 30 days or less of the builddate turn yellow
DateAdd("d",-30,Forms!frmProjects!BuildDate)
within 14 days or less I want to turn maroon
DateAdd("d",-14,Forms!frmProjects!BuildDate)
But if the target date is earlier than calculated date from the build date
it has expired red
Can someone help me I keep trying different combinations but the -# is
making me crazy.
Thanks