How to update the month and year ?

Apr 18 2015 7:16 AM

How to update the month and year ?

My update query is

Update tbfacilityreceiptitems set Batchno =' D001',mfgdate=10/2014,expdate=12/2020, MRP =10, sellingprice = 0.32, SaleTaxPercentage = null , SaleTaxType = 'null' where facreceiptitemid = 2763

Please help me and rearrange my update query

I am waiting for your reply....

Answers (2)

Query For Matrix Report

What is the best database to use?