Show a date on a Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob V - 23 Jan 2008 22:11 GMT

Looking to show the Date in a 2 different text box on my report, If I get
these 2 I will work the rest out
1st Day of this month and the first day of next month 1-Jan -2008 and 1-
Feb - 2008
Thanks for any help.....Bob

Reply to this Message

Kevin B - 23 Jan 2008 22:31 GMT

For the first day of this month try this formula in a text box:

=DateSerial(Year(Now()),month(Now()),1)

For the first day of next month try this formula in a text box:

'=DateSerial(Year(Now()),Month(Now())+1,1)

Signature

Kevin Backmann

> Looking to show the Date in a 2 different text box on my report, If I get
> these 2 I will work the rest out
> 1st Day of this month and the first day of next month 1-Jan -2008 and 1-
> Feb - 2008
> Thanks for any help.....Bob

Reply to this Message

KARL DEWEY - 23 Jan 2008 23:32 GMT

Or try this ---
For the first day of this month try this formula in a text box:
=Date()-Day(Date())+1

For the first day of next month try this formula in a text box:
=DateAdd("m",1,Date()-Day(Date())+1)

Signature

KARL DEWEY
Build a little - Test a little

> For the first day of this month try this formula in a text box:
>
[quoted text clipped - 9 lines]
> > Feb - 2008
> > Thanks for any help.....Bob

Reply to this Message

Bob V - 24 Jan 2008 00:49 GMT

Brilliant guys thanks for your help, What if Back to 1st of the Month , then
back to first Monday is that possible
Regards Bob

> Or try this ---
> For the first day of this month try this formula in a text box:
[quoted text clipped - 18 lines]
>> > Feb - 2008
>> > Thanks for any help.....Bob

Reply to this Message

rosa rios - 24 Jan 2008 01:17 GMT

Reply to this Message