Find the 1st day of a month / Last day of month

by MYLE 21. June 2010 21:23

I had to Find the Last day on the Month that the hard bit but got thinking why note just find the first day on the next month then -1 day form that so here it is

 

Function st1month(Tdate)
    st1month = DateSerial(Year(Tdate), Month(Tdate) + 1, 1)
End Function

OK now let find the Last day on month

Function LastDay(Tdate)
    Lastd = dateadd("m",1,st1month(Tdate))
    LastDay = DateAdd("d", -1, Lastd)
End Function

Must have both function in your code.

Category: MSaccess, VB, Dislexia
Tags:
Comments (14)
E-mail Kick it! DZone it! del.icio.us Permalink Post RSS

Comments

7/28/2010 6:12:16 PM #

HostMonster Review

Thank you for this blog post, It's fantastic to see another BlogEngine user. Most users these days seem to use Wordpress, but I think BlogEngine.NET is the better system to use.

HostMonster Review United States |

7/29/2010 4:40:09 PM #

MYLE

was think of going to word press but could not get working on IIS then I found this and it even teaching me asp-net Smile

MYLE |

11/22/2010 9:23:00 PM #

cheap annual travel insurance

This text is admittedly resourceful, I truly stumbled upon this site not knowing i would get this sort of wealthy content and knwoledge. I've additionally checked on different poss of yours and so they had been fairly enlighten and educative. You really did a pleasant job. Hold it up.

cheap annual travel insurance United States |

11/22/2010 11:28:48 PM #

Mike Foster

I don't usually check out these types of sites (I'm a pretty modest person) - but even though I was a little surprised as I was reading, I was definitely a bit excited as well. Thanks for giving me a big smile for the day Smile

Mike Foster United States |

11/23/2010 12:25:12 AM #

insurance for young drivers

This article is absolutely resourceful, I truly stumbled upon this site not figuring out i would get this type of wealthy content material and knwoledge. I've also checked on different poss of yours and they were fairly enlighten and educative. You actually did a pleasant job. Maintain it up.

insurance for young drivers United States |

12/3/2010 12:36:18 AM #

Evelyn Thrill

I cannot think that you simply blogged about this subject.  Not too numerous people today understand the significance of these types of items

Evelyn Thrill United States |

12/3/2010 11:42:01 PM #

Wilson Racquets

Truly love this post. It's hard to sort the good from the bad at times, but I do believe you've nailed it!

Wilson Racquets United States |

12/4/2010 7:08:14 PM #

Brianna Moore

banquet main here

Brianna Moore United States |

12/4/2010 9:53:58 PM #

Gomez Garcia

Couldn't be written any better. Reading this post reminds me of my old room mate! He always kept talking about this. I will forward this article to him.Pretty sure he will have a good read. Thanks for sharing!yahoo

Gomez Garcia United States |

12/29/2010 1:41:27 PM #

Fatburner

At what physique excess fat proportion does your abs start appearing? Okay so i labored out all summer to obtain much more reduce. I have lost bodyweight. Correct now I weigh 137. I'm 5'6. My arms are fairly cut, my chest and shoulders are muscular. My stomach is truly flat but no abs but. At what body extra fat percentage does your abs begin appearing? I'm can't tell you what my physique extra fat proportion is but but I'm gonna go acquire a entire body extra fat scale to ensure that I'll have the ability to keep track.

Fatburner United States |

1/13/2011 9:10:28 PM #

sikiş

I was just thinking about Diagnosisand you've really helped out. Thanks!

sikiş United States |

1/24/2011 3:56:04 PM #

Online Coupons

Thats the same thing i heard  its such a great deal

Online Coupons United States |

2/3/2011 3:54:57 PM #

larry

Fantastic blog. Having some issues with compatibility with the iPhone 4 however.  Has anyone else had issues?

larry United States |

2/3/2011 8:32:29 PM #

Deidra Hutchinson

Well I definitely liked reading it. This subject given by you is quite constructive for proper planning.

Deidra Hutchinson United States |

Comments are closed

Dislexia

I see people have commented about my style of writting.
Well I have dislexia so spelling is not one of my good points
but when it comes to reading/written code thats the easy bit.

 

 

Poll

What Search Engine Do you use
Show Results

Disclaimer of Liability

While every effort will be made to ensure that the information contained within this website is accurate and up to date, The Company's listed with this web site and any associated parties, make no warranty, representation or undertaking, whether expressed or implied, nor does it assume any legal liability, whether direct or indirect, or responsibility for the accuracy, completeness, or usefulness of any information.

 

Google Ads

Most comments

apply cash advance apply cash advance
1 comments
us United States
cloudy cloudy
1 comments
us United States
mutuelle mutuelle
1 comments
fr France

RecentComments

Comment RSS