Skip to main content
Question

Multiple rule date formula.

  • Jun 16, 2023 7:31 PM UTC
  • 0 replies
  • 111 views

SaviNewman1
Forum|alt.badge.img+6

Good afternoon, 

I currently have a formula date named "Sanitary Survey Due" based on a different field:

WeekdayAdd([Last Hazard Survey:], 1305)

I also need this formula to have it so the date that is displayed for Sanitary Survey Due be ONLY the year, and not a date, but I don't know how to do this. 



------------------------------
Newman, Savi
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+20
  • Qrew Champion
  • Jun 16, 2023 7:47 PM UTC

There is a year function in QB to accomplish just this.

[Year Of Sanitary Survey Due] = Year([Sanitary Survey Due])

I believe the formula will need to be formula numeric.



------------------------------
Mike Tamoush
------------------------------