Hello
I need a script to calculate an expiry date using an integer and an initial date.
I have no experience with coding, but I tried the following code copied from a YouTube video;
"Private Sub date_Post_Change()
Me.date_Exp = Adddate_Exp(Me.date_Post, [login to view URL])
End Sub
Public Function Adddate_Exp(date_Post As Date, txtVal As Integer) As Date
Dim rst As Recordset
Dim db As Database
Dim date_Exp As Date
Dim icount As Integer
End Function"
I attached a screenshot image of the form showing I am getting a result in Time instead of Date.
I need the value in "Validity" to be added to the date in "Post Date" to give the Expiry Date.
Hello, dear sir!
I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality!
From the Access, of course, familiar.
Give me a chance to show what I can do!
Hi, I am a professional Access developer I have done many projects in Access have a look at my profile. I have a very good command over SQL and user interface desgin. Send me more details about the work