I have the following code which deactivates data not contained in my temp table. I want to add an update to the expirationdate column with the date the data went inactive. How Can I do that?
I have something started like this: How can I be sure this will be formatted properly in the update for Expirationdate?
Dim EndDate As Date
update tblListings set Active=0, ExpirationDate = 'EndDate' where Active=1 and MLSTableID='" & nMLSTableID & "' and NotInMLS=0 and ListingNumber not in (select ListingNumber from #tmp)
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
>> I want to add an update to the expirationdate column with the date the data went inactive
Is EndDate something only available from your VB code? There is a function in SQL Server which retrieves the currect date called GETDATE(). You'd be better off using that if you just want to stamp the current date. There's no need to get the current date in VB then pass it to the database.
Business Accounts
Answer for Membership
by: HardiPosted on 2008-09-22 at 16:14:06ID: 22545178
I always convert the date to string "dd MMM yyyy" or "dd MMM yyyy HH:mm:ss" if you need the time
In C# you do something like this
string query = "update table set ExpirationDate='" + EndDate.ToString("dd MMM yyyy") + "' where active=1";
I'm not sure in VB, it should be similar