Update:If anyone else ends up with this issue, I resolved it by changing the Validation and data patterns to num{zzzzzzzzzzzz9} and left the Display and Edit patterns as currency. Still not sure why this suddenly became an issue after 18 months but atleast it's working now.

So I have a timesheet document that we have been using for ages with no issues. I input the information, then save and exit. When i open it back up, the dollar amounts that had been previously entered are back to $0.00. I have never made any changes to this document whatsoever, its all just numbers ...

I am trying to make a field change its fill color based on its expiration date. I have tried to figure out a way to do it using the action builder to no avail. Example:User enters expiration date in the date fieldif the date is greater than 90 days out the fill color stays whiteif the date is greate...