Well, I wish it was more elegant. This is kinda clunky. I'm still open to ideas.
If Month(Me.QuarterEnd) = 3 Then
intMonthStart = 1
intYearStart = Year(Me.QuarterEnd)
dteSearchStart = DateValue(intMonthStart & "/1/" & intYearStart)
intMonthEnd = 3
intYearEnd = Year(Me.QuarterEnd)
dteSearchEnd = DateValue(intMonthEnd & "/31/" & intYearEnd)
End If
Well, I wish it was more elegant. This is kinda clunky. I'm still open to ideas.--- Synchronet 3.21d-Linux NewsLink 1.2
If Month(Me.QuarterEnd) = 3 Then
intMonthStart = 1
intYearStart = Year(Me.QuarterEnd)
dteSearchStart = DateValue(intMonthStart & "/1/" & intYearStart)
intMonthEnd = 3
intYearEnd = Year(Me.QuarterEnd)
dteSearchEnd = DateValue(intMonthEnd & "/31/" & intYearEnd)
End If
| Sysop: | Amessyroom |
|---|---|
| Location: | Fayetteville, NC |
| Users: | 76 |
| Nodes: | 6 (0 / 6) |
| Uptime: | 53:41:51 |
| Calls: | 1,265 |
| Calls today: | 1 |
| Files: | 1,362 |
| D/L today: |
3 files (2,684K bytes) |
| Messages: | 285,448 |