Computer Support Forum

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

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

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.

Relevance 100%
Preferred Solution: Why is my phones time and date getting reset to a specific date?

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: 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 98.81%

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

Hi, hope someone can help every time i turn pc on it takes me to energy screen i have to put in the time and date doesn`t do it automatically it used too don`t know what i have done.please help.
 

Answer:Have to reset time and date

10 more replies
Relevance 97.58%

I misplaced my fitbit charge, and recently found it, but the time & date were off tract. So, can you tell me how I can reset the time & date?

Answer:How can I reset the time and date on my fit it?

You must sync it with your phone or PC.

1 more replies
Relevance 96.76%

I would like for my Access 2007 database to automatically record the date/time when the data in a SPECIFIC field is modified (not when any data in the record changes).

Here is a simplified explanation of my scenario. This database keeps track of cases in my office. A data entry form named "Cases" feeds a table named "Cases." The form includes text boxes that correspond to the fields in the table. Three of these are: "Case_Notes," "Case_Status," and "Date_Status_Change."

I would like for the "Date_Status_Change" field to automatically reflect the current date/time whenever the data in the "Case_Status" field changes. I do not want the date/time to change when information in the "Case_Notes" field is modified.

What code would accomplish this?

The following code will enter the date/time for a change anywhere in the record:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me![Date_Status_Change].Value = Now()
End Sub

But I want to limit it so that it dates changes ONLY in the ?Case_Status? field.
 

More replies
Relevance 96.35%

HiTwice now in the space of 2 weeks,the date and time on my PC has been changed.The PC is only 15 months old,so I guess the MB battery is that old as well.I have checked the BIOS,it says the battery voltage in 3.2v.If the PC boots incorrectly,or the OS,could this change the time?.Cheers

Answer:Time/date reset to 2005??

It certainly sounds like a bad CMOS batteryAS they are very cheap, I would renew it and see if it happens again.

2 more replies
Relevance 96.35%

Hi, I'm new at this forum, so if found any mistakes, i apologize in advance x)

The situation is, i have a Foxconn motherboard that does not save data and time settings, and then i can't acess even Msn and Windows Updates.

This happens if after shutting down the system, and turn off the power supply.

Already checked the BIOS battery, and the CMOS jumper.

If anyone could help me i would be gratefull :cool

Thank You...
 

Answer:Bios reset after set time and date.

If you know for sure the battery is good and you're not getting the correct time and date after setting it and rebooting, then you have a hardware problem and the MB needs to be replaced.
 

4 more replies
Relevance 96.35%

When my PC has been turned off for a while (over night) the date and time reset to 2009 and various times.  Is there a battery or something that requires replacement?  If so, what?

Answer:Time and date reset to 2009

@TOM1233,  you would need to replace the battery which will be available in any store like best buy. it as circular battery which will be the size of 50 cents. 





I am an HP employee.Make it easier for other people to find solutions, by marking my answer ?Accept as Solution? if it solves your problem.***Click on ?Thumbs Up? STAR to say thanks!***

1 more replies
Relevance 96.35%

So - I am having an issue with my date and time being automatic settings.... Everytime I close my laptop, the time and date stops on that time/date and needs to be reset each time I open it (I just turn the auto setting off then back on). Is there anything I can do to keep this from happening? My compter often freezes when I try to correct it and I'll occassionally have issues using Internet Explore or Google Chrome saying it isn't safe to proceed to whatever website I'm trying to access (which I've been told can be related to the time and date being incorrect?) Whether that's accurate or not, I don't know - but for what it's worth, resetting the time and date has resolved that issue each time. However, it would still be nice to have a more permanent solution instead of taking the 5 seconds to reset everytime I get on the computer Any ideas??? 

Answer:time and date reset issues

