Beginning & End of Month for Processing Dates

by Sean Wilkins (1 Submission)
Category: Miscellaneous
Compatability: Visual Basic 3.0
Difficulty: Advanced
Date Added: Wed 3^rd February 2021
Rating: (2 Votes)

Determine Beginning & End of Month for Processing

Inputs
Date derived from system
Code 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

Rate Beginning & End of Month for Processing Dates

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

Download this snippet Add to My Saved Code

Beginning & End of Month for Processing Dates Comments

No comments have been posted about Beginning & End of Month for Processing Dates. Why not be the first to post a comment about Beginning & End of Month for Processing Dates.

Beginning & End of Month for Processing Dates

Beginning & End of Month for Processing Dates Comments

Post your comment

Difficulty