If I make my fiscal year starting with January 1 then what would be the date code for a textbox to display that? i tried Date()+90 but that gives me the wrong date! I want to display the quarters of the year, 1, 2 , 3 and 4 in my textboxes. As I said, I will make January 1 as the beginning of the fiscal year. Would there be a way to allow the user to enter a date and then set the fiscal year off of that if they want to change it? Many thanks in advance.
Text49, Text52, Text54, and Text56. I also have a textbox to display just the quarter by number that we are in. Here is the code for that.
=Format([EventStart],"q") EventStart is just a date field.