Hi, If the time resets each time you turn the notebook on, then you may need to replace the rtc cell ( cmos battery ) on the system board - this would also explain the security warning you receive on the internet as you notebook believes the current time does not match the validity period of the sites security certificate. The first thing I'd suggest is to reset the time in the bios menu as follows. Shutdown the notebook.  Tap away at the esc key as you start the notebook to enter the Start-up Menu.  Select the Bios option ( f10 ). You should see that the first field highlighted is the Hour value - adjust this to the correct hour using f5 and f6 ( f5 will decrease the number & f6 will increase it ).  When this is correct, hit Enter to highlight the Minute field and again, use f5 & f6 to set the correct minute. When done, press the down arrow to highlight the first field of the Date.  This should be for the Month, so use f5 & f6 to enter the correct value. Hit Enter to highlight the Day field and set this, then hit Enter to highlight the Year field and set this. If you're happy with the Time and Date settings, press f10 and hit Enter to save these setting and exit the bios menu. Let windows fully load.  If the correct Date and Time isn't showing, go to the Control Panel and set the correct Date and Time here. Restart the notebook and check if this has corrected the issue. If the bios time re... Read more

1 more replies
Relevance 96.35%

Hi, I have an IBM Thinkpad laptop, which resets the date and time everytime I shut it down. So, wen I restart, I am automatically taken to the startup options screen, which says my date is january 1st 1981. Is there an easy way to stop this?

Answer:Automatically Reset Date/Time

Check if the Cmos/Bios battery is dead.

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

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%

The date and time gone back to 2000 and when I tried to connect to the internet I had to join network and type in my password.

Could some thing be wrong with BIOS or BIOS battery?

This happen doing storm the power gone out and there was power surge. The laptop battery was fully charged and was also plunged into the wall.

The laptop will not keep the date and time and setting for my wifi and wifi password if not plung into the wall.

The laptop battery will not work now and will not charge.
 

More replies
Relevance 95.53%

Can anyone tell me why on boot up I get the message 'press F1 to enter set up to change time and date settings ? This happens on every boot up even after I have corrected the settings.

Answer:I have to reset time and date settings on boot up

It sounds as though the CMOS battery on the motherboard is exhausted and needs to be replaced. The most commonly used battery is a CR2032 Lithium cell, which is readily available in any computer or photographic shop and most supermarkets. click here

2 more replies
Relevance 95.53%

I have notebook HP Pavilion dv6 2020ev Corei7, and I?m not able to set up correct time and date. When I set date in BIOS and start Windows 7 there is time difference (few minutes sometimes, few hours etc. but every time different). When I turn off nb (also remove battery) time in BIOS is still OK. But when I start Windows 7 there is difference. BIOS time is ok till I change time or date in Windows 7. And this is big problem, when I update time or date in Windows 7, then after new boot BIOS time and date is reset to 00:00 01/01/2009. I?ve tried everything, update BIOS, fresh installation of Windows 7, change time internet sync settings, change the Hard, RAM,... after a lot of research, i decided to change the bios chip next to the "Control Keyboard chip" on motherboard ( i download last Bios version from HP, and program it), problem not solved.
after that i changed the other BIOS chip. problem not solved again.
finally i change the "Control Keyboard chip" (ENEKB3926QFD2) and unfortunately problem still alive.

note: Sometimes, when I work with my notebook date and time changes it go future or past.
i changed the battery on mother board, No effect.

sorry for my english.

please HeLp Me.

Answer:BIOS time and date reset after boot OS.

Change the cmos battery.

How to replace the CMOS battery.

5 more replies
Relevance 95.53%

Hi everyone, I have a new X220 laptop. Since I have a desktop at home so I only use my laptop during business trip ocassionally.I always have my battery removed from laptop after each usage.I heard that this can prolong battery's life... However, every time when I power up my laptop, it turns on and then turns off itself. At first i was wondering if this is due to the lack of battery. After connect it to my A/C source, it turned on and said System Date and time error and I needed to go into BIOS to reset it. This is new to me as I didn't encounter such issue with older version of thinkpad. Did I miss something here? Pls help. Thanks!! Alex

Answer:Date and Time Reset after battery removal??

Sounds like you may need your CMOS battery replaced.  It should not be a problem after you replace it. Also, if you want to prolong your battery life, just detach it during computer use (use AC only).  Then while it is turned off I would actually plug it back in so your computer is never without a power source for an extended period of time.   There are many studies suggested that battery life will start decaying after 2-3 years regardless what method you use.  I actually recommend making the most use out of it.  Hope it helps.

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

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%

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%

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.3%

