Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dateFormat and DateAdd

Status
Not open for further replies.
Jan 30, 2002
44
CA

Hi All,

Right now the below code gives me below colmuns

2006-Q2, 2006-Q3,2006-Q4,2007-Q1


<td class="table_form_header" width="10%">#DateFormat(DateAdd("q", 0, Now()), "yyyy-Q")##Quarter(DateAdd("q", 0, Now()))#</td>
<td class="table_form_header" width="10%">#DateFormat(DateAdd("q", 1, Now()), "yyyy-Q")##Quarter(DateAdd("q", 1, Now()))#</td>
<td class="table_form_header" width="10%">#DateFormat(DateAdd("q", 2, Now()), "yyyy-Q")##Quarter(DateAdd("q", 2, Now()))#</td>
<td class="table_form_header" width="10%">#DateFormat(DateAdd("q", 3, Now()), "yyyy-Q")##Quarter(DateAdd("q", 3, Now()))#</td>


How do I change the code so that it will start at
2006-Q1, instead of 2006-Q2?

Thanks

 
I got my problem resolved. The aboce code is ok, but I forgot to make the same changes elsewhere in the form.
Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top