• Home
 · 
• Miscellaneous
 · 
• Beginning & End of Month for Processing Dates

Beginning & End of Month for Processing Dates

Determine Beginning & End of Month for Processing

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

Rate Beginning & End of Month for Processing Dates

• 1
• 2
• 3
• 4
• 5

(2(2 Vote))

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