Hi anyone,I have a N200 769-ELG. I installed modified winXP SP3 and everytime I plug in or out the power jack the notebook resets the time and date settings in BIOS. Same OS is installed in an old desktop and nothing happens. Therfore I am pretty sure that it is not related. All drivers are installed without any problem according to a sequence list I found in the forums. So I wonder if anyone can provide any suggestions. Thanx anyway..  3000 N200 TY2ELTK T5750 Intel Core2 Duo 2.0GHz 1GB 160GB DVD+-RW





Lenovo 3000 N200 769-ELG - C2D T9300 2.50GHz 800MHz FSB-2GB DDR2 667MHz-256MB Intel GMA X3100-500 GB 7200rpm SATA-Intel PRO/Wireless 3945ABG









Solved!

Go to Solution.

Answer:BIOS time&date reset when power is plugged.

the bios battery probably ran out for some reason, usually the battery should last for around 4 to 5 years, but every once in a while you might get a bad cell that lasts only 1 year or so. So do you still have warranty, if not then you can replace it yourself, you can get one for around 10 USD on ebay.  

4 more replies
Relevance 94.3%

can't access my control panel. gives a C:\WINDOW\system32\rundll32.exe. message

Answer:can't access my control panel and have to reset time n date

R.click the time displayed bottom rh corner of screen then L.click Adjust Date/TimePlease come back & tell us if your problem is resolved.

3 more replies
Relevance 94.3%

I purchased a Kodak Z712 EasyShare camera in August 2007. For the first year, there was no problem with removing the batteries for a moment to change them out. Now all of a sudden, when the battery life gets low and I change out the batteries, the date and time resets. It resets every single time - regardless of whether the batteries have some charge left or not. This has become very frustrating. I've been told that some cameras have an internal watch-type battery to hold date/time when the other batteries are reomoved. I cannot find any information regarding this issue on the Kodak site or in the users manual. Anybody know what to do? Thanks!
 

Answer:Kodak Z712 Date/Time Reset issue

Try this website.
http://www.stevesforums.com/forums/view_forum.php?id=18
I have a P850 that is driving me up the wall. It's shutting down and restarting at random. So far no one can give me an answer to my problem.
 

2 more replies
Relevance 94.3%

First, the issue happened once and then didn't happen again for weeks.  Then it started happening more frequently until it now happens within minutes of windows starting.The problem:Windows boots normally.  After reaching my desktop the PC will randomly freeze without warning.  (Mouse doesn't move, program/browser stops suddenly, etc.)   The screen appears like a screenshot of whatever was happening when the freeze occurs.After a hard reset, the option appears to "Go to BIOS setup" or "Load Default Values".  After choosing option 2, the date is set to 2005 and the usual "Windows did not shut down properly" message appears.The computer:HP Pavillion, 2009windows vista1 gig stick replaced last yearvideo card also replaced last year, everything else original parts.I'm pretty competent on software things, not really that experienced with hardware outside of basic replacement (like a video card).  I need help!

Answer:Windows Freezing often with CMOS date/time reset

Replace the CMOS battery...Part # CR2032 available anywhere...As always when working inside the PC remove all power sources and take anti-static precautions...See how it goes overnite after this...if it is still freezing randomly DLoad and run SpeedFan and Post all your system temps here.

5 more replies
Relevance 93.48%

Hello,
I am using my Lumia for over a week now, it is a fantastic phone, but I encounter a small problem: Date and time resets on its own! After my battery runs out the phone always resets back to 20 July 13, 03:00 and does not pick a new time if time is set automatically.
I tried setting the time manually, but running out of battery still causes the phone to go back to that date. Setting the phone on either automatically or manually and then doing a soft reset, resets the date/time and sets it to "manual" as well.
I am using an International version, bought from Amazon UK. I did all the software updates available. I am on 3 Mobile, UK carrier. I did not have any issues with 3, with my iPhone and HTC One.
Thanks in advance,
Andreas

Answer:Date and time resets after battery runs out and after a soft-reset

The time and date automatic updating does not use internet time servers in the same way as your computer/previous phones. Windows Phone uses the NITZ protocol instead, which is supplied by network providers (although not all of them).
I have the same problem with EE here in the UK and I am forced to manually correct my date/time after any reset.
Please refer to http://en.wikipedia.org/wiki/NITZ
for more information.

