I had a wierd issue recently when the server was restarted it went back to
1/1/2003 I replaced board battery to fix the pblm but for reporting porposes is there any way to move the sales data for what the system thinks is 1/1/2003 to 1/28/2007?you can do so by using following query: take the backup before performing the operation:
update [Transaction] set Time='2007-1-28' where year(time) 03 and month(time)=1 and day(time)=1
update Journal set Time='2007-1-28' where year(time) 03 and month(time)=1 and day(time)=1
update TransactionHold set TransactionTime='2007-1-28' where year(TransactionTime) 03 and month(TransactionTime)=1 and day(TransactionTime)=1
update VoucherEntry set [Date]='2007-1-28' where year([Date]) 03 and month([Date])=1 and day([Date])=1
with above query you will loss the time data, however if you really want I will work out on them there are couple of way to do so I just given one option to you.
"robmultil> I had a wierd issue recently when the server was restarted it went back to > 1/1/2003
Yes I mean just time HH:MM:SS for the your specific day. Also include the following table: update DailySales set [Date]='2007-1-28' where year([Date]) 03 and month([Date])=1 and day([Date])=1
Regards Akber
"robmultil>
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.