im making a system that will notify me when one month before its expiration. anyone can give me an idea??pls pls pls?? thanx

make proper use of datediff function

try this

x_var = DateDiff("m", dt1, dt2)
If (x_var = 1) Then
MsgBox "Product will expire after one month"
End If

is that for vb2010?? thanx

good good and good!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.