2 more replies
Relevance 93.48%

I have had a multitude of problems with my network over the years and have been unable to identify what and why the network regularly resets itself, goes down, does not allow acces etc. etc.
Today I managed to download a bunch of router logs some of which indicate a change of date and associated activity as follows:-
 
Debug Log
2015-8-6 16:22:48 User Level Notice web 1 HuaweiATP User admin login from 192.168.1.5 successfully.
2000-1-1 15:0:28 Daemon Notice wan 1 HuaweiATP WAN connection INTERNET_R_8_35:IPv4 connected.
2000-1-1 15:0:26 Daemon Notice wan 1 HuaweiATP WAN connection Other_B_0_35:IPv4 connected.
2000-1-1 15:0:25 Daemon Notice xdsl 1 HuaweiATP DSL connection is active.
2000-1-1 15:0:3 Daemon Notice xdsl 1 HuaweiATP DSL connection is disactive.
2000-1-1 15:0:0 firewall Warning  0 HuaweiATP Detect UDP port scan attack, scan packet from 127.0.0.1.
2015-7-30 3:19:43 User Level Notice log 1 HuaweiATP Update the log configuration.
 
Informational Log
2015-8-6 16:22:48 User Level Notice web 1 HuaweiATP User admin login from 192.168.1.5 successfully.
2000-1-1 15:0:28 Daemon Notice wan 1 HuaweiATP WAN connection INTERNET_R_8_35:IPv4 connected.
2000-1-1 15:0:26 Daemon Notice wan 1 HuaweiATP WAN connection Other_B_0_35:IPv4 connected.
2000-1-1 15:0:25 Daemon Notice xdsl 1 HuaweiATP DSL connection is active.
2000-1-1 15:0:3 Daemon Notice xdsl 1 HuaweiATP DSL connection is disactive.
2000-1-1 15:0:0 firewall Warning  0 HuaweiATP Detect UDP port scan attack,... Read more

More replies
Relevance 93.48%

Hi, I have an issue I can use some assistance with... I know this is lengthy, but just trying to provide all information...A couple days ago, I shut my computer (~ 3 year old Sony Vaio VGN-AW125J, Windows XP SP2) down and soon after tried to restart. The power light flashed a couple times then went dark. No fan or anything else started up.I left the (main) battery in, but unplugged, and retried it the next day. It started fine... However the date/time were reset to Dec 31, 2007.Once powered up, I experienced no issues with random restarts or shutting down.I closed the top today (standby), went to open it back up, and it wouldn't start again (same indication as before).I let it sit for a while and retried starting, once again it started up and once again the date/time had to be reset...I believe the issue has something to do with the CMOS battery, once it gathers enough of a static charge with the power off, it is able to support a powering up. Does this train of thought make sense? Are there any other potential issues that may be causing this?  I do not think that it is the motherboard since it has restarted after a period of rest.I am hesitant to try to restart to see if the BIOS time is reset as well, I am assuming it is...Thank you for your thoughts,Brett

Answer:Computer starts intermittently, date and time reset when it does boot

Yes, it's the CMOS battery.  Resetting of date after power off is a clear indication.  CMOS battery is what keeps the clock going.All desktops use CR-2032 as do many laptops.  Most newer laptops have an access port for this battery.Your computer:  http://esupport.sony.com/US/perl/model-home.pl?mdl=VGNAW125J&LOC=3Your manual:  http://www.docs.sony.com/release/VGNAW100series.pdfI scanned all 220 pgs, useless!!If this one is anything like yours, big job!!!http://www.insidemylaptop.com/how-take-apart-sony-vaio-vgn-sz-series-laptop/More Info:CMOS battery is a special, which is likely why it failed in 3 years.http://microdream.co.uk/sony-vaio-vgn-aw-series-cmos-battery.htmlSony Vaio VGN-AW Series CMOS Battery

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

I have buy a new Y570 a few day .1. Y570 sometimes can't boot up when disconnect  AC adapter to power on Y570 (only has power on light a few second after shut down) ,certainly connecting AC adapter power is normal. 2.bios date & time MUST auto reset to factory default after power off Y570 and disconnect AC power around 10 Minutes but other bios config NO CHANGE. please help me how to fix this problem THANKS ALL Bios verison : 2.08 

