Computer Support Forum

ican not set date and time an error is occurewhile date and

Question: ican not set date and time an error is occurewhile date and

set date and time

Relevance 100%
Preferred Solution: ican not set date and time an error is occurewhile date and

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.)

Answer: ican not set date and time an error is occurewhile date and

Enter the BIOS & change the date/time. If it resets after the system has been shutdown for a while & then restarted, the CMOS battery is probably bad.

2 more replies
Relevance 97.99%

Have set the correct time zone, set the date and time, and within half an hour, the time jumps ahead significantly. Time then continues jumping periodically, and date as well. Any patch available for this?
Thanks.

Answer:Date/Time jumps after correct setting of date/time/timezone?

Welcome to the Seven Forums

Perhaps a change of cmos battery is needed. What is happening is a sign of the battery having packed up.

2 more replies
Relevance 95.94%

Greetings, and thanks in advance for your help..

Awhile back I formatted my Windows 10 PCs to show ddd dd-mmm-yyyy on my taskbar clock. This worked happily on my desktop and laptop for months, maybe even a year +

Now (probably starting in the past couple days, if not today), on one of those two PC's, this format will no longer display. It is Okay on the other PC.
What has changed that the taskbar clock space used to expand to fit the "short date" format, but now it will no longer expand - and instead just refuses to display the date at all. (NOTE: I've verified the issue by testing shorter formats -- short formats, like "ddd" show up correctly. Only if you request a longer format will the date not display - evidently because it is too long for the clock area. )

Additional Notes that may help:

* "Working" pc is running build 10586 PC with too small a clock space that won't expand -- Build 14393

*Other differences: Notification/Action center Icon is left of clock on the working PC - Right of clock on the non-working
Right- Clicking on task bar gives "properties" option on working PC -- But "Settings" option on the non-working

( I don't want to prejudice responses - but clearly the implication to me is that some recent OS update is most likely the culprit.)

Thank You

Answer:Taskbar Time / Date area quit expanding to fit desired date format

I had a similar problem which has been greatly ameliorated thanks to a kind respondant - see https://www.tenforums.com/installatio...-new-post.html

1 more replies
Relevance 95.94%

Greetings, and thanks in advance for your help..

Awhile back I formatted my Windows 10 PCs to show ddd dd-mmm-yyyy on my taskbar clock. This worked happily on my desktop and laptop for months, maybe even a year +

Now (probably starting in the past couple days, if not today), on one of those two PC's, this format will no longer display. It is Okay on the other PC.
What has changed that the taskbar clock space used to expand to fit the "short date" format, but now it will no longer expand - and instead just refuses to display the date at all. (NOTE: I've verified the issue by testing shorter formats -- short formats, like "ddd" show up correctly. Only if you request a longer format will the date not display - evidently because it is too long for the clock area. )

Additional Notes that may help:

* "Working" pc is running build 10586 PC with too small a clock space that won't expand -- Build 14393

*Other differences: Notification/Action center Icon is left of clock on the working PC - Right of clock on the non-working
Right- Clicking on task bar gives "properties" option on working PC -- But "Settings" option on the non-working

( I don't want to prejudice responses - but clearly the implication to me is that some recent OS update is most likely the culprit.)

Thank You

More replies
Relevance 95.53%
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 95.53%
Relevance 94.71%

I am looking to set up a macro or formula that basically inserts the current time when a cell is filled SO:

when a2:a100 is populated with any thing then the corresponding C cell will be populated with the time.

AND

when e2:e1000 is populated wiith anything then the corresponding D Cell will be populated.

Currently I am using this macro.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A6:A100")) Is Nothing Then
With Target(1, 4)
.Value = Time
.EntireColumn.AutoFit
End With
End If
End Sub

which works great for the A and C cells

but it does not work for the other one.. how do i add and modify this so all my needs are met.
I need another 2 sets of 2 macros accross the sheet for time entry.
 

Answer:Excel date auto populate date/time

11 more replies
Relevance 94.71%

I have a Date/Time field that I need converted to just a Time field.

It comes back with 2/11/12 0:00:00

I need just the 2/11/12

I thought about changing it to a text field but I think there will be an issue with the month because it does not bring back a 0 in from the months with only 1 digit.

This table that I am creating is being sent to a txt file and that is where I see the issue. It looks good in Access, but not the txt file.

Any suggestions?
 

Answer:Solved: Access - Convert Date Time to Date

10 more replies
Relevance 94.71%

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 94.71%

Hello, I have spreadsheet with a number of dates and times ie (11/19/07 8:57 AM) in column A and data going along with each of these dates and times from columns B-CK. I am trying to limit the list to show the information that is for all times after 2:45PM. The problem is I cannot sort by time and the dates attached to all the times span from 2004-2007. Please help!
 

Answer:Stripping the date portion of date/time in excel

7 more replies
Relevance 94.71%

Hi All,
I am using LUMIA 1320 that has Lumia Cyan.
Sometimes the time and date is getting reset to a specific date, i.e. 22nd May 2014
Due to this all reminder, alarms and new messages are not coming in sync.
Is this a virus? Does it have come from an app. If that is the case then it questions Microsoft App policies...
Anyone who has encountered this issue and has done something to eradicate it let me know.

Answer:Why is my phones time and date getting reset to a specific date?

First, windows phone can never get a virus. Its the safest platform after iOS . And no, a particular app can't affect the system's time and date. I think your should try to manually set the time and date in the settings. And see if it works.

3 more replies
Relevance 94.71%

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 92.66%

Hi all!
Before I ask my question I just want to let everyone know that this site has been a great help.

So, I have a TextBox that needs to accept a date and time. Simple enough. However, the data that I need to collect has to always have a date and time but when I use General Date it will accept either Date or Time or both as its designed to do so.

I have tried setting

Format as " m/d/yyyy h:nn:ss ampm "
Input Mask as " 90/90/0000\ 99:00:00\ >LL;0;_ "

and tinkered with me.textbox.format() as an if statment

But this leads to the other issue that most of this data will be pasted into the form in either of the below formats.

7/19/2017 12:08:14 PM
Wednesday, July 19, 2017 12:08:14 PM

I'm stumped and haven't been able to figure this out through research or my own luck.

Any help is appreciated and thank you all.
 

Answer:General Date Forced To Have Date And Time

So.... I think I figured it out. Been testing it and it seems to result in the way i need it to. So I have the Form/Table set to Date/Time Field formatted as a General Date. This will at least validate that the information inputted in the text-box is a date/time of some sort. Then I added the below code to make it follow a validation rule of sort. So far it seems regardless of the way information is pasted in the end result is always MM/DD/YYYY HH:MM:SS AMPM
If Me.YourTextBox Like "**/**/**** **:**:** **" Then
Cancel = False
Else
MsgBox ("Please enter a date and time in this format MM/DD/YYYY HH:MM:SS AM/PM")
Cancel = True
End If
I'm still open to suggestions if there is a more efficient way of doing this. If not I hope this information will be found helpful to others.
Thanks All,
 

5 more replies
Relevance 88.56%

Hello everybody, Can help anyone to resolve my problem.I have an Thinkpad W520 (42823FG), BIOS 8BET60WW 1.4        When I disconect AC power and remove battery and connect again, I see this message on screen:"Real Time Clock Error - Check Date and Time settings, System CMOS Checksum badPress Esc to continue or F1 to enter Setup" Is this a system board problem or CMOS battery problem ? Thank you 

Answer:Real Time Clock Error - Check Date and Time settings, System CMOS Checksum bad

Hello and welcome,
 
It's probably (hopefully) just the CMOS battery.  The easiest way to find out is to just replace that battery.
 
Page 85 of the Hardware Maintenance Manual:
 
Hardware Maintenance Manual
 
Here's an example of the battery.  I'm not recommending (or not) this vendor:
 
http://www.ebay.com/itm/New-Lenovo-ThinkPad-W500-W510-W520-W530-W700-W701-W701ds-CMOS-RTC-Backup-BAT...
 
Z.

1 more replies
Relevance 87.33%

Due to power loss my computer autometecally restarts and show date and time error.plz help me.
And when i shut down my computer with start manu.it does not show the error

Answer:date and time error

Quote:





Originally Posted by arabicteacher


Due to power loss my computer autometecally restarts and show date and time error.plz help me.
And when i shut down my computer with start manu.it does not show the error

4 more replies
Relevance 87.33%
Question: Date & Time Error

Hello --

I am running Windows XP and recently started having a problem with the date & time.

If I shut the computer down for a short period of time everything comes back fine. However, after shutting things down for more than a few hours, the date and time revert back to the same date time of June 3, 2003. I am able to reset the date and time while online, but encounter the same problem each time after shutting down for more than a few hours.

I was going to change the battery, but thought I would check here first, in case anyone has encountered such a problem and knows a solutuin.

Thank you
 

Answer:Date & Time Error

Sounds like a nearly dead CMOS battery to me. I'd go ahead and replace it. Be gentle with the holder, some of them break easily.

Jerry
 

2 more replies
Relevance 87.33%

I have an odd fault here. Recently (about two weeks ago) for no particular reason (i.e.. I have not added new software or changed any settings) my Laptop seems to lose track of time. This only happens after bringing the laptop out of standby, at which point the laptop appears to remember the time it went into standby and not the actual time. After opening (bringing out of standby) the wrong time still shows for a yet to be determined period and then the laptop somehow catches up to the correct time. Obliviously this is not critical, but sometimes I am sending emails from yesterday because the time is wrong, so very annoying!!! Ideas please!

Answer:Time and date error T42

Maybe you need a new CMOS battery. 

2 more replies
Relevance 87.33%

Hello, I have a HP compaq nx6110 and i keep getting the eroor code 163 time and date when i try to log on. Once the error code goes away the screen goes black, i have no idea what to do. I was doing a little research online and some possible suggestions were that the cmos battery is dead or the motherboard is dead, however I have no idea. If anyone could help it would be great.
 

Answer:error 163 time and date

see the bottom response here http://forums13.itrc.hp.com/service...47627+1248914596399+28353475&threadId=1196718
 

1 more replies
Relevance 86.51%

everytime i power up my pc i experiencing check sum error & when i set everything in bios and boot it up it runs good and when i restarted it again it runs good also...but when i shut it down and unplugged the power source after an hour and power it on, check sum error appears again. i experiencing it for a long time now i already replaced my cmos battery but still nothing happens.my motherboard is ASROCK NF7G AM2 i never configured my bios except date and time, i never ever use overclocking also....pls anybody help me regarding on this problem thats bagging me always.....

Answer:about checksum error date/time

Possible the CMOS battery is not making a good connection. Usually the error signals a flat CMOS battery but you say you replaced it.Goin' Fishin' (Some day)

3 more replies
Relevance 86.51%

For the past few weeks, every time I boot up my MESH Vista PC the Set-up screen appears and informs that the date and time are in error. I reset them and work without problems, but they are in error at the next boot up.Is it the American Megatrends CMOS chip at fault or something like a failing battery?

Answer:Date and Time in error at boot up.

How old is your PC. Sounds like your CMOS battery needs replacing.

3 more replies
Relevance 86.51%

I've had no problems with my T-22 which was upgraded to Windows XP and additional RAM was added about a year ago. It's been running fine and had no problems until about a week ago. When I went to turn it on I got an error 0271 "check date and time settings".  Since then I cannot get my computer to boot up. It will get to the point where it requires my password and when I type it in it says OK but won't go any further. I have tried everything but it won't let me into the BIOS setup utility to correct the date and time. I've downloaded diskettes and cds from the IBM website on my other computer and tried to boot up my T-22  (of course I didn't have the foresight to make a boot disk or cd) and tried the commercial softwarre such as Professional Mechanic, etc. but nothing works.  Does anyone have any ideas?

Answer:Date & Time error 0271 with T-22

Sounds like you need a new CMOS battery.

7 more replies
Relevance 85.69%

Hai, Iam Rajesh. my system config... is Intel Pentium(r) Dual CPU [email protected] 1.80GHz.RAM- 2.00 GB (1GB+1GB)System Type- 32 bit O.S.when i power on my system CMOS time not set error is occor.It show Press F1 to set time and date. whenever i power on this error is occured. i changed new battery also but their is no good result.So please Help me. Recently I add 1 GB RAM. Two Ram are different company.

Answer:CMOS time and date is not error occor

I don't think changing the ram would affect the time and date settings. Try removing the jumper on the mobo.

3 more replies
Relevance 85.69%

I have my uncle's computer its pretty old. Its a compaq windows 7 ultimate. Whenever I start computer the next day it shows the error 2701 time and date settings bios. The computer tech came to my house and change the bios date to the current. Still gives that error and the time and date shows wrong.

Answer:error 2701 time and date settings

Hello Rose,

It sounds like you may need to replace the CMOS battery on the motherboard.

1 more replies
Relevance 85.69%

I have an Buffalo Link Station on my home network. It's working ok except the time stamp on files is wrong. Like 2012. The rest of the system is ok. I have recently updated from XP to Win 7 and started using the Buffalo again.

Regards John

Answer:Home Network Date & Time Error

If you cant change it to the correct date from the http;//192.168.1.1 (you will have to check your ipconfig to see it thats right ip) you should be able telnet into it and use the date command

6 more replies
Relevance 85.69%

That's a strange problem. I true to change meaning in the Setup. All of them changed except Date and time. After power turn off all settings become defaults not my settings. Backup battery was changed, but unfortunately the problem is the same   after change   But all tests with PC doctor passed without errors. CMOS test and templates are good.

Answer:SL 500 error 8600 CMOS Date/Time Not Set

Hi and welcome to the forum!
 
As per HMM, the system board is the culprit:-
 
"8600 CMOS Date/Time Not Set" = "Run BIOS Setup Utility and save it. If the same error happens after doing it, replace the system board." 





------------------------------------------------------------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 85.69%

Whenever I boot up my T60, it says to check the date and time settings and directs me to the BIOS, which only beeps if I press any of the buttons on the keyboard. Thinking this was a CMOS battery problem, I ordered a new one. However, the same thing still happens. I'm stumped. How can I fix this? Thanks.













Solved!

Go to Solution.

Answer:Error 0271 Check Date and Time - T60

Welcome to the forum!
 
You have to scroll down to "Time and date" settings in BIOS, correct them and press F10 to save and exit.
 
Good luck

1 more replies
Relevance 85.69%

Hello:     I'm trying to restore an older HP computer for fun, but as it boots the system will give me 2 short beeps and then will proceed to give me an error 0271 Check date and time!  I think this has something to do with the bios but I can't even get into the bios to fix it.  Can any one please help?

Answer:0271 error (check date & time)

Unplug the machine from the power supply. Make sure you are properly grounded and replace the CMOS battery: it's about the size of a dime and can be bought just about any comp. store/Radio Shack etc.  #CR 2032 part number.While you have the case off check for any dust bunnies/dirt etc. You can blow these out with a can of compressed air.patio.

7 more replies
Relevance 85.69%

Hi everybody,

i got the problem in my outlook express that in the date and time.
The problem is, let say i send email on 25 Mar 2005 and the time is 1.05pm.
But when the receiver receive the email, the email date shown is 26 Mar 2005 and the time is 4.25am. That mean the receiver cannot know the exact date and time i send to him.
And my computer date and time is no problem.
So anybody can give me advce for this problem?
 

Answer:outlook express error date and time

But when the receiver receive the email, the email date shown is 26 Mar 2005 and the time is 4.25am.Click to expand...

Does that happen with email from anyone but you?

The receiver (or you) should click the clock in the system tray and check to make sure the time and date are correct. And also the time zone. Other than that, it could be a server or the location of the server that is causing the problem.

sekirt
 

3 more replies
Relevance 84.46%

Hi folks.

For some time I've been having trouble with my laptop. Toshiba Equium L20-198.

If I unplug from mains for any time, when I re-connect and boot up the computer I get the following two warnings.

Error 0271 check date and time settings.

Warning 0251 system cmos checksum bad default configuration used

About 6 months ago we replaced the CMOS battery, having had difficulty locating a brand new ML1220EI2 Nickel hydrogen 3V 14mAh, we had to go for a "quality used" one.

The problem still persists and I now also get this message whenever I reboot rather hibernate.

Yes, the computer is just over 5 years old and knocking on a bit, but it is absolutely fine in every other respect - with one exception - the main battery is completely dead. If the mains becomes disconnected, I get shut down within about 3 minutes. :(

Is it possible that the CMOS battery charges itself from the main battery and that is my problem? I did a bit of googling and found a similar question and answer on a Dell forum where someone did state that the CMOS takes it's power from the main battery. Could this be the case with my Equium and could buying a new battery solve my problem? I obvioiusly don't want to spend ?30+ to find it won't help, so any answers would be appreciated.

Thanks.

Message was edited by: d14ner

Answer:L20-198 Error 0271 check date and time settings

Hi folks.

For some time I've been having trouble with my laptop. Toshiba Equium L20-198.

If I unplug from mains for any time, when I re-connect and boot up the computer I get the following two warnings.

Error 0271 check date and time settings.

Warning 0251 system cmos checksum bad default configuration used

About 6 months ago we replaced the CMOS battery, having had difficulty locating a brand new ML1220EI2 Nickel hydrogen 3V 14mAh, we had to go for a "quality used" one.

The problem still persists and I now also get this message whenever I reboot rather hibernate.

Yes, the computer is just over 5 years old and knocking on a bit, but it is absolutely fine in every other respect - with one exception - the main battery is completely dead. If the mains becomes disconnected, I get shut down within about 3 minutes. :(

Is it possible that the CMOS battery charges itself from the main battery and that is my problem? I did a bit of googling and found a similar question and answer on a Dell forum where someone did state that the CMOS takes it's power from the main battery. Could this be the case with my Equium and could buying a new battery solve my problem? I obvioiusly don't want to spend ?30+ to find it won't help, so any answers would be appreciated.

Thanks.

Message was edited by: d14ner

1 more replies
Relevance 84.46%

I live in Israel I changed the time zone to Jerusalem and still the time isee now is 12:49 AM while the real time now here is almost 8 PM
The date is correct.

What I did is going to control panel > date and time > internet time > change settings > update now

When I click on update now button no matter what server I select in the combo box now it's on time.windows.com it's thinking some time about 10-20 seconds then i'm getting a message error: An error occurred while windows was sync...with time.windows.com

The same error i'm getting on all server there I tried.
Once I think I got success to update but it didn't update the time, the time still not correct.

What else can I do to update the time ?

Answer:How to sync my system date and time from internet ? error

I tried this solution in youtube: https://www.youtube.com/watch?v=JJL6geu7ovk
But it didn't work. It did once when changed in services to automatic on the windows time properties it did for once I saw a successful message like it did update in the internet time but still the time is not correct. And now when I click update now button again the error happen again.

1 more replies
Relevance 84.46%

Each time I start my laptop (Advent Roma 2000) the date/time is incorrect showing the year 2008 - I have installed new battery as this was faulty as well but date/time still incorrect.
 

Answer:Date/time error on Advent Roma 2000

When you say you replaced the battery you do mean the Motherboard battery [the shiny chrome round one] & not the laptop battery. Correct??
 

1 more replies
Relevance 84.46%

I recently picked up an old HP Compaq nc6220 running Windows XP at a local boot sale. The system was working fine until early this morning when upon boot up it showed the error message...

163 - time and date not set

Initially I thought this might indicate my CMOS battery was dying or dead, but thought that I could resolve this even temporarily by rebooting the system, going into setup and resetting the date and time there.

Unfortunately when I tried to do this by rebooting my system it wouldn't respond and I was left with a blank screen.

So I took out my main battery, disconnected my power cable and held down the on/off button for around a minute to try and drain any remaining charge. Then I rebooted the system again.

Alas, nothing had changed. I was still met with a blank screen.

So I tried again, this time loading my Windows XP disk into the CD drive in an attempt to boot from it.

Nope - that didn't work either.

So I'm now lost for what to do next.

Can anyone help me please?

Thank you.
 

Answer:HP Compaq gives time and date error then refuses to boot up

If the CMOS battery is dead, the computer may not boot.

A manual for repairing the laptop can be downloaded here: http://h10032.www1.hp.com/ctg/Manual/c00622160.pdf
The procedure for getting to the battery can be found in section "6.24 System Board". It looks fairly involved, so I would not recommend attempting it unless you are confident you can put everything back together.

The battery isn't one that is readily available since it has leads attached to it. Here is one possible source: http://www.ebay.com/sch/sis.html?_kw=BIOS+CMOS+Battery+379812+001+3+for+HP+Compaq+NC6200+NC6230
 

2 more replies
Relevance 84.46%

I have been facing this error since 2 days. It happened suddenly when I switched on my laptop and there was no display for few seconds and this error display with a beep "error 0271 check date and time". Manually I adjusted the time and date, bust this process has become a routine phenomenon whenever system is switched on after one or two hour of the shutdown.
 
anybody facing the same or related problem can share their problem and solution
 
with regards
 
umakanta dash
mumbai
 
 
Moderator note; e-mail address removed to stop the spambots getting it
 

Answer:Lenovo G 550 Error -0271 Check date n time

Sounds to me like you have a dead CMOS battery.   There should be access to the battery on the bottom of the unit.  It should be a replaceable battery - test it with a battery tester first.  If the battery is ok - you could have a hardware problem and will likely have to send it in for service. 

4 more replies
Relevance 84.46%

Hey guys - i don't know what i've done but when i boot up my laptop there is a loud 'peep' noise and on the black screen is a list of things like 'RAM Passed' and 'Mouse Initialized', however it then says 0271: Check time and date settings. What have i done and how do i fix it?

Answer:ERROR 0271: Check time and date settings

Currantbun,double click on the clock in the system tray, and then sort out your time and date settings.

10 more replies
Relevance 84.46%

I got a hp compaq nx6310. The HDD is formatted and when turn the pc on it load the HP screen and opts to go into BIOS which I can access and modify options work fine. But then it comes up with "Error 163 time and date not set". If I get a Ubuntu CD and try to run the live install it will not load and will stuck on a black screen with a flashing underscore character .If I load any windows it will boot from the CD and load all dll and kernel but it stuck on "Setup is starting windows" Previoully I have tried to run a HDD and RAM test which both have passed. I also follow some tips I googled such as:Reset the BIOS settings,configure CPU DUAL to DisabledConfigured the SATA to disabled. Still no luck. It does not looks like I can actually run any OS in there. I also search Hp website for BIOS update but I only download *.exe files and I can´t run it as I can not load any OS. Any ideas?Thanks

Answer:Issue booting from HP laptop - Error 163 time and date not s...

Hi,You need to change RTC battery in your laptop. This battery is responsible for time and date.Here You will find service documentation for nx6310 model. On page 137 You will find informations how to do this.

3 more replies
Relevance 84.46%

Hey,

I bought a gigabyte m/b 2 months ago and for the last 2 weeks date and time randomly resets to 1/1/1900. After a few minutes a certificate error comes up (when I play League Of Legends). Here is the picture with the certificate. (https://www.dropbox.com/s/l4e36h27tbcjzu1/Untitled.png?...)
Whether i install it or not, or fix the date time, once it happens it changes every few minutes.

I even deactivated the automatic date/ time sync with the internet.
The CMOS battery is new. But i even changed it and nothing was solved!

Is there anything else i can do?
Windows updates are all installed.
When I press the issuer statement, the following site comes up : https://www.digicert.com/ssl-cps-repository.htm
Also updated the IE!

I have already contacted the Riot Games and they have no solutions (what a surprise!).
This happens only when the LoL Client is on whether I am in a game or not.

Regards!

Answer:Date Time Resets/Certificate Error (lol.launcher.exe)

Call your motherboard manufacturer.

2 more replies
Relevance 84.46%

Hello all, I have lenovo T430s laptop that is configured with Bitlocker encruptions and TPM PIN entry. I don't think that has anything to do with the error msg I am getting but here it is. Error: 0271: Real Time Clock Error - Check Date and Time settings.Press Esc to continue or F1 to enter setup. I am unable to get into BIOS or even the login screen for Windows 7. Any advice would be appreciated.

Answer:Error: 0271: Real Time Clock Error - Check Date an...

It means you need to hit F1 to get into the BIOS to change the date/time. You will need to supply whatever passwords you have set on the BIOS or the hard drive.

9 more replies
Relevance 83.64%

when im trying to upgrade my lumia 730 through windows insider preview it always says server error check date/time and network even though my date and time are correct and connected to wifi
please help me guys.....

Answer:Why does my Lumia 730 say server error even though my phone has correct date and time?

Kind of a tricky question. I suggest you make sure your ducks are in a row before doing your upgrade.
My assumption is you are upgrading to Windows Phone 10. Are you upgrading from WP8.1 or an earlier build of Windows Phone 10?
There are multiple clocks... There are multiple failure spots...
If possible, perhaps you can do a hard reset and start over. If this is possible, it might be the safest solution for you.

2 more replies
Relevance 83.64%

Every time i start my thinkpad R50e, it gives me 0271 date and time error. I have to reset the date and it is able to boot. It happens every time when i start the laptop. Can somebody help to resolve this issue? Is this error related to hardware or some registry related? The guide available with thinkpad says that for error code 0271 just reset the date and time in BIOS utility and it will be resolved. Every time I reset date and time and save it (F10) but next startup gives same error.Regards,Jagdeep 

Answer:R50e thinkpad 0271 date and time error on startup

Welcome to the forum!Your R50e needs a new backup (CMOS) battery. They're about $5 on eBay.Make sure that you remove all/any hardware passwords before swapping the battery.Good luck.

1 more replies
Relevance 83.64%

Apologies if this appears twice, I tried to edit and have somehow lost my thread.

Hi folks.

For some time I've been having trouble with my laptop. Toshiba Equium L20-198.

If I unplug from mains for any time, when I re-connect and boot up the computer I get the following two warnings.

Error 0271 check date and time settings.

Warning 0251 system cmos checksum bad default configuration used

About 6 months ago we replaced the CMOS battery, having had difficulty locating a brand new ML1220EI2 Nickel hydrogen 3V 14mAh, we had to go for a "quality used" one.

The problem still persists and I now also get this message whenever I reboot rather hibernate.

Yes, the computer is just over 5 years old and knocking on a bit, but it is absolutely fine in every other respect - with one exception - the main battery is completely dead. If the mains becomes disconnected, I get shut down within about 3 minutes. :(

Is it possible that the CMOS battery charges itself from the main battery and that is my problem? I did a bit of googling and found a similar question and answer on a Dell forum where someone did state that the CMOS takes it's power from the main battery. Could this be the case with my Equium and could buying a new battery solve my problem? I obvioiusly don't want to spend ?30+ to find it won't help, so any answers would be appreciated.

Thanks.

Answer:Equium L20-198: Error 0271 check date and time settings.

>Is it possible that the CMOS battery charges itself from the main battery and that is my problem?
Well, the CMOS battery can be charged using AC adaptor but the notebook have to be ON for about 18-20 hours.
It?s not known to me if CMOS battery takes the power from main battery?
Usually the CMOS battery should always charge while working and when the notebook is connected to mains?
So theoretically the faulty main battery has no influence on CMOS battery.

I think there could be an mobo issue? I think this could be a reason for that

By the way; in most cases the CMOS battery is not removable... so I wonder how did you repalce this CMOS battery...

2 more replies
Relevance 82.82%

Found diagnosis message in Support and required reset the Real time clock within legal date (1991-2099) but was unable to execute suggestion: "Enter Setup to reconfigure the system date and time". Can anyone give me more specific procedures to resolve this problem. Thanks.

Answer:T21 Boot Problem: Error 0271 Check date and time setting

Welcome to the forum! Your T21 needs a new BIOS/CMOS battery, these are available on eBay for under $10 shipped. Enter BIOS (press F1 while booting), set up date and time, press F10 to save and exit. As long as the machine is kept turned on (until the new battery arrives) you'll be OK. Hope this helps.

5 more replies
Relevance 82.82%

When I try to run Windows Update I get error code 80072F8F (time and date issue). I fixed my time and date, but it still won't update due to the same error code.

Any suggestions?

Answer:Vista/Win Update error code 80072F8F (time and date issue)

Hi this is MS answer Windows Update error 80072f8f
is the cmos battery needing replaced

3 more replies
Relevance 81.18%

Hi when I start the laptop the message appears:

ERROR
0271: Check date and time settings
WARNING
0251: System CMOS checksum bad - Default configuration used

Press <F1> to resume, <F2> to Setup

I would assume this is because my CMOS battery has had it? Is this a know issue with this laptop and how do you get at it to replace it?

Answer:Equium M40X - error message at start up; 0271: Check date and time settings

Hi

It sounds as though your notebook has the wrong time in the CMOS (BIOS).
If you can get into the BIOS, check the date and time settings and make sure they are correct.
It may also be a case of the CMOS battery going out. When this happens your notebook will tend to not keep the correct time.
In such case you should connect the AC adaptor and should leave it connected for about 20-24 hours. At the end of this period the CMOS battery should be fully charged.

Good luck and best regards

3 more replies
Relevance 81.18%

Windows repeatedly asks me to update with the little yellow exclamation mark in the tray but it always fails and then keeps asking over and over again. It's trying to update something I don't even use I think PowerPoint or something; I had the option off at one point for those programs so it wouldn't keep asking but then a message pops up saying are you sure you want to leave these off you might need them.

Any ideas on how to get past this?
 

Answer:Windows Update...date...date...date....

Have a look at this link and see if it helps.

http://support.microsoft.com/kb/910339/en-us
 

1 more replies
Relevance 77.9%

I got a Refurbished Dell Latitude D600 Laptop from ebay yesterday on Tuesday, September 26th 2017, It had Intel Pentium M (Non-Centrino) and Windows XP Pro SP3, but when i boot it up, it resets to The Default BIOS Date, can someone help me?

Answer:Dell Latitude D600 Current Date Resets to The Default BIOS Date

The coin cell battery on the motherboard that keeps time while the system is powered off is probably dead.  Not too surprising given that the D600 is about 15 years old at this point.  If you open the system up, it should be easy to find, so just note the type of battery, e.g. CR2032, and then buy that type of battery at any grocery/convenience store.  Should only be about $2-3.

2 more replies
Relevance 77.9%

Help! I am using a Seagate Central 4TB NAS drive attached to my router via Ethernet. It has been working fine so far for all kinds of file activities. But whenever I modify a file in one of its folders, the creation date for the file also updates and is
changed to the same time as the new modified date.
Maybe relevant details:
I can move/copy folders to the drive and they maintain their created dates.
It happens for both a private user share on the NAS and for the Public share on it.
It happens for at least image files and text files.
I am able to edit files across two computers on the network just fine, the create date stays the same.
This happens from a new Windows 10 machine and Vista machine both.
I notice sometimes the date created seems to stay same until I access the file the next time.
I can't update the NAS firmware because of error.

If it could be a permissions problem, I have been unable to change it from:
Everyone: Special Permissions only
nobody (Unix Group\nobody): Special Permissions only
nogroup (Unix Group\nogroup): Special Permissions only
(Those were there automatically, they are not something I manually put there. I get "Access is denied" whenever try to add permissions or change ownership.)

I have Googled many phrases of this problem far and wide and come up with nothing. I really need to save the original create date because that's how I sort them in programs like Windows Photo Gallery or Picasa. Does anyone know what's goin... Read more

More replies
Relevance 77.9%

First the background: We are gradually deploying Office 2007, but not everyone in the agency has it. I have both 2003 and 2007 installed on my system, but I do my work in 2003, and none of our databases have actually been converted to 2007 format (at least, none that I work with). There are occasionally people who use 2007 when viewing databases, but I don't know if any of the people who are working in this particular database are using 2007. The problem is reproducible in 2003 and so I've been trying to fix it here. The query behind the problem report used to work. It has been a problem for several months (it is run monthly, and every month for the past five they've had problems with it) and I've finally gotten to the root of the actual issue.

The purpose of the report is to generate invoice for outstanding loans. The DateNextPayment is a calculated field based on the payment plan for the loan. It is calculated using a function in the query named qryGetSitesDDInvoices1. This is the function that is called (I did not write this function, I'm supporting this db long after the original writer has left):
Code:
Function DateNextPayment(PaymentSchedule As String, DateFirstPayment As Date, Balance As Currency)

On Error GoTo Handle_err

Dim Date1 As Date
Dim Date2 As Date
Dim Date3 As Date
Dim NextQtrDate As Date

'The code adds one month to datenextpayment at start of each month. Or yearly or weekly

... Read more

Answer:Solved: Date Parameter Failing in Query from calculated date field using DateValue Ac

16 more replies
Relevance 77.9%

Hi! Does anyone know what is the format of the date in the field "(battery) Manufacture Date" informed by Lenovo Vantage (Hardware Configuration > Energy)? It seems not to follow Windows setting. In my case, it is set to Brazilian Portuguese DD/MM/YYYY, but there is not a leading "0" in the returned value (see attached image). Does it really disregard the Windows setting and presents it in a fixed format (maybe American English)? When was my battery manufactured (Oct. 07 or July 10)?Thanks in advance.  

More replies
Relevance 77.9%

The title is self-explanatory. So far, I found a software that is able to change this called 'Attribute Changer' but it only changes the date modified in the folder and, when you go into the actual word application > file > info, the date created and modified are not changed. Any help would be greatly appreciated! Thank you!
 

Answer:Changing 'date created' and 'date modified' in Microsoft Word 2013

7 more replies
Relevance 77.9%

Hey guys,
I have a question about coding and setting an excel file to send emails. I am using an excel file to track maintenance work orders and I would like to get an email each day for each work order that is requested to be finished on that days date. I have attached the excel file I am using, and the column that is important is C, "Date Needed" - If that date is today's date, the cell turns red and I would also like to get email notification about it. A separate email for each cell that matches today's date.

Also, if possible, I would like for it to look at all the sheets, not just the current month's sheet. For example, if a work order was filed in July but wasn't needed until September, I would still like to get the email reminding me that it needs to be finished on xx date in September.

I have attached the excel file I want to use.

I have searched all over this forum and others and have found many posts similar to this, but I am not a great manipulator of code, so I cannot get any of the other solutions to work.

Any help would be greatly appreciated, thanks!
 

Answer:Solved: Using Excel 07 to Send Emails When Date in Column = Today's Date

16 more replies
Relevance 77.9%

After running a large update of windows on May 18 I found that ALL my files in ALL my folders are showing a Date Modified of May 18 2013. Can't find a similar report of this problem. Any ideas?
Using Windows 7 Professional 64-bit

Answer:File Date Modified reset to today's date after windows Udate

Would this help? enter link description here

1 more replies
Relevance 77.9%

Hello.
I'd like to see Long Date and Long Time in my System Tray instead of Short Date and Short Time. 
But due to some restrictions connected with my work I can not modify Short Date & Short Time to look how I want them to look in System Tray.
So basically I need Windows to show what is set as Long Date & Long Time in System Tray instead of showing Short ones.

Is it possible? Maybe some registry tweaks?

Answer:How to display Long Date in System Tray (without modifying Short Date)?

Hi,
There is no workaround to display the Long Date in taskbar without modifying the Short Date parameter.Ivan-Liu
TechNet Community Support

8 more replies
Relevance 77.9%

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 77.9%

hello to everybody

I need batch code to check if date is modified in three files and that date should be compared with current date (%date%).If so,do some job,otherwise quit (exit /b)

I found a bunch of solutions but what troubles me is date format.
On my machine it is dd.mm.yyyy

Thanks in advance.
 

Answer:Solved: batch to compare file modified date with current date

10 more replies
Relevance 77.9%

Searching for files modified in a specified date range (of the past 3 days) gets a search result list titled "date modified", and with the column heading "Date Modified" but the date listed against a file modified today is wrong. The date displayed matches the file creation date & is within the specified range ... but how do I know what the Search is doing?

Can't trust it... !

Answer:File search (by date range) displays incorrect Mod Date in results

That is very strange. Bump for a possible solution, since I can't think of one off the top of my head.

1 more replies
Relevance 77.9%

I forgot my new mobile password.Also i remove battery then time setting is now incorrect.I try 5-6 type to set password

Answer:I forgoet my scree lock password?Also i remove battery ow date setting is not current date?

hard reset your phone using following steps :-
1. Turn off your Windows Phone. Use power button to power off the phone.
2. Press and hold Volume down key and connect the charger to phone. You will see a big exclamation mark on the screen.
3. Press these keys one after another in the same sequence. Volume Up, Volume Down, Power, Volume Down.
4. You will see the phone reset and boot normally. You will see wheel gears working on the screen. It will take few minutes.
Your phone will be reset to factory settings and you need to set up the phone again.
Or try to reset phone's setting if it is connected to Wi-Fi or data is enable through your account.

more replies
Relevance 77.49%

Somehow the date on one of my old Excel files has turned from 1999-10-04 (i.e. October 4, 1999) to 4617-04-11. How can I change all the rest of the incorrect dates back to what they should be? This is the only date that I can confirm. And I have no idea what the rest of all the dates should be on this spreadsheet. TIA.

Answer:Excel date problem - to convert incorrect date to original

I have no idea what the rest of all the dates should be on this spreadsheetThen how do you purpose to change them, when you don't know what year they are supposed to be?Somehow the date on one of my old Excel filesAny Macros running that may have in some way impacted the dates?How is the data stored? As Text or as a Date?MIKEhttp://www.skeptic.com/

5 more replies
Relevance 77.49%

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 77.49%

I'm working on a spreadsheet that lists monthly recurring expenses. I have one cell on the sheet listing the current date (using the "=Now()" formula), but I'd like to have the other cells change at certain times throughout the month.

For example, if one cell currently says "April-15", when the actual date reads "April-16", the respective cell would change to "June-15". This way, whenever the spreadsheet is viewed the next recurring payment date will be seen.

I know this is the wrong tool for something like this - I'm using SharePoint at the office with a calendar list with workflows that shoot off emails in a much better put together format - but this is just for home use and I'd like to keep it all in one document if possible.

Any ideas or suggestions would be greatly appreciated. Thanks in advance.
 

Answer:Excel 2010: Cell Date Change with Current Date

The way I read it was that you have fixed recurring payment dates, so you just want to know the next date based on the day today. Hope the attached might assist.
You need to list the payment dates somewhere and then the formula looks up the next date. You might want to look up today plus 1 (or something) to reflect the fact that if the next payment date is today, there's a good chance you'll not get any unplanned payments on that run.
 

1 more replies
Relevance 77.49%

I have a field that reads 2009-12-30-15.42.22.81298 as text. i want to make in be a date of 12/30/2009 15:42:23 and ignore the milliseconds. Is this possible?

Thanks
Ted
 

Answer:Converting complex date text fields into date or numbers

Ted, what software are you talking about?
Are there always 8 values in the date part?
 

3 more replies
Relevance 77.49%

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 77.49%

Hi all,I need dos command to compare the file creation date and the modified date.My scenario is,If user inputs the folder path to the batch file, i have to provide the file list (which are under sub folders of the given folder) ,which do ot have creation date and modified date as same.can anyone help in thisThanksVanisree

Answer:Dos command to compare file creation date and modified date

You need a CMD.EXE Command Prompt solution, XP does not have MS-DOShttp://ss64.com/nt/ARM Devices are the future, great British Design !

2 more replies
Relevance 77.49%

Hi all,

I'm new to Windows 7 (Home Premium 32-bit) and I just can't figure out what's going on here! Basically I want my short date format to be dd/mm/yyyy (UK format) e.g. 05/11/2010, but when I key a date into Excel 2002 it is appearing as 05 11 2010. In Control Panel I have the short date format set to ddd dd/MM/yyyy and the example is shown as Fri 05/11/2010, but in Excel all the date formats are shown with space separators, e.g. 14 03 2001! I don't think it's an Excel problem though as in Windows Task Scheduler the dates are shown with spaces there e.g. '19:25 on Mon 01 11 2010'. The date by the clock though is shown correctly with slash separators!

I know in Windows XP you can select the date separator from a drop-down list, but this option seems to be absent in Windows 7. Under HKEY_CURRENT_USER\Control Panel\International in the registry, sDate was set to a space, but changing that to a slash (and rebooting) didn't fix the problem.

Does anyone have any ideas please what's wrong and how to fix it?

Thanks
Steven

Answer:Date format using space as date separator rather than forward slash!

Hi,

The option you're after is controlled from within Excel. If you right-click the cell(s) in question you can select 'format cells' and under 'Date' you can select the desired format.


OS

9 more replies
Relevance 76.67%

Hello, I am having trouble finding the previous 2 days totals in a query. I have a totals query with the following fields:
JobID - Criteria: Between 500 And 599
WorkType
JulianDate
Batch
TotalProcessed - calculated field, grouped on Sum. sums field entry
ProdDate - Short Date - Grouped on Where - Criteria Date()-1 Or Date()-2

Today's Julian Date is 199 so query should give me Julian Dates 197 & 198, but instead returns Julian Dates 188 - 196.

Thank you for your help!
 

Answer:Solved: AC2007 Find Date()-1 And Date()-2 in Query

The criteria that you should use for a date period is
Between Date()-1 and Date()-2
 

2 more replies
Relevance 76.67%

Hi there

I know how to do add a criteria to a Query. For example in the QBE pane in design view in the criteria row I enter this statement: Between [Start Date] And [End Date]. When I open up the form that is bound to the query, a message box pops up and I enter the required dates and I get the required data that is between the dates that I specify. However, I'm now finding out that this method is now becoming a nuisance.

Is there a way that I can have 2 unbound controls - one for the start date and the other for the end date in a criteria form. This way I input the dates I want for a particular customer and the form with the required data shows up. For example, I have already developed a criteria form for customers. I have an unbound combo box control that has customer names and when I click on a particular customer name, all the data for that customer is displayed in a form. In the row source of the unbound combo box control there is a SELECT .... FROM ... statement. I also have a button next to the unbound combo box control that opens up the form for that particular customer. Now I want to add two more Unbound controls in the criteria form, one for Start Date and another for End Date.

This way I can select a customer from the customer combo Box, select the start start date from the start date combo box and the end date from the second combo box control and get the desired data for that particular customer between the specified dates. I have attempted to do this bu... Read more

Answer:Access - Start Date and End Date in a Criteria form

Mario: What you want is called a query by form (QBF). I don't know how to do them myself, offhand, but here's the MS Technet article:
http://support.microsoft.com/?kbid=235359
 

2 more replies
Relevance 76.67%

I am using the "microsoft access date/ time picker" control to pick dates. These dates like termination date of a contract will end up in the database. The problem I have is that when I do this,

rst!dateIntoForce = Me!ActiveXCtlDOForce

I end up with this in my database:

1/6/2003 5:48:43 PM

How can I extract only the date part from "1/6/2003 5:48:43 PM" so that only

1/6/2003

goes into the database
Thanks
 

Answer:Date Part only from MS Access Date picker control

Format the date before it gets entered into the db. Format([Date], "m/dd/yyyy")
 

1 more replies
Relevance 76.67%

The AVG on my Dell thinks the Virus database is out of date even though it has the most current update?

How can I change the date back and what might have caused this to happen in the first place. I've heard of some AVG update problem but didn't find much relevant information on it.

Any suggestion or links would be great.

Thanks,
Andre
 

Answer:AVG Free wrong date set; Update thinks it's out-of-date

Check the date on your computer.. And, maybe uninstall AVG and reinstall it..

http://www.majorgeeks.com/AVG_Free_Edition_d886.html
 

2 more replies
Relevance 76.67%

So I have this excel spreadsheet and an example of it basically looks like this:

Project Phase Person Capacity Start Date End Date
A Design 1 25% 1/15 3/16
A Model 1 25% 3/17 5/11
A Design 2 25% 1/15 3/16
A Model 2 25% 3/17 5/11

I'm looking to track a monthly outlook of capacity % over time for each person (in a pivot table), but I'm unable to get it exactly the way it should be. Essentially I would like it to look like this below:

Dates
Person Jan Feb Mar Apr May
1 25% 25% 25% 25% 25%
2 25% 25% 25%

(Sorry, the text keeps left aligning so person 2 should actually have 25% under Mar, Apr, and May.)

Is this even possible, either in a pivot table, or even using formulas?
 

Answer:Excel 2007 - Start Date and End date question

16 more replies
Relevance 76.67%

The column heading in Win 10 File Explorer is 'Date'. But which one?

I've always been used in XP to the default being 'Date modified', but it seems that here it's Date created? Several re-saves have left 'Date' unchanged.

--
Terry, East Grinstead, UK

Answer:File Explorer Date column - whiich date is it?

Hi:
What is the column in Windows 7 explorer? It matches no date column from Windows XP explorer - Super User

2 more replies
Relevance 76.67%

I have a file that lists a Julian date of, for instance, 37573. How do I convert that into something like 11/06/02?

Thanks in advance!
 

Answer:Julian Date--How to convert to calendar date in Excel

That's not a Julian date, Beth.

That is actually a date value that Excel provides.

That's how many days it's been since 1/1/1900.

To change it to a real date, you should be able to select that cell or entire column, hit Format-Cell, Number tab, and choose Date, and then any one of the date formats.

Julian dates are what numbered day of the year. For instance, January 3, 2002 would be 3.

Learn lots about dates and times in Excel:

http://www.cpearson.com/excel/datetime.htm

Be prepared to be there for a while.

Happy Thanksgiving!
 

2 more replies
Relevance 76.67%

I want to calculate how long a member of staff has worked for the company and therefore need to subtract their starting date from the current date.

Answer:How to subtract a date from a date ie years/months elapsed

If you use google to search:Time elapsed calculatorThere are a few online results to help. I hope they help. For the fun of it I calculated how long I have been in existence : 2,177.43 total weeks or: 15,242.00 total days or: 365,808.00 total hours or: 21,948,480.00 total minutes or: 1,316,908,800.00 total secondsThat was from the first result google gave me. Thank god no one will be able to figure out when I was born. message edited by btk1w1

9 more replies
Relevance 76.67%

ok i have a folder on my HD that contains over 60GB of data. within this folder there is many folders and files. is there a way of simply selecting this main 60GB folder and useing a prog to make all the file and folders have the same date/time that i wish?

i basicly want all the files and folders in this 60GB folder to be ...say todays date / time.

can this be done?
 

Answer:file date on a 60GB folder - setting them all to the same date? can it be done?

http://www.febooti.com/products/filetweak/

40 day fully working trial version.

Looks like it will do what you want.
 

1 more replies
Relevance 76.67%

Hello,

I have a large report of application forms which have been submitted including the date when they were submitted however the dates are formatted incorrectly.

1. Although the cell formatting is dd/mm/yyyy the data is being shown in mm/dd/yyyy which means the dates are incorrect (e.g. 2nd January would read as 1st February.)
2. As a result of this dates which are passed the 12th of a month are not accepted as dates (it reads the day figure as months and there is no 13th month etc)

I have tried to use the text to columns function but that makes no difference and I have tried to extract just the dates but I've had no luck.

Can anyone help, I've attached a small sample of the data.

Thanks

Daniel
 

Answer:Exported date field not recognized as date in Excel

Where does the data come from?
What do you get if you have no cell format?
 

3 more replies
Relevance 76.67%

I've just moved "My Documents" contents from one laptop to another
I now find that some of the Word Documents are showing the current date in letters to customers that were created & dated months ago
As these letters are records documents sent out is there a way of preventing them opening with the current date

I've already checked, Wotd - Insert - Date & Time & the Automatic Updates box is unchecked

Thanks for any help

Answer:In Word the Original Date in a letter changes to current date

Is this the file modified date or the file created date? Moving the file will give it a new "modified" date.

1 more replies
Relevance 76.67%

So I have this excel spreadsheet and an example of it basically looks like this:
Project Phase Person Capacity Start Date End Date
A Design 1 25% 1/15 3/16
A Model 1 25% 3/17 5/11
A Design 2 25% 1/15 3/16
A Model 2 25% 3/17 5/11

I'm looking to track a monthly outlook of capacity % over time for each person (in a pivot table), but I'm unable to get it exactly the way it should be. Essentially I would like it to look like this below:

Dates
Person Jan Feb Mar Apr May
1 25% 25% 25% 25% 25%
2 25% 25% 25%

Is this even possible, either in a pivot table, or even using formulas?
 

Answer:Excel 2007 - Start Date and End Date question

You should have posted that in "Business Applications" here: http://forums.techguy.org/16-business-applications/
 

3 more replies
Relevance 76.67%

Hello. I have a cell on my spread sheet which calculates an earliest date due. The cell references other cells to achieve this and looks like this '=C51+(F8*7)' where cell C51 is a date field in the format DD/MM/CCYY and contains the date 26/12/2015. And cell F8 is a number field which contains the value '4'. This value '4' is indicating a number of weeks. So the calculation (F8*7) gets me the number of days and I then add those days to the date in cell C51 to get 23/01/2016.I want this cell to output the current date if the calculation above results in a date that is in the past. Can anyone tell me if there is a simple way to achieve this? Thank you.

Answer:Excel: Substitute a past date with the current date

If I understand you correctly, this should get you what you want:=IF("your calculation"< TODAY(),TODAY(),"your calculation")However, the TODAY() will update every day to always show the current date, assuming "your calculation" results in a date that is in the past.In other words, it will not lock in the first date it calculates. It will always display "today's" date.Is that what you want to see?One other issue: As explained at the link below, the TODAY() function is "volatile". That means that is will recalculate every time the sheet calculates, even if none of the arguments have changed. A large number of volatile functions can slow a worksheet down.https://msdn.microsoft.com/en-us/li...Volatile and Non-Volatile Functions

Excel supports the concept of a volatile function, that is,
one whose value cannot be assumed to be the same from one
moment to the next even if none of its arguments (if it
takes any) has changed. Excel reevaluates cells that contain
volatile functions, together with all dependents, every time
that it recalculates. For this reason, too much reliance on
volatile functions can make recalculation times slow. Use them
sparingly.

The following Excel functions are volatile:

NOW
TODAY
RAND
OFFSET
INDIRECT
INFO (depending on its arguments)
CELL (depending on its arguments)Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

4 more replies
Relevance 76.67%

Excel 2013 and Windows 10 Pro

Today is May-14

Date format is set to show: Mar-16
Pressing Ctrl+; shows: 05 14 2016 in the cell
and it converts to: May-16 after I exit that cell.

Any ideas as to how to fix this or why it adds 2 days to the date?

I don't do much on computer now because of health but when I do and there is a problem, I know some of the experts are here.

Thank you in advance, Ron
 

Answer:Excel Date shortcut posts proper date and then changes

Hey Ron,

This should be a fairly simple one. I'd hazard a guess and say the May-16 is the month and year rather than the month and day.
If you click the format drop down as shown below, and click the last option for more formatting options.

In the box that pops up, navigate to Custom using the left hand panel to navigate.
Here you can make your own (or use a preset if you wish) format to suit your needs.

Here is a quick key to help you get by:
dd = Day in Number format
ddd = Day in Short text
dddd = Day in Long text
mm = Month in Number format
mmm = Month in Short text
mmmm = Month in Long text
yy = year in 2 digits
yyyy = year in 4 digits

You can separate these with pretty much whatever you want.
All of this data is input into the "Type" field as shown in the picture above.

See the picture for an example, Ironically it is May 16th today so it will appear the same as your issue does, but rest assured, as long as you have those D's in there, it will display the day!

Best of luck,
Let us know how you get on,

Xsage
 

1 more replies
Relevance 76.67%

I accidentally formatted the date cell & it only accept numbers

Answer:how to correct a date field when you enter a date a number a

I don't know what you mean by "it only accepts numbers".Why can't you just format it as a date again?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 76.67%

Eg: In the below table (Excel) right now date is numeric want to convert them to DATE format Date of Birth Sex Date of diagnosis1 1/07/41 F 21.02.092 12/06/90 M 2/24/22614 1/07/62 M 11/02/095 1/07/48 F 26.05.096 1/07/39 F 11.02.097 1/07/76 F 2.05.098 1/07/60 F 30.05.099 1/07/80 F 1.03.0911 1/07/56 F 22.03.0914 1/07/65 F 22.02.0916 1/07/74 M 22.02.0917 1/07/67 F 24.03.0919 1/07/33 M 25.02.0920 1/07/45 F 21.03.09

Answer:Convert multiple date entries to DATE format

Whoever wrote the file couldn't even decide on a standard date format. Needs two routines. I prefer to normalize to yyyy/mm/dd.

7 more replies
Relevance 76.67%

I received a .csv file from a company with a date field that looks like this: Tue Jan 03 12:12:20 PST 2012I have tried using the Data Type options to change this to a mm/dd/yyyy format but it will not apply. I tried converting it to a serial number using*mm/dd/yyyy and it will not work ~ nothing happens. I tried using a DATEVALUE formula but keep getting a #VALUE error .. I obviously don't know how to lay it out. Can anyone give me the DATEVALUE formula for this example? I am not sure what "right", "left" or "mid" represent or how to count the value placements. THANKS!!!

Answer:How do I convert a complex date to a simple date in Excel?!?

Try this:With your date in cell A1,First, format cell B1 as a DATE fieldRight click your mouse, select Format Cell, Select Number Tab,select Date, choose the date format you want.Next, in cell B1 enter the formula:=DATEVALUE(MID(A1,5,3)&" "&MID(A1,9,2)&", "&RIGHT(A1,4))That should give you what your looking for.MIKEhttp://www.skeptic.com/

3 more replies
Relevance 76.67%

If I am in the wrong forum, please let me know.

About a month after I started using it, the Say the Time clock program I bought stopped launching the management menu when I right click the date/time field in the task tray (notification area).

Therefore, I can't use or edit the program.

Neither the touchpad nor the cordless mouse works.

Other than this problem, my computer works great. Every single item that's meant to be right clicked works for me.

Is there a way I can generate a log to show the software manufacturer (Provenio) that it's their problem and not mine?

I am a novice user but I can follow instructions.

However, I don't want to put my computer at risk if I make an entry error.

Or is it obvious that it's a software problem?

I've been using computers for 18 years and I've never had this problem until I bought this software and used it for about a month.

I just wanted a conclusive way of putting the ball back in the manufacturer's court.

Thanks for any suggestions.

Regards.

Answer:Say the Time Date/Time Field in Task Tray Doesn't Launch Menu

You can use VEW by Vino Rosso http://images.malwareremoval.com/vino/VEW.exe
and save it to your desktop

Double click it to start it Note: If running Windows Vista or Windows 7 you will need to right click the file and select Run as administrator and click Continue or Allow at the User Account Control Prompt.

Click the check boxes next to Application and System located under Select log to query on the upper left

Under Select type to list on the right click the boxes next to Error and Warning Note: If running Windows Vista or Windows 7 also click the box next to Critical (not XP).

Under Number or date of events select Number of events and type 20 in the box next to 1 to 20 and click Run
Once it finishes it will display a log file in notepad

Please copy and paste its entire contents into your next reply

5 more replies
Relevance 76.67%

Automatic date and time was incorrectly displayed so we changed it manually to correct date and time and power cycled the device off and on and the date and time again is incorrect.

More replies
Relevance 76.67%

Moving between UK and Europe there is a 1 hour time difference. Previous phones get the local time from the network - not the 640!!!
Stuck on UK time is quite embarrassing turning up for a meeting 1 hour late.
Have checked the phone settings - automatically detect is selected in Time / Date area.
Anyone able to help?

More replies
Relevance 76.67%

Has anybody else experienced this problem?

I open Event Viewer - "Admin View" to see what Errors/Warnings are there and in the column - Date and Time only the date is showing. Same goes for all the other views.
The "Time" element seems to have completely disappeared.

Any idea where its gone........... and more importantly, how to get it back?

Thanks

Answer:Time stamp missing from Date and Time column - Event Viewer

Problem solved - but - I don't know why.

Solution:- I changed the Date/Time format from UK to US, opened Event Viewer and it was as it should be. Date & Time showing.
I then changed format back to UK, opened Event Viewer and , as above, the Time was back up.

If anybody knows what had happened I would be most interested.

My thanks to Bill............. from another site for helping me out with this one.

1 more replies
Relevance 76.26%

Hello:

Each time I turn on my computer and as it is boots up it will delay for a time with a line that reads something like ...Automatic IDE Configuration.... and then a message that my date and time are incorrect. The date goes back to Nov. 2003. Once I correct the date, time and year things seem to perform ok. Any suggestions on how to correct this problem would be appreciated. Thanks in advance.
 

Answer:Computer date, time and year change each time I boot up

6 more replies
Relevance 76.26%

I have a 4 year old computer that runs perfectly, except when I turn it off at night and then back on the next day, I loose a few hours on the time date at bottom of screen. I ajust each time I use it but the same thing happens each time I turn it off. Could it be the clock battery or ? My operating system is Windows XP Home
Thanks Lc
 

Answer:Windows XP time/date clock looses time after shut down.

Welcome to TSG...A bad CMOS battery will cause your machine to lose time. If the system is four years old, you're eligible for that issue...also, if the system has spent any lengthy amount of time (weeks or more) unplugged from AC power, it's more likely to happen.

Next reboot (after leaving it overnight), enter BIOS (setup) and see if the time there is slipping as well.

The battery itself (if that's what's bad) is cheap to replace...less than five bucks.

Please give us some specs on the hardware-make, model, etc.-and we can help you with battery replacement instructions.
 

3 more replies
Relevance 76.26%

Hi,I need to calculate the difference in working days / hours between 2 date / time stamps.Some simple example data which spans a weekend.01/07/2016 18:0004/07/2016 09:30(Working hours are 08:30-17:00 Monday - Friday)In this example the first date / time stamp is when an email was recieved (out of hours) and the second is when the email was replied to (1 hour into workiing hours) So the formula should return 00:01:00:00 (dd:hh:mm:ss)Thank you for your help!!

Answer:Calculating working time between 2 date/time stamps in Excel

It's a rather lengthy formula and needs explanation, so see here:http://www.cpearson.com/excel/DateT...If you have further questions, please ask.MIKEhttp://www.skeptic.com/

14 more replies
Relevance 76.26%

Looking for a utility that will allow me to locate files created/modified/accessed using TIME from/to also...as i want to locate those related to a specific occurance. When using just date, I get hundreds of files so would like to isolate further.

Is anyone aware of any such program? Shareware might be ok depending on cost but free is preferred. THANKS!
 

Answer:Solved: Freeware to find files by date and TIME? Time is the key!

10 more replies
Relevance 76.26%

Hi,

I am running XP Home SP3 on an Asus 1005HA netbook

Every time I boot up I get a message to say that either I can press F1 to enter setup to set date/time or press F2 to load default values

If I choose F1 and enter the correct date/time and press F10 to save and exit - XP then starts up normally but the next time I boot up, the same problem occurs.

[If I select F2, then XP loads normally]

What can I do to fix this?

Thanks for any help in advance
 

Answer:Solved: CMOS Set date/time message every time I boot up

Your motherboard battery is dead. You can get a new one at any drug store for about $5.
 

3 more replies