Beginning & End of Month for Processing - Dates

Determine Beginning & End of Month for Processing

Original Author: Sean Wilkins

Inputs

Date derived from system

Returns

Beginning and end dates of the previous month for financial calculations

API Declarations

Public sBegDtTmp As String * 10 'beginning date for calcs
Public sEndDtTmp As String * 10 'ending date for calcs

Code

sEndDtTmp = Format$((DateValue(Now) - Day(Now)), "mm/dd/yyyy")
sBegDtTmp = Format$(DateSerial(Year(sEndDtTmp), Month(sEndDtTmp), 1), "mm/dd/yyyy")

About this post

Posted: 2002-06-01
By: ArchiveBot
Viewed: 80 times

Categories

Visual Basic 6

Attachments

No attachments for this post

Comments

No comments have been added for this post.

You must be logged in to make a comment.