Answer:Y570 somtimes can't power on and bios date & time auto reset

hi xrgb3can you try this trick first?- remove the battery, unplug the ac power, press power button for 30-40 seconds, replace the battery and check if it works.

1 more replies
Relevance 92.25%

We here at work have a few PC's from Lenovo with the same problem! When the PC gets updated to the newest version (BIOS) the time & date resets, after power off. This is NOT a CMOS problem, because all of the other settings in the BIOS doesn't reset. I here by wan't to request a older version of the BIOS or a new version that fixes this problem. I know there is a other threat going on, but it seems to be dead / No help from the Lenovo Support Team that seems to work or isn't clear enough. The BIOS version with the problem is: F1KT47A

More replies
Relevance 91.43%

So I updated my Satellite A200-AH6 PSAE0C notebook (Bios and Graphic update) after installing Toshiba Power Saver, but every so often now, if I have to do a restart, there is a black screen on reboot with some info on my BIOS and some warnings/failed things.

Also, when it comes back, again, every so often, my date/time get reset to December 2004, 12:00 a.m.

Any suggestions?

Answer:Satellite A200-AH6 PSAE0C: BIOS Update issue - Date & Time Reset

Hmm... that?s strange... maybe you should try to update the BIOS again. I?m not quite sure if this will be possible if BIOS was already updated to the newest version but it worth a try.
Furthermore you should access the BIOS and should set it to default settings and should save the settings.

Cheers

5 more replies
Relevance 90.61%

I have left my T400 on stand by mode for 2 days by mistake. This morning I got some kind of alarm. I tried to restart my T400 and I got a message. Reset time and date in Bios. What I did.Now after each start, just a few second later, I got the blue screen. It's like the computer doesn't recognize windows any more. The computer doesn't run the regular windows starting mode. Is it possible that the internal battery is down???What can I do to restart windows?Thanks

Answer:T400 Don't recognize windows after long stand by. Ask to reset date and time get now the Blue screen

what os are you running? xp, vista or win 7?also what is the error message that you are getting?

1 more replies
Relevance 83.23%

Hi, i' using Lumia 830. before 2 week i update my device with 10.0.14393.1593. After that update my camera and flash not open. always showing this error
0*A00F4271(0*00D3704) . i had all the options like soft reset . hard reset, windows recovery tools option but not yet solved. Please help me what i do??

More replies
Relevance 81.18%

Using Word 2010. I have created a doument with the following:
"You are invited to our annual dinner on Friday 18th April 2014....."
It will always be 18th April.
While I can set the year for 18th April using a field ( {DATE \@ "YYYY"\*MERGEFORMAT} ) easily, I am stuck at finding the day for each year. This year it is Friday. Next year it is Saturday.

How can this be coded?
 

Answer:Daay from a specific date

Hi Winsum, welcome to TSG.

You should be able to do something like this for the day of the week:

{DATE \@ "dddd"\*MERGEFORMAT}

If you were doing the whole date (including the April 18), you'd use:

{DATE \@ "dddd, MMMM d YYYY"\*MERGEFORMAT}

Hope that helps.
 

1 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 80.36%

Hey,

I have a form which has several fields. I have created another section on the same form for filtering information. I have an unbound textbox called txtUnloaded that when operating correctly will filter out all records who field "Unloaded" has the specific Date. I cannot get the date one to work corretly for the specific date. I have another filter for between dates but the txtUnloaded date does not work. any help would be appreciated. Here is the code I have.


Private Sub Command150_Click()
Dim strForm As String 'Name of report to open.
Dim strField As String 'Name of your date field.
Dim strWhere As String 'Where condition for OpenReport.
Const conDateFormat = "\#mm\/dd\/yyyy\#"
strForm = "InfoInput"
strField = "Data_Entry"

