Computer Support Forum

Update Warranty based on purchase date/order receipt

Question: Update Warranty based on purchase date/order receipt

Hi, I've contacted lenovo twice now to update the warranty according to when I bought it. They haven't updated it on the website. Is there someone I can contact who can take care of this once and for all? I just need someone to update the warranty of my v570 laptop according to the retailer order receipt. I can provide all the information in a PM. Thank you.

More replies
Relevance 100%
Preferred Solution: Update Warranty based on purchase date/order receipt

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Relevance 84.87%

I purchased a product in june 2016 through best buy in june 2016, but it shows the date of warranty as Feb 2016. I verified with best buy and they also have the correct date of purchase as june 2016. How to get this verified asap? Any information will be helpful  

More replies
Relevance 82.82%

I had purchased Dell Inspiron 15 3558 laptop from authorized GTM Store on Oct, 2016. On checking warranty status, it is seen that the POW date started on August 31, 2016 which is shipping date. How could i resolve this specific issue, since all other waranties i.e, NBD, Limited Tech Support, etc are showing purchased date i.e, Oct 2016

More replies
Relevance 80.36%

Hi, I logged my ThinkPad problem with Lenovo Helpdesk and was told that my base product warranty had lapsed in Feb 2017. However, my wife reminded me that my ThinkPad was purchased in April 2016 and not Feb 2016. When I purchased my ThinkPad in April 2016, was instructed to register within 7 days for the warranty online via Lenovo website. Went through the steps and was happy that my ThinkPad's warranty was captured. However, now it seems like there is a discrepancy of 2 months for the warranty. Btw, still having the original box which my ThinkPad came with and checked the label on the box. The ThinkPad was manufactured in Feb 2016. I had called in to Lenovo today on this warranty issue and asking them to check my original registration of warranty in April 2016. What happened to the record? Also why was the Manufacturing date of the ThinkPad used for the warranty? Even if I had not registered my ThinkPad warranty when I purchased it and the systems automatically used its manufacturing date, shouldn't the Helpdesk agent advised the customer and asked for the purchased date rather than stating as a matter of fact that the systems warranty period is correct without asking the customer? Is this to reduce their liability and reduce costs at the expense of Lenovo's customers? Hence, just to share with all of you to verify your warranty instead of trusting Lenovo to capture your original warranty registration when you purchased any Lenovo product.&... Read more

More replies
Relevance 71.34%

Hello again,my parents bought a HP Elitebook in Dubai on a business trip last year.As they barely used it and swiched to Apple computers last december they gave it to me as kind of a christmas present.It works perfectly fine and there is no reason to claim warranty so far. But i asked my mother if they had the receipt and she seems to have no idea where it could be. It is not in their "receipt storage" where they usually keep all receipts for electronics and expensive stuff.Now i checked the warranty status for this notebook and it is covered under warranty till June 2018. They must have chosen the extra long warranty i guess. (?) Now i just want to find out, if there is any chance that this warranty is still "valid", if we can not find the receipt.It would be such a waste of this nice warranty. Again,.. i do not want to claim any warranty service. I hope this nice notebook will just keep running for decades, like many of our other computers are doing. This is a "just in case" question.Thanks for help in advance.

More replies
Relevance 70.11%

I have a X61 with a 3 year warranty but using the warranty lookup, it tells me it ends earlier than that. I just want to know how I would change the warranty expiration date to reflect when my product was purchased?I m in the UK.  Thanks

Answer:How to update warranty expiration date?

Thinkpads warranty starts on the day it is shipped out of factory, since most of the thinkpads are sold through Lenovo, this usually doesn't cause much problem. But for those people whom bought the laptop from computer stores, then this problem can be rectified through calling Lenovo service, and then fax a copy of the original tax invoice/receipt, and the warranty date will be updated accordingly. 

1 more replies
Relevance 69.7%

I had purcased a HP Laptop 15-AU009TX from HP World, TRICHY, Invoice no SI-T-749 on 25/07/2016 and was offered 1GB external hard disk, Head phones and extended warranty by paying additional Rs 298/- whcihg i have paid on 15/08/2016 to Razor fish gift redemtion support (ref code : 90221288) But till date i have not received External hard disk nor the head phoen which is very strange. Does it take three months for delivering the same by a reputed company as HP or is it cheting the customer. If I do not get the reply or delivery in one week I shall be taqking up the matter with the consumer forum and publish in news paper and other social media. Please do the needful at the earliest,

Answer:non receipt of free gift offered at the tie of purchase of H...

Hi @suja_1966, I have brought your issue to the attention of an appropriate team within HP. They will likely request information from you in order to look up your case details or product serial number. Please look for a private message from an identified HP contact. Additionally, keep in mind not to publicly post serial numbers and case details.If you are unfamiliar with how the Forum's private message capability works, this post has instructions.

1 more replies
Relevance 69.7%

Hi All,

I'm trying to create a Form and a Report in a Database that I've built. Ideally, what I'm trying to do is create a yearly rolling Form (for data entry) and Report (that runs off that data in the table that is updated by the form).

The table I have is essentially this:
Effort in Days August September October November December etc
Project 1 1 2 0 1 1
Project 2 2 2 2 2 2
Project 3 0 0 4 4 4

To make it easier for myself to maintain in the future, I've included fields all the way up to the end of 2018. The reports and forms are pulled from this table.

The stakeholders I've made this for want to a) be able to update projects themselves (easy enough with a form and project search) and b) have the reports on a yearly view. My current solution is to delete the forms and reports each month and then recreate them, moving the months out to the right. This has been fine up until now as it's essentially been in UAT/ proof of concept. Now we're starting to properly use this and I do not have the time to spend forever updating this every month.

The reports and forms are pulled from a query that is currently this:

SELECT RealTime.[Project Name], RealTime.[Employee Name], RealTime.PPM, RealTime.[Actual or Prospect], RealTime.[01/08/2016], RealTime.[01/09/2016], RealTime.[01/10/2016], RealTime.[01/11/2016], RealTime.[01/12/2016], RealTime.[01/01/2017], RealTime.[01/02/2017]
FROM RealTime
WHERE (((RealTime.[Actual or Prospect])="Actual"... Read more

Answer:Can you create Reports and Forms that update based on date?

Apologies - the numbers under the months didn't come through clearly. What it should be is the months as column headers and the project name and effort in days per month under each project/ month.
 

3 more replies
Relevance 69.29%

I know this is an advanced question. So I will be specific.A61 =TODAY()Now, based on date, I want to add 2.5 to the numerical value in cell B22. So, when the first of the month hits, I want the value in B22 to have 2.5 more added to it.I know it would be something like, WHEN A61 VALUE=1stOFTHEMONTH;THEN B22VALUE+2.5()I know what I want it to do, however not how to apply it. If anyone can help me out, please, and thanks for even entertaining me. Just to give more information, this is a military tracker for leaves and passes. I want it automated.

Answer:Dating formula auto cell update based on the date

Possibly a macro would even be helpful. Say, for instance, the value in B22 is 30. We all now that the next value would be 32.5. I just wan to know how to do it so I'm not number plugging for 45-60 people every month.

4 more replies
Relevance 67.65%

Hello,
Firstly, let me apologise, I'm a complete Access noob & am trying to teach myself as I've got no one to help me in person.

Ok,
I'm trying to build a Time Sheet database that should record daily duties via an entry form:
"frm_Work_Hours"

This form updates an underlying table:
"Work_Hours"

The date field of the "Work_Hours" table is:
"Date_Worked"

However, workers get paid fortnightly and all their entitlements, allowances & overtime are calculated on these fortnightly periods. To be more specific, the workers are paid for a certain amount of overtime for each fortnight upfront & when they exceed that, then they are entitled to all excess time back in TIME OFF. So it's pretty important that each day's duties are assigned to the correct fortnight period so that their overtime & so-forth are calculated correctly.

Each fortnightly period is numbered according to year. For example, each year there are 26 fortnightly periods, so as an example today (3rd October 2013) falls in period 2013-19 (23rd September 2013 to 6th October 2013).

I've created a table called:
"tbl_Pay_Period"

Which has the following Fields:
"ID" (Auto-number)
"Period_Start" (date - the first day of each new fortnight period)
"Period_Number" (number - eg: 2013-19)

Back in the "Work_Hours" table, I inserted a new (Number) FIELD called:
"Pay_Period"

and set ... Read more

Answer:Solved: MS Access - How to get a field auto-update based on date entered in a form

9 more replies
Relevance 66.83%

I've just discovered that I've lost the sales receipt for my 3 month old Lenovo Thinkpad X200, bought in May 2009 in Singapore. However, the laptop is covered under a 3 year on-site warranty and this warranty status is reflected on the Lenovo warranty lookup site.Does Lenovo require me to provide the receipt in a situation whereby I need to send my laptop in for servicing? Or would the serial number on the bottom of the laptop suffice? Thanks. 













Solved!

Go to Solution.

Answer:Lost sales receipt - is warranty still valid?

bkchng,
 
Welcome to the forum.   The warranty is based on the MT and Serial number of the system, so the receipt is generally not needed.  The only case where the receipt is needed is if the warranty start date needs to be reset because the machine sat in inventory somewhere (shelf life) before it was finally sold.  In these instances, the warranty started at the factory and the customer might have purchased a month or two later.
 
If you look up your warranty by your MT and Serial number on the support site www.lenovo.com/support
and find that the dates look right, then no worry about the receipt.
 
Best regards,
 
Mark
 
 

7 more replies
Relevance 65.6%

Why does it say that I will receive the laptop 2 weeks from now when it says that I should expect it within 1-3 days?

Answer:Dell site says XPS 15 gets delivered in 1-3 days, the order date for my order is 2 weeks from now...

Generally when that happens there has been a burst of orders, or there is a part on back order and the sales site hasn't been updated yet.  The delivery times are just estimates and could be sooner or later depending on various conditions.

1 more replies
Relevance 65.6%

Hi all,Just today I've received my newly ordered T61p. The laptop itself is perfect, no hardware/software missing, no scratches etc., in short no horror stories. However, I have two major concerns:1) The mailed package didn't contain any receipt showing what components I've ordered. There are two ziploc bags with stickers in front with a bunch of codes, but I don't know what they mean. Is this normal?2) I've ordered an extended 4 year warranty plus EasyServ, but there's no documentation in my package indicating that I've ordered that. Is this also normal?Also, just a side question:3) There are a set of 6 recovery CDs and another "set" of 1 recovery CD and a supplementary material CD that came with my order. Are these Vista or XP Pro?Thank you all very much for your help!SBC

Answer:Is there supposed to be a receipt for laptop and warranty in the mailed package? / Recovery CDs?

Welcome to the forum! It is quite normal that you wouldn't receive paperwork stating that you've upgraded the warranty, but you can check your warranty status here: http://www-307.ibm.com/pc/support/site.wss/document.do?lndocid=LOOK-WARNTY#sw At the same respect, on the bottom of the next page that will display your actual warranty status is the link that will show you all the parts originally shipped within your unit...CPU, HDD, RAM, LCD....you get the picture. Compare and make calls if something needs adjustment. As for CDs, in my experience they always have OS written on them. If your machine came with Vista preloaded, these are probably XP in case you want to downgrade, but it should be stated on them. Hope this helps.

2 more replies
Relevance 65.19%

Dell Dimensions XP PC bought 9 years ago.On opening date 7 time reverts to date of purchase.Can change and all ok.Can anyone Help Please? Thank you

Answer:Date & Time reverts to Date of PC purchase 9 Years Ago

Wait for the more knowledgeable to report but a new CMOS Battery would seem to be in order.
Easy to replace and only £1, or so, to buy, in almost any Supermarket.
About the size of a 10p piece on the motherboard, with a number like CM032. Don't take it out until you are ready to replace it.
Get the replacement > Take the old one out > Instal the new one and, with luck, that should be it.

6 more replies
Relevance 65.19%

Dell Dimensions XP PC bought 9 years ago.On opening date 7 time reverts to date of purchase.Can change and all ok.Can anyone Help Please? Thank you

Answer:Date & Time reverts to Date of PC purchase 9 Years Ago

http://www.pcadvisor.co.uk/forums/1/tech-helproom/4204823/date-amp-time-reverts-to-date-of-pc-purchase-9-years-ago/
see duplicate thread

1 more replies
Relevance 64.37%

Hi all,I wish to create a macro that when i click a button i can input what month i wish to print out data for. I have 7 columns (A-G).Date Day Activity Income 02/01/2012 Monday Work (8) £48.00 02/01/2012 HMOT £5.00 02/01/2012 Peter Taylor 134024855 HMOT £5.00 02/01/2012 Susan Taylor 134023422 HMOT £5.00 02/01/2012 Steve Davy 13402737404/01/2012 Wednesday Work (8) £48.00 04/01/2012 HMOT £5.00 04/01/2012 Tom Thompson 134027410 HMOT £5.00 04/01/2012 John Ackroyd 134025131 HMOT £5.00 04/01/2012 Aftab Ilahi 134022546Above is an example of the sheet.In column A we have the date, B we have the day, C we have the activity, D we have the income, E is a cell with the previous month date in to track data for the month, F is a name and G is a number.I wish to be able to print all of january for example, rows A-G by clicking a button and entering something like 'january' or '01/12'. This will then select all of the rows with data in based on the date range in column A and print the selection.Please feel free if that doesn't make sense to ask questions.Thanks in advance.

Answer:acro to input date and print based on date range

Below is the code I have for a macro which I can't seem to get to work right.Thanks.
Public Sub PrintMonth()
On Error GoTo Proc_Error

Dim wksCurr As Worksheet
Dim rngTarget As Range

Dim strInput As String
Dim datInput As Date
Dim datStart As Date
Dim datEnd As Date

strInput = InputBox("input start date for month", "Enter date")
If strInput > "" Then
datInput = CDate(strInput)
If datInput > 0 Then
Set wksCurr = ActiveSheet
Set rngTarget = wksCurr.Columns(4)
datStart = WorksheetFunction.EoMonth(datInput, -1) + 1
datEnd = WorksheetFunction.EoMonth(datInput, 0) + 1
With wksCurr
If .AutoFilterMode Then
.AutoFilterMode = False
End If
.UsedRange.AutoFilter Field:=rngTarget.Column, Criteria1:=">=" & datStart, _
Operator:=xlAnd, Criteria2:="<" & datEnd
.PrintOut
.AutoFilterMode = False
End With

Set rngTarget = Nothing
Set rngDate = Nothing
Set wksCurr = Nothing
End If
End If

Proc_Exit:

Exit Sub

Proc_Error:

Select Case Err
Case Else
MsgBox "Error " & CStr(Err) & ": " & Err.Description
Resume Proc_Exit
End Select

Exit Sub

End Sub

3 more replies
Relevance 64.37%

I need to return a number associated with a date based on today's date. For example: A1:A24 are numbers 1 to 24 and B1:B24 contain the 15th and 30th for each month of the year; 15-Jan, 30-Jan, 15-Feb, 28-Feb, ... 30-Dec.Cell C1 needs to return the number from A1:A24 based upon today's date compared to the date in B1:B24.For example today is 08/21/15, what number should be returned in Cell C1. It should be 15 as 08/21 is less than 30-Aug.message edited by jmichels

Answer:Return a number based on today's date compared another date.

Try this formula, see how it work for you:=INDEX(A1:B24,MATCH(TODAY(),B1:B24,1),1)This will work for most dates, but errors out if the Date is 01/14/15 or less.MIKEhttp://www.skeptic.com/message edited by mmcconaghy

4 more replies
Relevance 63.96%

It looks like the 31 March deadline for the latest Edge promotions is the date of invoice rather than the date of order. Given Lenovo's reported long build time and slow delivery (= late invoice), I suspect that ording now from the Lenovo web site will see an invoice date outside the qualifying period. Even a dealer who says he can 'get one in' may not deliver and invoice until April or beyond. I think the only option is to find a dealer who unequivocally has current stock.Can anyone shed any light on the likely position. I do, though, wonder about trying to take advantage of Lenovo Cashback at all, given the horror stories reported here.

Answer:Edge 31 March promotion deadline - order date or invoice date?

My experience with cashback is a deathly silence from Lenovo to emails asking for progress on the cash or even recognition that there has been a registration for cashback...Currently considering giving Lenovo some publicity on the matter.Unless you have a lot of time to possibly get no where I would steer clear of the alleged cashback scheme...

1 more replies
Relevance 63.96%

My warranty expired a little over a year ago.  My situation is that my system won't start up (1 long beep, 2 short beeps, blank screen), and I have already determined that I will need a new system board.  The price for this is $475, and it is only guaranteed for 30 days labor, and 90 days for the part. I was told that I could possibly get a new 1 year warranty for around $150 which takes a few weeks to activate, but still seems like a great deal.  Is this true, and will it cover the system board that malfunctioned while not under warranty?

Answer:Purchase a warranty for an out-of-warranty T61p

Hi gpig,Why don't you give them a call and verify it yourself?United States1-866-426-0005Hours of operation:M-F: 9:00 AM to 7:00 PM ESTSat and Sun: ClosedNote: All times are for the Eastern Time Zone.For expired warranty service, lenovo page says this:- http://www-307.ibm.com/pc/support/site.wss/THNK-PLUS.html#maHope it helps.





------------------------------------------------------------Maliha (I don't work for lenovo)ThinkPads:- T400[Win 7], T60[Win 7], IBM 240[Win XP]IdeaPad: U350Apple:- Macbook Air [Snow Leopard]Did someone help you today? Compliment them with a Kudos!Was your question answered today? Mark it as an Accepted Solution!   Lenovo Deutsche Community     Lenovo Comunidad en Español Visit my YouTube Channel

3 more replies
Relevance 60.27%

The small company that I work for is coming to the end of its Purchase Order pads and as the person responsible for this area of the business I was wondering if there was any software available that would enable me to deal with Purchase Orders on my PC (i.e enter data and print them). I think Sage does it but I don't want a whole accounting programme. Anyone any ideas?

Answer:Purchase Order Software

Whats wrong with a form templet, check on the MS site if you us Word I have some but they are for WordPerfect 8

10 more replies
Relevance 59.45%

Hi,
can someone please tell me where is the "comments" field is pulling information from on a Purchase order confirmation journal in AX 2012?
When I print the preview of the journal there is a comment section on the bottom with 3 free lines but I am not sure if I could add the comment in AX or phisically with a pen.
Thanks,
Orsi

More replies
Relevance 59.45%

I have placed an order through my corporate site. I have been trying to contact Lenovo UK sales and every time I call I was forwarded to sales team who never answers the phone. I waited 30min on thursday and 20 min today and still no response. Not a good start. I am wondering what would it be like if I have got an issue with the machine.

Answer:Sales - Enquiry about Purchase Order

Hi and welcome to the forum!What number are you calling and at what times? AFAIK, the sales and support are different departments and have different contact numbers, further lenovo sells the products and IBM provides the support.Try contacting them on the given number here:- http://www.lenovo.com/contact/uk/en/Keep us posted.





------------------------------------------------------------Maliha (I don't work for lenovo)ThinkPads:- T400[Win 7], T60[Win 7], IBM 240[Win XP]IdeaPad: U350Apple:- Macbook Air [Snow Leopard]Did someone help you today? Compliment them with a Kudos!Was your question answered today? Mark it as an Accepted Solution!   Lenovo Deutsche Community     Lenovo Comunidad en Español Visit my YouTube Channel

1 more replies
Relevance 59.45%

I bought a Dell Laptop on 14 October 2017. Its service tag is <Service tag removed>. But the following message is showing in Dell website with a shipping date of 14 Sept. Can anybody rectify this warranty wrong information? I bought it in Singapore. Please help me immediately.

Answer:Warranty started before my purchase

Mine shows that as well.  I bought it in early October 2016 at a Best Buy in the US.  The screen just started messing up with mine at the end of October 2017.  Dell shows the warranty started some time in either August or September if I remember correctly.  Either way I was just outside of the warranty window when my issue arised.  

2 more replies
Relevance 59.45%

I purchased a Yoga 720 15" 2in1 three weeks ago and I am trying to decide if, when, and the type of warranty extentions I should get.I can add the " products " to the cart but I can not find the small print anywhere.  IF I decide to get additional coverage I would likely go for the maximum available but I want to know what the coverage is prior to purchasing it. I have two options available in addition to the levono warranty and  want to choose wisely.As it is I have over 11 months* remaining on the warranty but I think adding accidental coverage and on site service may be a good investment because I will be traveling with this laptop and I might be at the other side of the country if it breaks.I would appreciate advice on this topic. * I purchased it on 7/3/2017 and the start date for my warranty shows as 6/22/2017. Not sure what that is all about.

More replies
Relevance 59.45%

Hello,I've noticed athttp://support.lenovo.com/it/it/warrantylookupthat 3-years warranty started before I purchased my X1 Carbon .It probably started from the date it was manufactured, but I bought it a year later and I don't want to lose 1 year of warranty. How can I rectify the date?  PSI can still print a pdf receipt from online store where I bought it, is it enough?

Answer:Warranty started before purchase

Hello and welcome, MichaelVaughnTo update the warranty data contact your local Lenovo authorised service provider (though, I don't see those companies list in Italy in the on-line locator) or request online:http://lenovoemea.force.com/warranty?lang=enChoose "Base warranty cange / Purchase date update" item.FYI, this page might help to find the service company:https://support.lenovo.com/uu/en/iwslookupthink?linkTrack=MastubNavupport:Warranty%20and%20Repair:Wa...

1 more replies
Relevance 58.63%

Hi, I am trying to purchase warranty extension from shop.thinkpad.com. But however I try, it says "Cannot order cart that contains invalid items." while I purchase the 2yr base warranty extension. Anybody successed with it? (If this post should go to some other area please kindly move it, thanks!)

Answer:How do I purchase warranty extension for my X220?

did you buy the item in the states?

4 more replies
Relevance 58.63%

I ordered a X61 and it just arrived.  I logged in to check the warranty status of it, to make sure it was correct and 3 years.  And it has it expring after one year. The invoice has my 3 year depot plan.  What do I have to do to get this updated, I sent 2 emails so far with no response. Thanks

Answer:Warranty Info is wrong on new purchase

Warranty extensions need a bit of time to work their way through the system, usually 4/5 working days. Have a look online in a week and if it's still wrong; call and ask the question.Worst case; as you have an invoice as confirmation you can always refuse payment.

2 more replies
Relevance 58.63%

I have purchased one Dell Vostro 3546 series laptop 2 days back i.e 4th June 2015. When I checked the Warranty details for my laptop (tag <ADMIN NOTE: Service tag removed per privacy policy>) it shows that the warranty will expire on 24-Dec-15 which is less than 6 months whereas the Dell provides the 15 months warranty for this laptop.
It shows that the product is shipped on 24-Sep-14 and thus the warranty will expire on 24-Dec-15 but how come the warranty will expire when the product was not at all purchased by customer.
I have purchased this laptop from authorized dealer under the bill from Nehru Place and request you to please let me know the solution for my problem.
Thanks
Prateek

Answer:Dell Warranty less than 6 months on new Purchase

You need to register the system with Dell (transfer ownership to your name) to initialize the warranty.
<<www.dell.com/support/retail/us/en/19/>>
Use the system service tag and the link above.

4 more replies
Relevance 58.63%

Hello, I recently purchased Lenovo Flex 5 (14") laptop (Part Number:  80XA0011US). This comes with 16.0GB DDR4 2133 MHz and 1TB 5400 RPM+128GB PCIe SSD.  I have 3 questions: 1) I am hoping I like the laptop. If for some reason, I want to return it, how many days I have? And, is that from the date of purchase or date of delivery?  2) I forgot to buy warranty with the purchase. How many days I have to buy warranty?  3) I bought accessory - Slim DVD Burner. Will this be attached to the laptop or is this an external one? Thanks!  

More replies
Relevance 58.63%

Hello everyone. I'm thinking of purchasing a T470 and it appears that it comes with a 3 year onsite warranty as standard here in the UK (with the student discount anyway). My main question is that will I be able to make warranty claims even if I'm not in the UK? I'm going to be going to China in August and I'll be there for a good 10 months (maybe more) so I want to know if I'll be able to make warranty claims there. Going along with that, if I am able to make warranty claims in China, will I have to make the claim in Chinese to Lenovo China, and what is the chance that the technician speaks English (especially in a second tier city)? I'd say my Mandarin is "OK" at the moment but I know very few computer related terms. I think I could just about get by with what I know and the dictionary app on my phone, a roommate helping, or someone in the International Students office helping over the phone, but I'd feel much better having making the claim and talking to the technician in English if possible. Finally, I'll probably buy some RAM and a SSD from Amazon if the price is significantly cheaper than Lenovo. Will I have any problems with this if I need to make a warranty claim? Thanks in advance!

More replies
Relevance 58.63%

Experts: I am looking for a certain config in an X220 that on the Lenovo site has a ship date of 12/26. I don't want to wait that long but do want to have an option to purchase a 4 year NBD on site warranty and TPP for accidental damage. Is this possible through Lenovo for a non-Lenovo purchase (ie tigerdirect)? Are other warranties better (ie square trade, etc)? Many thanks













Solved!

Go to Solution.

Answer:X220 Warranty and TPP after Tigerdirect purchase

Any help appreciated on this warranty issue. Also, can the internal SSD in an X220 be removed and placed in the WWLAN mSATA bay or does the mSATA SSD that goes in there have to be a different one?

8 more replies
Relevance 58.63%

I bought a Dell Inspiron 15 5567 on 2/01/2017 from Reliance Digital Store Pune. Dell support assist shows that my warranty started on 14/09/2016 and will end on 14/09/2017. As far as I know warranty should start from the date of purchase on the invoice. So I searched a little bit and got to know about the ownership transfer process. I did that 15 days ago but still haven't received any notification regarding the same. Can you guys please help regarding this process. I don't know what to do now as my warranty will end in 12 days.

Answer:Dell warranty only for 9 months on new purchase

If the ownership transfer doesn't go through, contact the seller to find out why - if the system was originally sold through a grey market channel, you can indeed have transfer issues - your seller should be able to tell you.

2 more replies
Relevance 58.22%

Hi

I am looking to creat a simple system to create and track purchase orders mainly for internal puposes.

We are a small UK based building company and order a lot of stuff and its hard keeoing track.

Any ideas how to do so would be good, complete beginner/

Many thanks
 

More replies
Relevance 58.22%

Hi,

I tried checking other posts to see if there is anything i could use but unfortunately i couldnt find one.

Here is my need: I am working on a project in which we have many vendors. We issue Purchase orders to these vendors and in turn receive invoices from them so we can make the payments. I am not good with access at all hence decided to go with Excel (i am not good with Excel macro either). I am attaching a sample data sheet here for easy understanding. Input sheets are PO and Inv. So i'll be adding the information to these two tabs and need a macro which will update the respective vendor tab copying the data from PO and Invoice tabs. There could be multiple invoices to one PO too. I need your help with a macro. I can copy and paste the code but i cannot build one . Additionally Is it possible in Inv tab to highlight the invoice or PO cell if there is no balance to PO?

Sorry to be a pain like this but i am sure i can look at you experts for help on Excel.

Thanks in advance,

Vishal
 

Answer:Solved: Need help to setup a purchase order and invoice register

16 more replies
Relevance 58.22%
Question: Purchase Date

Hello When i look up My notebooks serial number on acer customer self service, it gives u a "purchase date" what does This actually mean?













Solved!

Go to Solution.

Answer:Purchase Date

Not the case, if the unit is not registered, then the Date you see there would be the date of manufacture, that should not be a problem, you may register the unit @ acersupport.com

5 more replies
Relevance 58.22%

Can anyone tell me how I can find out if a US purchased machine is covered by the International Warranty Service (IWS) for my country (Japan) BEFORE I purchase it.  I cannot find this information on the site as it asks for a machine code or some such from the actual device. The only reason I posted here is because I am considering an X Series TP (but am also considering a Yoga 3). Although I have been a TP owner for nearly 20 years, for this potential purchase it's a total deal breaker for me if IWS is absent. 

Answer:How to find out International Warranty Service (IWS) BEFORE purchase?

Hi MarkA,
 
Welcome to Lenovo Community!
 
As per the query we understood that you are looking on how to check IWS for ThinkPad X series and Yoga 3.
 
For Ideapad Yoga 3 you can directly check the IWS warranty, but for ThinkPad you have to check with MTM (Machine Type Model) number, can you please let us know which model of X series you are looking for?
 
Hope this helps.
 
Best regards,
Hemanth Kumar





Did someone help you today? Press the star on the left to thank them with a Kudo!If you find a post helpful and it answers your question, please mark it as an "Accepted Solution"! This will help the rest of the Community with similar issues identify the verified solution and benefit from it.Follow @LenovoForums on Twitter!

3 more replies
Relevance 58.22%

Hi,I'm looking at purchasing the X220 and was wondering if it is cheaper to get the warranty upgrade at time of purchase? Or is it the same price if I purchase anytime within the first 12 months?  I can't find any info on the Lenovo site without having a model and serial number.Thanks,Dan

Answer:Is the warranty upgrade cheaper at time of purchase?

yes it will be, as the warranty purchase would enjoy the additional xx% discount that Lenovo usually put out for their laptop sales event, which is not available after your purchase of the laptop.Lenovo want to encourage the purchasing of extended warranty with their initial laptop purchase, as it will save their backoffice workload and at the same time generate more revenue.

1 more replies
Relevance 58.22%

I received my new SL510 on September 21, 2010 which I had ordered.When I purchased the SL510 I also purchased the 3 Year Warranty Upgrade.Iv'e registered the unit on-line at the Lenovo web page (which wasn't easy to find) and the standard one year warranty still lists as expiring on 06-25-2011.I don't understand why I am only getting 9 months warranty, especially since I paid over $300 for the warranty upgrade. 

Answer:SL510 Warranty not showing properly on my new purchase

Hi and welcome to the forum!See this thread:- http://forums.lenovo.com/t5/General-Discussion/Extended-Warranty-information/td-p/285252Hope it helps.





------------------------------------------------------------Maliha (I don't work for lenovo)ThinkPads:- T400[Win 7], T60[Win 7], IBM 240[Win XP]IdeaPad: U350Apple:- Macbook Air [Snow Leopard]Did someone help you today? Compliment them with a Kudos!Was your question answered today? Mark it as an Accepted Solution!   Lenovo Deutsche Community     Lenovo Comunidad en Español Visit my YouTube Channel

3 more replies
Relevance 58.22%

My delete key had been wobbly and has now fallen off completely.  Warranty expires in mid-June.  I am travelling in Sweden until July, so warranty will have expired by the time I get back to Canada. 1. Can I get the laptop repaired here in Sweden using my HP warranty?2. If not, since I am reporting the problem before the warranty expires, can I get it repaired in July, after the warranty has technically expired?Thanks.

More replies
Relevance 58.22%

how to purchase extended warranty online for my laptop

Answer:how to purchase extended warranty online for my laptop

Called Care Packs..sold online through this site: http://store.hp.com/us/en/care-packs-88343--1?jumpid=home_hsa_na_1_161016 There are limits as to the age of the laptop, etc. but if you are still within the original warranty or even slightly beyond it you are eligible to buy extended protection.  If this is "the Answer" please click "Accept as Solution" to help others find it. 

1 more replies
Relevance 57.81%

I've just installed I.E.8 and since doing so I've been unable to complete a product selection process prior to purchase.
The web site involved is www.saxoprint.co.uk which is a really good place to order bespoke printed materials. The order process is easy and swift when using I.E. 7, but has, thus far, been impossible since "upgrading" to I.E.8!
I don't know what settings I.E.8 has put in place that prevents the order process.
Can anyone can help?
Cheers
Tim

My operating system: Windows XPpro SP3
my PC: intel E8400 processor, Gigabyte P35 chipset, 4Gb RAM
 

Answer:Solved: Internet Explorer 8 prevents purchase order processing.

Have you tried running it in Compatibility Mode?
To turn it on click the torn page button next to your address bar.
Some pages aren't made for IE8 and need to be run that way.
 

3 more replies
Relevance 57.81%

I have had my laptop for several years now and I no longer have the box/reciept/proof of purchase. I am involved in a class action suit and my laptop is eligible for a replacement, but the claims form is asking for some sort of proof of purchase. On the site for the class action lawsuit I read this: "Required documentation is a form of proof of purchase, which shows the date that you purchased your notebook computer. Proof of purchase can be a sales receipt, credit card or other account statement, shipping manifest, purchase order, proof of registration, or such other documentation that the Administrator deems sufficiently reliable to demonstrate that one of the specified models was purchased in the specified purchase date range, along with the product identification number found on the back of your notebook computer and the date of when the notebook computer was purchased." I am wondering if there is any way to find out when I registered my product, because I am almost 100% sure I would have done that the moment I turned it on. Thanks for your time.

Answer:Purchase/Registration Date

Anyone have any ideas where I could locate this information?

5 more replies
Relevance 57.81%

I want to know the Purchase/Invoice date of my laptop and Serial number is (Personal information removed)

Answer:Purchase Date of Laptop

Dear Customer,Welcome and Thank you for posting your query on HP Support ForumIt looks like you are trying find the invoice for your Notebook. We will surely assist you with this issueThis is to inform you that HP would not have any records if you have purchased the Notebook from a reseller or distributor or stockist. I would say you can directly contact the point of purchase and request for the bill/invoiceIf you have purchased the Notebook directly from HP, then there might be chance that we can help you. Just to let you know most of the times HP database would show the manufacturing date instead purchase date, which is why we request withCustomers to send us a soft copy of the bill/invoice.Please call up HP Sales Support over the Phone and request for the duplicate copy of your bill/invoice.If you are lucky enough you might get support from them.Hope this helps, for any further queries reply to the post and feel free to join us again**Click the 'Thumbs Up Button' to say Thanks**Make it easier for other people to find solutions by marking a Reply 'Accept as Solution' if it solves your problem.Thank You,K N R KAlthough I am an HP employee, I am speaking for myself and not for HP

3 more replies
Relevance 57.4%

Hello, I've always been a Thinkpad lover and currently have a T450s. I have posted about the poor customer service I have received once before, but it's gotten to a point where I can no longer justify the purchase or recommendation of Lenovo products. I would like to warn anyone thinking about buying a Thinkpad to do so knowing they will receive what is possibly the worst customer service I have ever had with any form of electronics. My computer has been sent back several times, the last I was told I would get a new computer by email and got a hard no by telephone. I paid up for the best warranty I could and am sending it back a fourth time. I didn't even receive same day shipping. UPS told me I had to pay extra with my own credit card. I don't think the company cares one way or the other how current customers are dealt with and it is apparent that there is some kind of miscommunication between departments. No one should have a high end computer break four times without receiving a new machine or at least better service and response. You end up without a computer for days and worhtless promises. Sorry if this sounds like a rant, but I wanted to make clear just how terrible my experience has been because it's information that would have changed my mind if I was looking at several different machines before purchase. Thanks

More replies
Relevance 57.4%

Is there a way in Outlook 2003 to check if an item was received or read if the user didn't request a read receipt to begin with?
 

Answer:Outlook-check receipt if receipt not requested?

anyone?
 

2 more replies
Relevance 56.58%

Can anyone let me know if any software exists, that will allow me to get notification that email I send from AOL, has been read by the recipient please?

Answer:Receipt for email sent from AOL to web based email

Aol will notify receipt of mail by other Aol members. This is a programmable option, though i can't find it at the moment!I doubt if any software exists which will show that a particular email has been opened whatever the ISP or whoever receives it. (Except for dialler viruses and malware)In a negative sort of way the obvious comment arrives when the email is not deliverable because of "Fatal" errors in the address.

1 more replies
Relevance 56.58%

I guess this isn't a Yoga-specific question but wasn't sure where to put it. I'm ordering a replacement AC adapter for my Yoga 3 Pro on the lenovo.encompass.com site. But there's nowhere to enter the serial number so I can order it under warranty. I get to the purchase screen and it's going to charge me full price. I've entered my warranty info on the main support site, but when I get to the parts site it doesn't recognize that. Basically, how do I order the part under warranty without having to pay for it?

More replies
Relevance 56.58%

Hi, first time posted but a long time reader! I have placed an order for my W530 last week and it is scheduled to be delivered next Tuesday. Instead of selecting Onsite 4yr warranty + 4yr Thinkpad Protection I have selected Depot 4yr warranty + Thinkpad Protection. Called Lenovo today and was told by a rep that I have to return laptop back to Lenovo and pay 15% restocking fees and then place another order to change warranty. That is absurd! I have used the serial number sent to me by email to check warranty upgrade availability online and website says that no upgrades are avilable. I really wish I had made a proper selection during my order. Help! How do I upgrade without returning my first lenovo laptop that I had been researching for 6 months and which have not even received yet

More replies
Relevance 56.58%

For MS Access
is there a function that exists or can someone build me one, so that i can assign an incremental number to a record based on the order that the records are sorted. such that the 1st record would be 1, 2nd=2, 3rd=3, etc.
 

More replies
Relevance 56.58%

3 fields= Order #, Date Required, Part #

I'm looking to create a value based on the location of a record within in a list.

For example, if I sort by part then by date I want to return the value of where that record falls in the sort order. Basically show where it falls in terms of priority.

To say it a different way...if an order is required by x date and there are 3 orders for the same part required at an earlier date I want to return the value "4".

I'm very familiar with Access, but this scenario is new to me. Any ideas appreciated...thanks in advance.
 

Answer:Solved: Access: Assign value based on sort order

14 more replies
Relevance 56.58%
Relevance 56.58%
Answer:Notepad F5 gives time then date, need to reverse order, to date then time

I believe the answer is available at https://www.experts-exchange.com/questions/20430625/Windows-Notepad-exe-change-F5-date-format.html

3 more replies
Relevance 56.17%

Hi, some of my Acer Aspire v5-571PG stopped working. Went online to: Fix My Acer, to get service, I did input the correct serial etc but the purchase date is grayed out and cannot be changed ( it says below change if date is different ), Tried different browsers, allowed pop ups etc with no joy. The date is stucked on 30/10/2013, the purchase date (with receipt and registered on site when bought)is 19/02/2014.Please help

Answer:Fix My Acer to get service has purchase date graye...

Hi,Sorry that you are unable to change the Date of Purchase, You could still contact Acer support ny chat or phone. Acer could help you to get the DOP updated & also for service,. Cheers

3 more replies
Relevance 56.17%

System says I am out of warranty and has a date of 9/29/15 but my receipt shows purchase 10/20/2015. Cannot reach a live person. Any number or email to reach a live person for support if system thinks I am out of warranty? Jen

More replies
Relevance 56.17%

I've got a Toshiba Satellite M645-S4070 that i bought at around February this year. I've been getting BSOD's about once a month, sometimes randomly when it's idle, sometimes when i'm browsing. I have upgraded the ram to 8Gb Corsair because of the work I do on it. I ran memtest and nothing is wrong with the ram. Avira antivirus is up to date, scanned, laptop is clean. I've recently bought an M-Audio Fast Track Pro. Everything else is untouched.

-Windows 7 Home Premium 64-bit
-This is the original OS installed on this laptop, never formatted or system restored.
-Original Retail version
-Age: About 8 months
-Cpu: Intel Core i5 M460 @2.53GHz
-Video Card: Intel HD Graphics
-Motherboard: Toshiba NBQAA? (its a laptop)
-Manufacturer: Toshiba
-Model Number: Satellite M645-S4070

I really hope someone can find something because its getting kind of annoying that at any time this laptop can crash while I'm working on something important. Thank you.

Answer:Frequent BSOD's with new laptop since date of purchase

I just did the driver verifier tutorial and my laptop BSOD, I've attached the minidump files.

6 more replies
Relevance 56.17%

System says I am out of warranty and has a date of 9/29/15 but my receipt shows purchase 10/20/2015. Cannot reach a live person. Any number or email to reach a live person for support if system thinks I am out of warranty? Jen













Solved!

Go to Solution.

Answer:10/20/2015 purchase date system says out of warran...

You cannot chat or speak on the phone with an Acer support professional if your SNID is mistakenly listed as "out of warranty". You can only be sent to a 3rd party who will help you for a fee. (extremely frustrating) After several tries, I finally found someone with the 3rd party provider who knew how to fix the "out of warranty" status. The first few attempts I was told they couldn't help me with the inaccurate warranty status because they don't work for Acer. You have to go to the following site to upload your proof of purchase: http://csapps.acer.com/pop

4 more replies
Relevance 56.17%

The extended warranty that Lenovo sells you when you purchase your system is a scam.
 
I purchased an X200 tablet about a year and a half ago with the extended warranty.  My computer began having issues about halfway into the warranty.  I then called Lenovo support for this problem covered under the extended warranty. They will immediately send out a box and a label to send the system back for a promised repair.  Then about a week later they will call you and tell you that your computer has far more damage than it really had when you shipped it to them (a cracked screen and some other item in my case!) and then try to get you to pay for them to even repair anything wrong with the computer.
 
Lenovo has no issue with lying by saying that the customer was the one responsible for the problem.  I can only advise anyone considering purchasing a Lenovo system to choose a different manufacturer.  
 
 
 
Moderator note; please do not post the same post in different boards; it splits the conversation - Duplicates removed
 
Admin edit - removed content which is against community rules of participation.

Answer:Don't purchase any product from Lenovo if you expect your warranty to count! (BAIT and SWITCH!)

I had to deal with poor technical support from Lenovo earlier, however, once the issue was raised to customer complaint resolutions, they were actually quite helpful. Try contacting Mark_Lenovo on the forums. He is really helpful.

3 more replies
Relevance 55.76%

hii David pkMy laptop is naw 4 year old naw can order recovery disc for my laptopBcoz my graphics driver are gone due to my hard drive changed...will hp company give me recovery disc or not..if not then haw can i get back my graphics card driver back..is there any other way?? Plz sir hlp me out

Answer:haw to order recovery disc if my laptop is out of warranty

HP are unlikely to provide recovery discs free of charge, which country are you in?




*****I do not work for HP**********click the purple thumbs up button to say thanks**********If I solved your problem, help others by clicking accept as solution*****

1 more replies
Relevance 55.76%

Basically I want to pull the correct date that is associated with a job number from one tab into another.Column H on tab A references the job number.Row 3 on tab B contains the job numbersRow 5 on tab B contains the datesI want the returned date to show in column F on tab AI need to match the job numbers to return the correct date.I know that SUMIF should work, but it returns 1/0/1900. Is the sheet corrupt perhaps? Changing the formatting of the field doesn't do nothing.I am stuck now.Thanks a bunch!

Answer:How to look up a date from another tab based on a condition

I'm not sure why you think SUMIF should work. SUMIF is used to SUM the values in a range that meet criteria that you specify, as explained here:https://support.office.com/en-us/ar...In your case, it sounds like HLOOKUP is the proper function. Something like this should work:=HLOOKUP(A!H5,B!$C$3:$I$5,3,0)Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

4 more replies
Relevance 55.76%

On one worksheet (A) I have dates for all of March. The worksheet pulls up dollar amounts earned for each job. I have multiple jobs on the same day. So, on 04/01 I have three different jobs with three different dollar amounts. On the second worksheet (B) I want to have one line for each date. I want the cell to look up the date and then add all the values for that date into the one cell automatically.

Answer:Sum Values Based on Date

re: I want the cell to look up the date and then add all the values for that date into the one cell automatically.We all have wants.Since we are all volunteers here, giving up our free time to help others, how about asking nicely for help instead of just telling us what you want?

5 more replies
Relevance 55.76%

Sorry if this has already been posted but I could not find in any searches.  I realize it may be too early to ask but does anyone have any idea when Microsoft will provide a free upgrade to version 10 when 8.1 is purchased?
 
Thanks!!

Answer:Date for 8.1 purchase that will provide free upgrade to Windows 10

...when Microsoft will provide a free upgrade to version 10 when 8.1 is purchased?
 
Thanks!!
That's just a rumor as far as I know and pie in the sky.

4 more replies
Relevance 55.76%

HiThe fan of my less-than-half-a-year-old T470 suddenly began to emit strange noise and I went to a local service provider in CA. My laptop was bought in Russia with a 3-year international warranty. The service provider told me that he might have to send it back to Russia, and they will consult with Lenovo within a week. That is a huge surprise for me, as shipping it back and forth might take a long time. Can I somehow request to repair my laptop inside the US and is there any opportunity to claim a temporary replacement for the time the laptop is being repaired?Thanks

More replies
Relevance 55.35%

usually the message is first,then the date it was sent to me, and then the time of day.Lately the messages are received in a random order and is time consuming to find the latest message. I have windows xp, explorer 7 and outlook express

Answer:why are my emails not in order by date in out

willbeau,Open your Inbox and under the Inbox/Main Identity bar just click on the word "Received". This will toggle the message dates.Tufenuf

2 more replies
Relevance 55.35%

Hi I have the following issue:

I want to watch my photos in chronological order without gap. But there is one of the images that is not
putting itself in the right place...using "ORDER BY NAME " . Eventhough the name seem all to be in the right order ... could you let me know what could be wrong ? Here is the screen shoot..thanks Kevin

http://imageworm.com/?v=gbpusd201105030730problem.png
 

Answer:Solved: order of date

Look at the file names, the one after the problem one is named "GPBU" and the ones above it are named "GBPU".

They are in the correct order based on the file names.
 

3 more replies
Relevance 55.35%

Dear Support team, I can't find MA that we just order on year 2007 and 2008 , so please help to check warranty detailfor Lenovo product that I order by Thinkpad R60 :April ,2007  : S/N# L3xxxxx  M/T# 9445-A17 August , 2007 : S/N# L3xxxxx , L3, L3xxxxx, L3xxxxx, L3xxxxx, L3xxxxx                          M/T# 9445-A17 Thinkpad X61s :April ,2008 : S/N# L3xxxxxx M/T# 7671-A51 Regards. Moderator Note; s/numbers edited for members own protectionMessage Edited by andyP on 08-19-2008 08:56 AM

Answer:Please help to check warranty for order on year 2007 & 2008

jiraporns, welcome to the forum, What do you mean by MA?If you want to check warranty status on Lenovo systems you can do the on this site

1 more replies
Relevance 55.35%

Subject Pavilion Elite HPE-450t,   Model XM556AV. S/N 2MD04414TGi need a set of recovery disks for this desktop.   I believe the software had been damaged by a rootkit bug (Thanks Kids).Malwarebytes has helped but the PC does not update at all.  I suspect the damage prevents any diagnostic repairs, so I'm assuming a recovery is needed.  I tried the steps in HP support but the software never gives me the option of (System Recovery).  I see 2 options (1) try disk recovery; or (2) replace the hard drive completely with a formatted new hard disk. Please help me with both option. Leon R. 

Answer:Need to order HP recovery discs for desktop past warranty da...

LROSZKOW Unfortunately, there is no HP Recovery Media linked to the HP Product Page for your PC. This could be an oversight by HP, or it could also mean that HP no longer stocks the recovery media for your PC. They no long stock recovery media for the older PCs.You can try contacting HP Customer Support directly, using the links below, to see if you can order if from them: HP Recovery Media is a set of DVDs and a CD, or USB stick, that will erase the hard drive (removing all data, settings, and applications, reinstall the original OS, drivers, and some HP Utilities. In some cases, you may be able to order a USB stick instead of disks. You have to order these from HP; they can not be downloaded.You can look online for Recovery Media starting with the linked paged: http://support.hp.com/us-en/driversOnce there, input your Product name or number. On your Software and Drivers Download page, select your Operating System and and Version. Click "Update". If HP Recovery Media is available for your machine, down near the bottom of the page, you will see an entry for Order Recovery Media-CD/DVD/USB. Click the "+" symbol to expand that entry and click on Order Media for details.Or, if you prefer, you can do the same by contacting HP Customer Service:If you live in the US or Canada, contact information is on this page: http://www8.hp.com/us/en/contact-hp/phone-assist.html#section1If you live elsewhere, contact information is on this page: http://www8.hp.com/us/en/contact-hp/ww-... Read more

1 more replies
Relevance 55.35%

I hae a vehicle mileage log that I track my business miles in. A1 has the date, B1 has the customer name, C1 has beginning mileage, D1 has the ending mileage, E1 has total mileage for customer. What I want is at the end of the day, based on the date in A1, is a formula that will total all the miles and then put that total in Column F on the same line as the last entry for that day.....I hope this wasn't to confusing...Thanks in advance.

Answer:I want to total mileage based on date

Is the date in A1 repeated in A2, A3, A4, etc. until it changes for the next date and then repeated again until it changes, e.g.
A
1 01/02/11
2 01/02/11
3 01/02/11
4 01/02/11
5 02/02/11
6 02/02/11
7 02/02/11
8 02/02/11
9 02/02/11
If so, put this in F1 and drag it down:=IF(A1<>A2, SUMIF(A:A,A1,E:E), "")Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 55.35%

I have added some bookmarks earlier (have already many bookmarks) but I just can't find them and was wondering if it Is it possible to search for the bookmarks based on the date it has been added to the browser?
Just like opening windows explorer and you can search base on dates, file size or the name.
 
thanks in advance
 
 

Answer:Possible to search bookmarks based on date?

You did not say which browser but for firefox go to Bookmarks > Organize Bookmards.  In the Bookmarks Window select Views > Show Columns. Check Added for the date added.
 
Edit: I don't think you can search by date though. You can only sort by date by clicking on the Date Added heading.

5 more replies
Relevance 55.35%

I am trying to create a code that will highlight an entire row the day before the date entered into a cell on that row.
 

Answer:Excel/Highlight Row Based on Date

use conditional format
add a formula

=cell with the date = today()+1
that will be true if the date

just to make sure we understand

today() is 7th August
the date in the cell is 8th august
so you want it highlighted

so cell = 8th
today + 1 = 8th
it highlights

now to highlight the row
use a $ on the cell that has the date and apply to the whole row

so if the date is in column C and say row 5

then
$C5 = today()+1

in the conditional format formula and apply to
$A$5:$Z$5
or whatever column you need

a sample spreadsheet would be useful , you can attach here
 

1 more replies
Relevance 55.35%

Hi,Example:AAA_20100909.csvBBB_20100909.csvAAA_20100910.csvBBB_20100910.csvHow to write a batch script which is able to grab the files based on the lastest date. In the examples above, I just want to grab the files named AAA_20100910.csv and BBB_20100910.csv, anyone can assist?Many Thanks :)

Answer:How to get files based on lastest date

yokelai, In this forum, we have quite a bit of generalized knowledge, but you'll likely get more and more knowledgeable responses in the programming forum @:http://www.computing.net/forum/prog...That said, I'd put a variable containing the current date (maybe use an 'if-then' if you need to go back?) to enhance the 'open' statement and narrow down the filename?HTH.Ed in Texas.

2 more replies
Relevance 55.35%

Daily we send many mails. We handle the reactions of customers which send us a mail using our subject the first 7 days (not a reply). After 7 days we would like to send an autoreply and archive the mail without looking at it.
How can we do that?
As we can adapt the subject to use, first idea was to add the limit-date and set a rule. But I don't find how to set a rule that compares the day of reception and this date included in the subject?
 

More replies
Relevance 55.35%

All

I have some files named for each day of the week (Monbackup.csv, Tuesbackup.csv, etc).

I want to copy Mondays file in the early hours on Tuesday morning to another server using a script - then the same for each day of the week.

Anyone know the best way to go about this? Am happy to use a batch file or PowerShell..

Thanks in advance.
 

Answer:Copy file based on date

Can you clarify; is the "date" of the file based on the name of it in its file name (i.e., your "Monbackup.csv"), or is it based on the save-date in its properties?

If its by the save-date in its properties, you can use the /mir option with Robocopy (I think if you're using XCOPY, you'd use /d (d for date) and then specify the date to use for that case by the entire option command "/d:MM-DD-YYY"). This will mirror a directory specified, copy the file to the new directory if it doesn't exist, and only overwrite the file if the source is newer than the copy.

You can do this in a batch file. You'd probably want something like:

ROBOCOPY sourcedirectory targetdirectory /option1 /option2 /option3

If you want to copy all folders and subfolders regardless of whether they're empty or not, you'd use the /e option. And to mirror and copy newest based on file property date, you'd use the /mir command. You can specify a log file output with the appropriate option. Exchange XCOPY with ROBOCOPY and /mir with /d:MM-DD-YYY as necessary.
 

5 more replies
Relevance 55.35%

I am trying to utilizing a sum of cells in a columns that needs to be cumulative by date...was trying=IF(DATEVALUE=TODAY,(SUM(Q9+Q14)),"0")or=IF(NOW,(SUM(Q9+Q14)),"0")with no luck...any help?

Answer:IF/THEN using DATEVALUE (conditional sum based on date)

also triedGot it to work I think using=if(B7>TODAY(),"0.00",SUM(O7-L7))

2 more replies
Relevance 55.35%

i want to add up the cells in 1 column that have a specific date range in a different column.. can anyone help.The truth is out there.. somewhere...

Answer:Formula To Add Values based on date

Hi,Here is a way to get the sum of values in date ranges:Create a horizontal table of first and last dates in each date range.I created this table for 6 date rangesFirst start date in cell J2First end date in cell J3The next pair is in cells K2 and K3 and so on to O2 an O3I had 200 dates in column G from G3 to G202I had 200 values in column H from H3 to H202The value column does not have to be adjacent to or to the right of the date column, but it must have the same range of rows.In cell J4 underneath your first date range enter this formula:=SUMPRODUCT(($G$3:$G$202>=J2)*($G$3:$G$202<=J3)*($H$3:$H$202))Note the $ signs - they are required, so that the formula will refer to the correct cells when it is dragged to extend it.Select Cell J4 and drag it to extend it underneath your date ranges in my example to cell O4You will now have the totals for each of the six date ranges.(all dates must be recognized by Excel as dates for this to work)SUMPRODUCT() returns 1 if a comparison is match, zero if it isn't, so the first two parts of the formula return 1 or 0 for each date comparison in column G, in turn. When a date returns a zero from either of the first two parts of the formula, as it multiplies the parts together, anything times zero is zero, so the last part of the formula $H$3:$H$202 is only added if the date matches both criteria.If a date is 'in-range' the result is 1 * 1 * value in column HIf a date is not 'in-range' the result is 1 * 0 * value, or 0 * 1 * value, which i... Read more

2 more replies
Relevance 55.35%

I am trying to calculate time based on date. i have to put next day if the time exceed 5:30 PM. if not then same date will be there.. Ex. 2/12/2013 5:31 3/12/2013Please help

Answer:I am trying to calculate time based on date. i have to put n

How about this:=IF(OR(HOUR(A1)>17,AND(HOUR(A1)=17,MINUTE(A1)>30)),A1+1,A1)Format the cell with the formula as Date to display just the date.If the time is from 6:00PM to 11:59PM, the HOUR will be greater than 17 (5PM) so add 1 to the date.ORIf the time is from 5:31PM to 5:59PM, the HOUR will equal 17 AND the MINUTE will be greater than 30, so add 1 to the date.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 55.35%

Hello Lenovo community,Today i bought lenovo y50-70 ci7 gaming laptop (Not the 4K one) As i went to windows update, i saw that there were updates installed previously dating from May 2014, July 2014.But i bought the laptop on 27th Jan 2015! So how is this possible that updates were previously installed by someone? Could this be a used laptop or refurbished one? Please tell me i am really worried.  TIA













Solved!

Go to Solution.

Answer:Lenovo Y50-70 Originality issue!!!!!! (Updates installed before purchase date)

hi mrintelligen,
 
If you purchased the Y50-70 as a closed box then that's definitely not a second hand laptop as the store will indicate it as an "open" box / pre-owned.
 
As for the updates, if the machine is preloaded with Windows 8.1 (which was released Aug of 2013), you're likely seing bug fixes / optimization and critical updates for the OS which were preloaded from the factory (these are essential updates to make the OS running smooth).
 
As for checking if the unit is a refurbished or not, this is normally indicated on the Machine Type Model (eg. 59RF0010), in which RF stands for refurbished (you can find these info on the bottom sticker of the unit).
   - Sample item
 
 
Regards

1 more replies
Relevance 54.94%

In Outlook Express my mail used to sort itself into date order no matter where I sent it, now it doesn't and it's all over the place. Can anyone help? Thank you, Kay.
 

Answer:{Solved} Message date order

Just click on the column header of the field you want to sort by. It should hold that setting in future openings of OutlookExpress.
 

3 more replies
Relevance 54.94%

I am receiving e-mail all over the place in random date order, where previously it was in chronological order.Is there something I can do to solve this annoying problem?Many thanks,geedad

Answer:date order for e-mail received

In OE, go to View - Sort By - Received

3 more replies
Relevance 54.94%

I have tried several combinations on arranging my cingular bills with no luck.

What date combination would I have to name the bills to have them to be in order when I choose Arrange-by Date?
 

Answer:Solved: Date Order In View

9 more replies
Relevance 54.94%

Hi, I'm sure someone will know this.In my outlook express window the date (and time) that I receive e-mails is in the american order e.g. 3/12/2005. How can I change this to a british order of 12/3/2005? Can anyone help?Thanks Nick.

Answer:Outlook Express - date order

Regional Settings in Control Panel sets this for all Windows applications

3 more replies
Relevance 54.94%

I'm using windows XP professional and have 'my recent documents' on the start menu. It always lists them in alphabetical order, but I should like to arrange them chronologically (as with windows 98se). Is this possible please?thanksJohn

Answer:Getting my recent documents in date order (XP)

Not true that Start>Documents are always in alphabetical order - you must have done a right click and then Sort By Name at some time; Sort By Name is also available in Programs, Favourites etc.If you disable this it will only list the documents, files and other items used in the order they were undertaken.

9 more replies
Relevance 54.53%

Alright this one might be a bit of a challenge. I am releasing a complex spreadsheet with my product pricing on it. Is there a way to make the program have a "shelf life" of 6 months or so? I would like to set it up to make it inaccessible to anyone without the password after a certain time period. So basically I would like to create a macro that will disable the entire spreadsheet (without the password) after a specific date so I can release new versions (with the new pricing) without the old versions (old prices) getting thrown into the mix. Anyone have any ideas?? Thanks.
 

Answer:Excel Macro - Date Based Protection

Hello CWDENVER, this should be possible to achieve, you can have a date held in a cell in a hidden Protected sheet in the workbook. When the System date = the date in the Cell the Target Worksheet is hidden and can only be made un-hidden by entering a password.
To be effective the Menus would need to Removed from the Workbook as well.
The VBA Editor would need to be password protected as well.
 

2 more replies
Relevance 54.53%

I have 3 sheets namely Master, Eoil, Coolent, Filter. In the later 3 sheets I have several rows and columns (specificially with dates)now I need a Macro button code which should copy the rows and columns when i enter a particular date and if the date matches in any of the sheets. Thanks in advance

Answer:Macro to Copy Data Based on Date

Hi,You need to provide more information.If you think about it, you couldn't write a macro or even a formula if you weren't given the addresses of the cells containing the data.What columns hold the dates on each sheet, including the worksheet named "Master".You say copy the rows and columns .What is to be copied - one row, two rows, twenty rows, or do you want columns copied. You need to specify exactly what is to be copied and exactly where it is to be copied to. When talking about copying rows, consider if copying the whole row is OK, or do you want just a certain range of cells in the row copied.Regards

4 more replies
Relevance 54.53%

I need help please. I need to create a basic calender which shows the month on the top and when you click an arrow the month will change and a set of cells underneath will change. I intend to write into the cells details and when i click on the arrow to change the month the data will disappear. when I click on the arrow to go back a month, I will need this data to reappear. I would appreciate any help. I have created the arrows that change the month.

Answer:Need to change a set of cells based on the date (on excel)

Why not just create a new tab for each month and switch to the tab for the month you are interested in?Visually you would accomplish the same goal and you could go directly to any month you wanted.How have you created arrows to change months?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 54.53%

I have a sheet with several hundred rows. Starting in Row 4 through the end of the sheet are mixed dates in column 1 and ALL rows from Row 4 through the end of the sheet hidden. I want to be able to type in a date in Cell A1 and have all rows that have that date in Column 1, Row 4 through the end of the sheet to become unhidden. Secondly, I would like to type some other code like "999" or something in Cell A1 to have ALL rows become unhidden. Thirdly, I would like to either type another code or just delete anything in Cell A1 and have ALL rows from Row 4 through the end of the sheet to become hidden again.
Tech Support Guy System Info Utility version 1.0.0.4
OS Version: Microsoft Windows 7 Professional, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM)2 Duo CPU T6600 @ 2.20GHz, Intel64 Family 6 Model 23 Stepping 10
Processor Count: 2
RAM: 3963 Mb
Graphics Card: Mobile Intel(R) 4 Series Express Chipset Family, 1853 Mb
Hard Drives: C: 453 GB (298 GB Free); F: 931 GB (710 GB Free);
Motherboard: TOSHIBA, Portable PC
Antivirus: Webroot SecureAnywhere, Enabled and Updated
 

More replies
Relevance 54.53%

hi,i have data like this:8/24/2010 p 152438/24/2010 p 15008/29/2010 n 458/29/2010 p 74108/29/2010 p 6218/29/2010 n 2759/2/2010 p 152439/2/2010 p 1500what I need excel to do is insert a row (blank) after every specific date (for e.g. between the last entry of 8/24 and the first of 8/29).any kind of code that I have written just does not seem to work.. please HELP!!!Thanks..

Answer:insert rows based on date in cells vba

Rather than just giving you the code to do what you want, I think it would be beneficial to you if you posted what you have tried and we'll help you fix it.I'm not asking you to do that to embarrass you or point out shortcomings in your VBA skills, but rather to help you learn from your trials and errors.Sometimes explaining why something doesn't work is more educational that just telling you want does.

5 more replies
Relevance 54.53%

Hi there
I want to make a query that shows me the available rooms for a hypothetical hotel booking system.

I want to specify a date range for my booking (eg 15 Aug 2005 to 29 Aug 2005 - 14 days). I want the query to show me anything that falls outside that range and anything without a booking at all. However, I don't want to see any rooms that have any of that date range already booked (eg a room booked 13 Aug 2005 to 21 Aug 2005 should not show up).

I have the query mostly working, except for some reason it won't show up a room that has a booking prior to the date range I specified.

I have a field for the room number from a room information table, and one each for arrival and departure date from a booking table.

Can anyone point me in the right direction?

Thanks!
 

Answer:Exclude records based on date range (help!)

Hello, to help us can you post a zipped copy of the database on here, or at least post the Query criteia that you are using that doesn't quite work.
 

2 more replies
Relevance 54.53%

Am looking for a way to automatically delete files based on date (files that are 2 days or older) on a NT4.0 server. I'd guess there's some way to do this with a batch file, just not having very good luck figuring it out.
Thanks
 

Answer:Auto Delete Files based on date

Well i think you are posting it in the wrong section it should be under development. I am also curious on this to, So if you find out how send me a PM.

I am also wondering if you could do this with a script? Maybe a VBS script or somthing that will just do what you stated above removed any NT4.0 File thats Older than two days.
 

2 more replies
Relevance 54.53%

Hi Guys,Currently am working on a Excel VBA to alert me through Outlook email based on the following conditions,I've the deadline dates for each tasks listed in Column 'G'. Now i want the VBA to check this deadline date and if the deadline date is 7 days from today, then it should copy the particular Row data and email the data to my email address.This should be performed everyday automatically, without opening the excel sheet.Am very new to VBA. So,Your help is much appreciated.Cheers,PK

Answer:Excel VBA To Email Row Data Based on Date

re: "This should be performed everyday automatically, without opening the excel sheet."I don't think that Excel or VBA for Excel is not going to be able to do this with opening the file - or at least some file.You can't have a macro running inside a closed file, constantly monitoring itself. Something has to trigger the code and/or update the formula that checks the dates, such as the file being opened or perhaps another open file pulling data from the closed file, etc.I guess you could schedule a windows task to open the file once a day or something similar, but there is going to have to be some "action" that initiates the running of the code.

14 more replies
Relevance 54.53%

I have a workbook with two sheets. The first sheet contains customer data. The column of interest is B. Starting at B4 the column contains the date the customers order was entered into our system. On the second sheet is a cover page that is to contain a recap of a specific dates orders. Sheet2 cell O14 will contain a manually input date.What I am looking for is a formula or macro that will take the manually input date in cell O14 on Sheet2, search Sheet1 column B for that specific date and then copy that rows data from column C:I onto Sheet2 starting at B18 going down until all rows containing the date have been copied.I would like this to automatically update Sheet2 each time the date is changed in O14.Any help with this would be greatly appreciated!

Answer:Conditional Copy/Past Based On Date

Hi,I have written a macro that is triggered by a change in the value of cell O14 - the cell with the date on the summary page.The macro will need changing if your source and destination sheets are not named Sheet1 and Sheet2.Select your summary sheet (Sheet2).Right-click on the name Tab at the bottom of the window and select View code.Paste the following into the Visual Basic code window that opens (typically right side of the VB window).Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
'test if cell that changed contained the date selector
If Target.Address = "$O$14" Then
'stop all change events from re-triggering this routine
Application.EnableEvents = False

Dim rngFirstSrc As Range
Dim rngLastSrc As Range
Dim rngFirstDest As Range
Dim rngLastDest As Range
Dim rngCell As Range
Dim intDestRow As Integer

On Error GoTo ErrHnd

'set first row with data
Set rngFirstSrc = Worksheets("Sheet1").Range("A4")
'find last row with data
Set rngLastSrc = Worksheets("Sheet1").Range("A65534").End(xlUp)

'set first row for destination
Set rngFirstDest = Worksheets("Sheet2").Range("B18")
'find last row used
Set rngLastDest = Worksheets("Sheet2").Range("H65534").End(xlUp)

'Clear destination area if data present
If rngLastDest.Row > rngFirstDest.Row Then
Range(rngFirstDest, rngLastDest).ClearContents
End If

'set destination row offset counter
intDestRow = 0
... Read more

2 more replies