ACCESS FEED: Re: [MS_AccessPros] Re: Date formula problem

Jumat, 16 Mei 2014

Re: [MS_AccessPros] Re: Date formula problem

Thanks for letting us know you've got it working.

-Bill

---In MS_Access_Professionals@yahoogroups.com, <dyspoz2@cox.net> wrote :

All,

I slaved over my db yesterday and today and the queries ran just fine by themselves. However, when my macros ran them it ended up with problems. So, I went through my lengthy macros and did a bit of rearrangement and somehow now they are ok. Something went 'bump in the night' I guess.

Russ

On 5/14/2014 3:02 PM, wrmosca@comcast.net [MS_Access_Professionals] wrote:

Russ
If you post your entire query we might be able to spot the problem.

-Bill

---In MS_Access_Professionals@yahoogroups.com, <dyspoz2@cox.net> wrote :

Maybe that is not my problem. My query does not appear to be updating the table at all as the value in that table is a Wednesday date back in April. I guess I'll have to investigate further.

On 5/14/2014 11:03 AM, wrmosca@comcast.net [MS_Access_Professionals] wrote:

Russ
I got June 4. What date did you run this when you got the wrong date?

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com

---In MS_Access_Professionals@yahoogroups.com, <dyspoz2@cox.net> wrote :

Gentlemen,
I've got two update queries that I want to update the date value of
different fields. One appears to be working ok but the other one only
occasionally works. This first one works ok, and updates a date to the
first Sunday of the month in the following month. For example, it
updates a table's date field for the first Sunday in June (next month)
to the value of 6/1/2014 and it looks like this:

IIf(Weekday(DateSerial(Year(Date()),Month(Date())+1,1))=1,DateSerial(Year(Date()),Month(Date())+1,1),DateSerial(Year(Date()),Month(Date())+1,1)+8-Weekday(DateSerial(Year(Date()),Month(Date())+1,1)))

The second one is supposed to update a date field to the first Wednesday
of the following month. For example, if it is run it is supposed to
update the date field for the first Wed in next month (June) to
6/4/2014. But it does not do that.

IIf(Weekday(DateSerial(Year(Date()),Month(Date())+1,1))>4,DateSerial(Year(Date()),Month(Date())+1,1)+11-Weekday(DateSerial(Year(Date()),Month(Date())+1,1)),DateSerial(Year(Date()),Month(Date())+1,1)+4-Weekday(DateSerial(Year(Date()),Month(Date())+1,1)))

Anyone good at these date calculations?

Russ

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.3469 / Virus Database: 3722/7492 - Release Date: 05/14/14

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.3469 / Virus Database: 3722/7496 - Release Date: 05/14/14