If IsNull(Me.txtStartDate) Then
If Not IsNull(Me.txtEndDate) Then 'End date, but no start.
strWhere = strField & " < " & Format(Me.txtEndDate, conDateFormat)
End If
Else
If IsNull(Me.txtEndDate) Then 'Start date, but no End.
strWhere = strField & " > " & Format(Me.txtStartDate, conDateFormat)
Else 'Both start and end dates.
strWhere = strField & " Between " & Format(Me.txtStartDate, conDateFormat) _
& " And " & Format(Me.txtEndDa... Read more

More replies
Relevance 80.36%

I have to write a batch script which download file from ftp server(unix environment) which contain several same namefile with different modified date. Batch file should take two parameters file name and last modified date.that script go to server and match file name according to its lastmodified date and download it to windows environment .
Problen is that when i use mget command it does not filter with date.besause there is several same nane file..
ex-- abc_pqr 12/29/2010
abc_pqr 12/24/2010
abc_pqr 12/25/2010
I want a perticular file from ftp server of abc_pqr 12/24/2010 date. Please help

More replies
Relevance 80.36%

I have a small spreadsheet which I use to track my vacation and sicks days. Currently I use conditional formatting to hide each weeks data until the end of the pay period. The one thing I haven't been able to figure, though, is how to prevent a =SUM formula from executing until a specific date is reached. I'd like to end my vacation days early, but when I do the formula kicks in and immediately adjust my totals, rather than waiting until the pay period is over.
EX: If I enter any values in columns C:M, the formula in column Q immediately deducts the amount from Q30. Thanks for any assistance you can provide.
 

Answer:Execute formula on specific date

Your sheet pretty does what you says for Q30.
Btw, what is your excel version?
 

2 more replies
Relevance 80.36%

I have a list of unique numbers. I also have a formula (or function) that when a number is entered in a specified cell, the list is searched and the address of the cell adjacent to the one containing the number is returned. For instance, if 12345 is entered and it is in cell A649, then $B$649 is returned. I want to write today() in that cell. How do I do it?

Answer:I want to write a date to a specific cell

You want to replace whatever is in B649 with =TODAY()?Why?Are you aware that =TODAY() is Volatile and will update every time the sheet calculates, including every time you open and close the workbook? In other words, what is displayed in B649 today will be different tomorrow, and the next day, and the next, etc.In addition, put enough =TODAY()'s in your spreadsheet and you'll slow it down since they will all recalculate at the same time, every time.That said:1 - You can't place a value in a cell with an Excel function. An Excel function can only return a value in the cell in which it resides.If you want to place a value (or function) in a cell via some "automatic" method, you'll need to use VBA.2 - How are you returning a cell address? Can I assume you are already using VBA, perhaps a UDF?

3 more replies
Relevance 79.54%

Hi all,

Basically i need to create a spread sheet Cells A2-99 will have dates input into them at different stages i want to make it so if i put for example 01/01/2015 exactly 90 days after that date the cell turns red.

But all dates will be put in at different times and all dates i input will be different is this possible?

Context for this drivers have to fill in a form once every 90 days we need to keep control over this making sure this is highlighted so it can be corrected asap
 

More replies
Relevance 79.54%

Hi All
i'm newbie and as the title implies, i want to get my emails through pop3 with outlook express BUT Specific date only !!
Could anyone tell me how i can do this?
Best Regards.
 

Answer:OutLook...How to recieve only emails with specific date???

why not take them all and then delete the dates you dont want
I dont think you can set up date specific pop - I know you cant on gmail - the choice is all or from now on the pop page settings

it would be easy to sort by date on outlook express and just delete the emails

whos the email ISP with ?
 

1 more replies
Relevance 79.54%

I've done this before so I know it can be done. But for the life of me I can't remember how to run a rule in (wondows xp) outlook 2003 for a specific date.

I've made changes to some rules I have and I need to run them on email in the inbox but only for a specific date.

Any help would be greatly appreciated
 

More replies
Relevance 79.54%

Does anyone have a recommendation on Windows XP software that you can set to delete a specified folder on a specified date? Thanks for your help!
 

Answer:Software To Delete Folders On Specific Date

Assuming this is a repetitive task, the only approach I can think of is to create a script using, for example, AutoHotKey, and set that script as a scheduled task.

http://majorgeeks.com/AutoHotkey_d4422.html

http://www.autohotkey.com/
 

3 more replies
Relevance 79.54%

This is a bit tricky to explain:

I have dates along the X axis and quantities up the Y axis.

When I enter a quantity on a date I need a formula to calculate
a) 3 times the entered quantity and then again 6 times the entered value (easy)
b) for these two values to automatically land on the 6th and 12th month from the date of entry (not so easy)

