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])
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
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.
2 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
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