Day add function Help Please

[weilerdo]

Hi everyone, I have a report that I have a text box which shows the first day of the month (IE Fri ) for June 1st and I have box boxes across the top that I need to have populate based off the first box. I have tried several of the date add functions but nothing is working. I need it to look like this.

Fri Sat Sun Mon Tue Wed

The first field which is called Text74 shows the correct day (Fri) but I can't get the rest to show anything other then error.

Thank yu for looking at this for me I am ready to pull my hair out on this one.

 

[boblarson]

What are you currently trying to use to populate the other boxes?

 

[weilerdo]

Hi Bob

I have tried several differnet things but the one I think is close is

=([Text74]+1)
I have also tried
[Text74] = DateAdd ("ddd",1)

I think it has to have a DateAdd in the Source but I know I am just missing how to get there.

 

[boblarson]

In the controlsource of the text box you can use:

=Format(DateAdd("d",1,[Forms]![YourFormName][YourJune1BoxNameHere]),"ddd")

Then in the next it would be

=Format(DateAdd("d",2,[Forms]![YourFormName][YourJune1BoxNameHere]),"ddd")

Etc...

 

[weilerdo]

Thanks Bob, The only thing is its not in a Form its in a Report I could maybe add a hidden field to the Form and point it that way.

 

[weilerdo]

Hey Bob, Thanks I figuered it out, When you said Forms I went back and checked my query which was formatting it as a day field instead of a date. Once I fixed that I was able to use the following and it works great.

=Format(DateAdd("d",1,[Day]),"ddd")

Thanks Again