Date for frist quarter of the year, year starts January 1

[burrina]

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.

[alansidman]

Consider using the DateAdd function

http://www.techonthenet.com/access/f...te/dateadd.php

[JoeM]

Instead of using Date()+90, use the DateAdd function where you can specify exactly the number of months to add, i.e.
Quarter2: DateAdd ("m",3, [MyDateField])
Quarter3: DateAdd ("m",6, [MyDateField])
Quarter4: DateAdd ("m",9, [MyDateField])


EDIT: Whoops, slow typing. Didn't see Alan's reply until afer I posted.

[burrina]

Thanks so much.

[burrina]

Where jan =DateSerial(Year(Date()),1,1) Beginning of current year. January 1. IS THIS CORRECT ?

Quarter1: DateAdd ("m",1, [jan])
Quarter2: DateAdd ("m",3, [jan])
Quarter3: DateAdd ("m",6, [jan])
Quarter4: DateAdd ("m",9, [jan])
__________________________________________________ ______________________________________
jan =DateSerial(Year(Date()),1,1) Text49 = DateAdd("m",1,[jan])+60

DateAdd("m",1,[jan])+60 First Quarter of Year
DateAdd("m",3,[Text49]) Second Quarter of Year
DateAdd("m",6,[Text49]) Third Quarter of Year
=[Text54]+90 Fourth Quarter of Year


Text54 is the 3rd Quarter and equals DateAdd("m",6,[Text49])