I need to automatically enter a date into a purchase order form when the blank template is initially opened. But, I need that date to stay as the date the purchase order was then completed not the current date, so this makes the NOW function of no use as it will always return todays date!!!
Please help I'm getting bald patches where I'm tearing my hair out!!