I need help with (b)

I'm picturing this as an ongoing line graph with new series being added periodically.

Is this possible or am I making this unnecessarily difficult for myself?

Thanks

Corinne
 

More replies
Relevance 79.54%

The thread title says it all. I want to specify specific start and stop dates as a filter, not the general "last month" or "last year" type offered.

Any help?

EDITED: Ignore this request (I don't know how to delete it.) Reason: Modifying the filename doesn't change the Date Modified field. :-(

Answer:Can I search for Date Modified between two specific dates?

Please read this post: How to search

Kari

1 more replies
Relevance 79.54%

Accidently downloaded one unwanted software containg viruses on 30 june.. now laptop really slow and over heating problem has arrised.. want to restore my laptop to the date it was on 27 june.. need help as soon as possible..

Answer:how to restore my laptop to specific previous date?

Hi, Thank you for posting in the HP Support forum. Welcome onboard ! There is a feature called System Restore. If it is enabled, you should be able to restore to previous date. More information can be found here >> http://support.hp.com/us-en/document/c03327545 Once you complete the System Restore process and if it passes fine, it is stronly recommended that you check your computer for the presence of malware/viruses and remove them (actually, you should do it now even if System Restore fails). You can try these free tools:>> Kaspersky TDSS Killer >> http://support.kaspersky.com/viruses/disinfection/5350>> ESET online scanner >> https://www.eset.com/int/home/online-scanner/>> SurfRight SOPHOS HitmanPro >> http://www.surfright.nl/en/hitmanpro  Please, let me if this helps and how it goes.

1 more replies
Relevance 78.72%

I am trying to build an excel sheet to tell me my future manning levels, (for example, how many workers will I have 6 months from now). I attached (or at least tried to) a very small scale "example sheet" of what I am talking about. It basically will have one cell to put a start date in for which month to start gathering data. This is followed by the months following the start date going out a year. The data comes from a separate sheet and the data is based off of a column with dates that I am suppose to receive inbound and a column with dates of personnel departing. I am trying to take the month that I need the data for, count the personnel that should have arrived by that date and add it to those that have not departed by that date. Every formula that I have tried counts every cell to include the empty ones. This is the last formula that I tried =SUM(IF(Manning!$C$3:$C$14<=H3,1,0))+SUM(IF(Manning!$D$3:$D$14>=H3,1,0)). I have also tried COUNTIF formulas. How do I get it to count only the cells that have a date in it that falls with in the range? Sorry if it is confusing but hopefully the attached sheet will help explain. I am using an XP machine.
 

Answer:Solved: Using excel to count a specific date range

I put in a check to put in a ZERO if there is an empty cell.

=SUM(IF(Manning!$D$3:$D$14<=H3,IF(Manning!$D$3:$D$14="",0,1),0))+SUM(IF(Manning!$F$3:$F$14>=H3,IF(Manning!$F$3:$F$14="",0,1),0))
 

3 more replies
Relevance 78.72%

How to check user login logs in windows 7 domain environment for a specific date.

More replies
Relevance 78.72%

Can anyone help me please?I'm trying to get excel to send an automated email from outlook when a due date comes about in certain cells Desperately seeking help on this Thanks

Answer:Automated emails when cells in excel are at specific date?

Try here:http://www.rondebruin.nl/win/sectio...should give you a starting point.MIKEhttp://www.skeptic.com/

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

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%

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

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%

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%

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%

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 need to set up a query that pulls information matching a certain date of the current month and year. I'm not sure about the syntax. Someone help please?
 

Answer:Solved: Query for specific date, current month and year.

16 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'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%

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%

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 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 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 76.67%
Question: Date/Title reset

Hi Every time I boot up my computer it is loosing the date/time settings and reverting to 01/12/1999. I don't think that it is the CMOS battery. The problem started just after I ran ashampo -registry cleaner.Any advice very welcome

Answer:Date/Title reset

Have you tried a System Restore, yet, Billji. You could also try going into the BIOS and resetting from there.

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%

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%

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%

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%

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%

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%

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%

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%

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%

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%

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%

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