dlugirapfr
Registered User.
- Local time
- Tomorrow, 00:01
- Joined
- Nov 22, 2012
- Messages
- 68
Hello,
Last time i wrote the module to find wensday minimum two weeks later from today. It looks like this:
When i put this module in querry like this Access report error "WyznaczSrode is not defined"
Is it possible to use this module like this WyznaczSrode(Date()) ?
Thanks for answers.
Last time i wrote the module to find wensday minimum two weeks later from today. It looks like this:
Code:
Public Function WyznaczSrode(DataWystawienia As Date) As Date
Dim a As Date
Dim c As Integer
a = DataWystawienia + 14
c = Weekday(a)
Do While c <> 6
a = a + 1
c = Weekday(a)
Loop
WyznaczSrode = a + TimeSerial(10, 0, 0)
End Function
When i put this module in querry like this Access report error "WyznaczSrode is not defined"
Code:
Wyr1: WyznaczSrode([DataWystawienia])
Thanks for answers.