Date on a report or form

[jmar93]

I am new to Access and was hoping someone could help me with a question. On a report or form you can place "=Date()" in a text box to display the current date, is there a way to have it display the dates of the current week, Sunday - Saturday?

thanks,
Jeff

[debasisdas]

Hi Jeff

Welcome to TheScripts family.

Feel free to post questions in the related forum only by choosing from under the blue bar on the top of your page.

Please follow the posting guidelines in every new post/reply.

Please specify your post/question clearly.Please use proper code tags in all your codes.

Regards
Debasis

[grays]

I am new to Access and was hoping someone could help me with a question. On a report or form you can place "=Date()" in a text box to display the current date, is there a way to have it display the dates of the current week, Sunday - Saturday?

thanks,
Jeff

try this...

=Date()-Weekday(Date())+3

this will give you tuesday of the current week
Wed +4
Thur +5
Fri +6
Next Mon +9

[missinglinq]

For the start and ending dates of the week:

Date() - (Weekday(Date()) - 1) & " - " & Date() - Weekday(Date()) + 7

Welcome to TheScripts!

Linq ;0)>

[jmar93]

Thanks for the replies, works great. Just the help I needed.

thanks again,

Jeff

[missinglinq]

Glad we could help!

Linq ;0)>

[jmar93]

For the start and ending dates of the week:

Date() - (Weekday(Date()) - 1) & " - " & Date() - Weekday(Date()) + 7

Welcome to TheScripts!

Linq ;0)>

How would I write this to display the dates of the current month or the previous month?

thanks,
Jeff

[missinglinq]

If you mean the first and last of the current month and first and last of the previous month:

'First of the current month
DateSerial(Year(Date), Month(Date), 1)

'Last of the current month
DateSerial(Year(Date), Month(Date) + 1, 0)

'First of the previous month
DateSerial(Year(Date), Month(Date) - 1, 1)

'Last of the previous month
DateSerial(Year(Date), Month(Date), 0)

Linq ;0)>

[jmar93]

If you mean the first and last of the current month and first and last of the previous month:

'First of the current month
DateSerial(Year(Date), Month(Date), 1)

'Last of the current month
DateSerial(Year(Date), Month(Date) + 1, 0)

'First of the previous month
DateSerial(Year(Date), Month(Date) - 1, 1)

'Last of the previous month
DateSerial(Year(Date), Month(Date), 0)

Linq ;0)>

Works perfectly.

Thank you,

Jeff

[missinglinq]

Glad we coul help again!

Linq ;0)>