J
Jeff
Thanks Keith,
I followed your formula and with a little messing around I got it to
work. Thanks for the advice about the dateserial, that helped a lot.
It looked like this if you're interested!
=Formato(DataSerial(Formato(Agora();"yyyy");Formato(Agora();"mm")+([InvNo]);
Formato(Agora();"dd")-1);"dd mmm yyyy") prints out as: 30 set 2005
Thanks for the advice, really appreciate it.
Jeff
Keith Wrote:
Hi Jeff,
If I'm understanding you correctly, you want to print a series of 6 pages
with dates showing successive months, all the 15th day, starting with some
designated month. For example, if it were the beginning of October, you
would
want page 1 to have "October 15, 2005", page 2 to have "November 15, 2005",
etc.
If that's what you're after, this will do the trick. In an unbound text
box,
enter the following:
=Format((DateSerial(Format(Date(),"yyyy"),Format(Date(),"mm")+([Page]-1),15)),"mmmm
dd"", ""yyyy")
This generates a series of dates based on the current month and the page
number, starting with (Current Month) 15, (Year). If you want to start
with
a different month than the current, use the "-1" in the formula as an
offset.
"-1" will always start with the current month, "-2" would start with last
month, "0" would start with coming month, etc.
The DateSerial function is really nice in that it's one of the best ways to
count dates forwards or backwards based on year, month, day and know that
your years will calculate properly (e.g., DateSerial(2005, 2-5, 1)
generates
10/1/2004 even though you're only subtracting from the months field).
HTH,
Keith Hufford
EHP, Inc.
I followed your formula and with a little messing around I got it to
work. Thanks for the advice about the dateserial, that helped a lot.
It looked like this if you're interested!
=Formato(DataSerial(Formato(Agora();"yyyy");Formato(Agora();"mm")+([InvNo]);
Formato(Agora();"dd")-1);"dd mmm yyyy") prints out as: 30 set 2005
Thanks for the advice, really appreciate it.
Jeff
Keith Wrote:
Hi Jeff,
If I'm understanding you correctly, you want to print a series of 6 pages
with dates showing successive months, all the 15th day, starting with some
designated month. For example, if it were the beginning of October, you
would
want page 1 to have "October 15, 2005", page 2 to have "November 15, 2005",
etc.
If that's what you're after, this will do the trick. In an unbound text
box,
enter the following:
=Format((DateSerial(Format(Date(),"yyyy"),Format(Date(),"mm")+([Page]-1),15)),"mmmm
dd"", ""yyyy")
This generates a series of dates based on the current month and the page
number, starting with (Current Month) 15, (Year). If you want to start
with
a different month than the current, use the "-1" in the formula as an
offset.
"-1" will always start with the current month, "-2" would start with last
month, "0" would start with coming month, etc.
The DateSerial function is really nice in that it's one of the best ways to
count dates forwards or backwards based on year, month, day and know that
your years will calculate properly (e.g., DateSerial(2005, 2-5, 1)
generates
10/1/2004 even though you're only subtracting from the months field).
HTH,
Keith Hufford
EHP, Inc.