Over 1 million tech questions and answers.

ComboFix: Date Error

Q: ComboFix: Date Error

I work at an IT help center on a university campus. We offer virus cleanings and other general IT help to students, staff, and faculty. As part of our standard virus cleaning process, we run ComboFix. Starting yesterday, however, ComboFix will not run on any (6 or so machines) of the customers' machines we try to use it on. It stops with the error "Date Error: 2009-11-15, Check your settings."

The only way we have found to get it to run is by taking the customer's machine out from behind the firewall (done this on 3 machines so far). We have a machine running m0n0wall sitting between the switches that the customers' machines connect to and the internet. It has very stringent rules, allowing only ports 53 (DNS), 80 (HTTP), 443 (Secure HTTP), 21 (FTP), and 5722 (Jabber) outgoing.

We have also tried disconnecting the machines from the internet completely before running ComboFix, but that doesn't work either. This is odd, since ComboFix used to run just fine without an internet connection, usually in a reduced mode because the Windows Recovery Console isn't installed.

I found a version of ComboFix we downloaded 11/14/09 at 11:10am EST, and it runs OK right now (tested on 1 machine still behind the firewall).

Would anyone know if ComboFix was recently updated in a way that would cause this error if the computer has no or heavily firewalled internet connectivity?

RELEVANCY SCORE 200
Preferred Solution: ComboFix: Date Error

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

A: ComboFix: Date Error

There was a recent fix and update for ComboFix. It was taken offline for a short time and brought back up... This topic mentions the issue.. http://www.bleepingcomputer.com/forums/t/270612/broken-link-for-combofix/

Read other 4 answers
RELEVANCY SCORE 64

hello guys, i have been using combofix for sometime now with great success. I recently downloaded the latest version, but any time i want to run it, it gives me - "Date error Thur 07/09/2008 , check your settings". I have changed my date back and forth without success.
Please, I need help. Combofix is all i've got.

Read other answers
RELEVANCY SCORE 64

My daughter has managed to acquire some type of malware which behaves much like Vundo... however, since I'm a bit rusty on my skillz, I can't be exactly sure.

Description of symptoms:

Will not connect to the home network any longer, either wireless or wired. When LiveMessenger fails to connect, troubleshooting shows an invalid IP address...when I run IPCONFIG, it states there's an internal error.

AVG Anti-Virus modules will not run.

Spybot S&D will not run

Downloaded Malware Antibytes but the program will not install. The process is in Task Manager, but is "hung" and will not initiate.

Downloaded Combofix from a link in this forum. When executed, it drops to the DOS box, then comes up with Date Error. The date presented is the current, correct date, yet it states to Check Your Settings.

Ran The Comedian which gave me a valid ERUNT, but would not set a restore point.

And, last but not least, HJT will not install.

Um.. help?

A:Combofix Date Error?

Ok.. found the rename trick for MBAM... had to even go ren the exe in Program Files/Malware Antibytes folder but its currently running... we'll see.. If it works, someone may want to make a sticky out of that lil trick..

Read other 52 answers
RELEVANCY SCORE 51.6

I downloaded Combofix  from this website but it's telling me that it's out of date and will only run in reduced functionality mode.
 
Is there a newer version out there I could download.

A:Combofix Out Of Date

You downloaded it directly from our download section? I just tested and its the latest version.

Read other 7 answers
RELEVANCY SCORE 50.4

I ran Combofix last night after I finished removing the worm.win32.netsky virus. I got all the way through the Combofix process and then the system rebooted. After rebooting the blue screen cmd screen came up and it said "Please wait...." It appears that Combofix never ran a log to finish the process and I had to exit out of the program. Upon doing so I noticed that my date and time were screwed up and I can't seem to get them back to normal. I already uninstalled ComboFix by going to "Run" and typing ComboFix /u. Any idea on how I can get the date and time back to its correct format? Thanks.

A:Combofix Date/time Issue

Click Start >> Control Panel >> Regional and Language Options. Hit the "Customize" button, then click the "Time" tab, and there you can set the format of the time. There is a tab called "Date" in the same window to set the format of the date.

Read other 3 answers
RELEVANCY SCORE 47.6

I want to run combofix cause i went to a website and possible clicked on something i should not i beleive i may have a back door trojan

The error i am getting is

Windows cannot find "NircmdB.exe". make sure you typed the name correctly, and then try again.

I tried renaming to cf.exe no luck i even try using SDFix in safemode no luck when i click on runthis bat file cmd start then close so i dont know what is going on..

In the past i had vista and abale to run combofix and get rid of any virus i had . Now with window 7 i am getting this error above

Any help to run combofix would really appreciate. All i want ot do is run combofix on window 7

thanks

A:Combofix will not run on window 7 full retail version, combofix will not run error

Please note the message text in blue at the top of this forum. You should not be using Combofix unless instructed to do so by a Malware Removal Expert who can interpret the logs. It is a powerful tool intended by its creator to be "used under the guidance and supervision of an expert", NOT for private use. Combofix was never meant to be used as a general purpose malware scanner like SuperAntispyware or Malwarebytes' Anti-Malware. Using this tool incorrectly could lead to disastrous problems with your operating system such as preventing it from ever starting again. Please read Combofix's Disclaimer. That's the decision by the creator and we will abide by that decision.Further ComboFix does not officially support Windows 7 and SDFix only works on Windows XP.Please download Malwarebytes Anti-Malware (v1.40) and save it to your desktop.alternate download link 1alternate download link 2MBAM may "make changes to your registry" as part of its disinfection routine. If using other security programs that detect registry changes (ie Spybot's Teatimer), they may interfere or alert you. Temporarily disable such programs or permit them to allow the changes.Make sure you are connected to the Internet.Double-click on mbam-setup.exe to install the application.When the installation begins, follow the prompts and do not make any changes to default settings.When installation has finished, make sure you leave both of these checked:Update Malwarebytes' Anti-MalwareLaunch Malwarebytes' Anti-Malware... Read more

Read other 3 answers
RELEVANCY SCORE 42

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.

A: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.

Read other 9 answers
RELEVANCY SCORE 40

Hi,I am wondering whether combofix.net and combofix.org are GENUINE sites to download ComboFix.There's no Impressum and the whois-info is private registered.Just wanted to know.Edit: Moved topic from Am I infected? What do I do? to the more appropriate forum. ~ Animal

A:Is combofix.net and combofix.org GENUINE Site to download ComboFix?

Please Take a look here: ComboFix usage, Questions, Help? - Look hereSpecifically the link to the combofix disclaimer image. AlsoThere are only two sites that are authorized for combofix, which are shown in red in the last quote box.

Read other 3 answers
RELEVANCY SCORE 39.2

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
 

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

Read other 2 answers
RELEVANCY SCORE 39.2

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

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

Read other 4 answers
RELEVANCY SCORE 39.2

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.
 

A:error 163 time and date

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

Read other 1 answers
RELEVANCY SCORE 38.8

Hello everyone.

Here is the little bug i got, not sure if its cause by any other software or virus or trojan but here goes nothing.

My Clock/Date is switching Date every 1ms from 1990/ Wensday to 1994/Monday back and forth with the correct time.

Now this been going on for few days and i notice i got a rootkit installed on my computer, its removed corrently but this didnt go away.
 

A:Systray Clock/Date error

Please go and read this and then post a HijackThis log as an attachment into this thread. Then we can see if it's a virus/spyware or whatever that's causing the problem.

Regards
 

Read other 1 answers
RELEVANCY SCORE 38.8

Windows XP
Office 2003 SP1 with Access 97 SR2

When opening a certain Access database a user is recieving this error:
Function isn't available in expressions in query expression '(((PRODUCTION.DATECREATE)=Date())'.

This only happens on a specific computer. I've tried uninstalling and reinstalling Office, Access, I've even tried just installing Office 97. I also went through and reinstalled all the ActiveX controls that have to do with the date (MSCAL.ocx gives us trouble sometimes).

I'm not that familiar with the programming for the database, it was done quite some time before I got here, but I know enough to understand what is happening. I think the problem lies with the Date() function (this still happens as admin on her machine so it isn't a permissions error) but I have no idea how to fix it.

I remember reading something not long ago about a similar issue that had to do with differing versions of library files for VBA. I was going to try and replace the library file containing that function on her machine with one from mine, until I found that it apparently isn't stored in a file.

Any help would be greatly appreciated as I'm at my wits' end with this thing.

- Pat
 

A:Solved: Access 97 Date() Error

You opened the VBA and went to Tools-->References and made sure none say "missing"?
 

Read other 3 answers
RELEVANCY SCORE 38.8

Hi, my windows update is not working and I tried multiple times of using the Mr. fix it , but that doesn't work. Below is what shows when I try to update my system. If anyone can please help me , I would really appreciate it. Thanks
 

A:Solved: Windows up date error, please help me?!

Read other 16 answers
RELEVANCY SCORE 38.8

Hey everyone, I'm new to the site and hope to have a great stay. Not sure if I posted under the correct Thread so please forgive me.

I'm experiencing the problem above when trying to Boot up my PC, it get's stuck there. How this happened is I was fixing my friend's PC, I was failing to make it work so I took out his HDD and connected it to my PC as a Secondary Drive, hoping to run a Virus scan through it, well it didn't work. So I took it out, only to later find out that my PC no longer boots aswell..... With the above error message. Checked my Bios, everything looks normal, Primary Boot set as my HDD or DVD drive still nothing works.

I'm using Win7; 2GB RAM; P4; 80GB HDD-IDE; SATA DVD drive.... Please let me know if I left other important info.

Hope all is in order
Thanx

A:Verifying PMI Pool Date Error

  
Quote: Originally Posted by Muzimak


Hey everyone, I'm new to the site and hope to have a great stay. Not sure if I posted under the correct Thread so please forgive me.

I'm experiencing the problem above when trying to Boot up my PC, it get's stuck there. How this happened is I was fixing my friend's PC, I was failing to make it work so I took out his HDD and connected it to my PC as a Secondary Drive, hoping to run a Virus scan through it, well it didn't work. So I took it out, only to later find out that my PC no longer boots aswell..... With the above error message. Checked my Bios, everything looks normal, Primary Boot set as my HDD or DVD drive still nothing works.

I'm using Win7; 2GB RAM; P4; 80GB HDD-IDE; SATA DVD drive.... Please let me know if I left other important info.

Hope all is in order
Thanx


May be here:
Computer Hangs at"Verifying DMI Pool Data"
and here:
http://www.computerhope.com/issues/ch000474.htm

Looks you have to reset something in order to boot.

Read other 4 answers
RELEVANCY SCORE 38.8

Heya All,
This Is Very Weird.
My jobs, have totally weird icons, such as part of a music carrer in place of the busniuss carrer,
and on top of that... i installed the sims hot date, and then i got SimLifeCycle. basically like simgrowup, which allows ther sim to become an adult.. blah blah bla.
When i married a townie, This woman was wearing stuff from the medieval age, so i went ahead and changed her clothing... that worked fine.

I installed the-sim-life-cycle

Then it happened.
The girl would not get out of bed, unless told to... (nearly starved to death) and lol... The only option for the sim to do with a dresser, was to 'change clothes' i don't really kno what has happened, but it seems as though that program stuffed it... or is it the fact i havn't got the patch yet?
 

A:VERY Weird Error On The Sims Hot Date

I would try completely uninstalling the sims then reinstalling it all again. If that doesnt work, then the patch would be the next step.
 

Read other 2 answers
RELEVANCY SCORE 38.8

Hi Guys,

Anyone encounter this error problem while changing the date format ?

Error :-

One or more of the characters you typed in this field are invalid.
Try typing different characters

Using administrator right i have no problem changing the date format.
If i use my profile i cannot change even i got the access right same as admin..

what is wrong over here ?

Thanx for the help.
 

A:Error while changing Date Format !!

Could be a corrupt user profile. Try creating a new profile and copy data from the corrupt profile to the new.

Info: http://support.microsoft.com/kb/811151
 

Read other 1 answers
RELEVANCY SCORE 38.8

I seem to be caught in a confusing circle.  I keep getting an error message that my browser is out of date and that I need to upgrade to the latest version.  However, whether I hit the "Download and install" prompt for Chrome,
Firefox, or Internet Explorer, it asks me if I want to run the download, but then nothung happens.  When I check my download folder, none of these browser options appear.

My problem started because my computer was being bogged down despite having Norton Security installed.  In desperation, I did a restore, but now am really in a bind.

Read other answers
RELEVANCY SCORE 38.8

I seem to be caught in a confusing circle.  I keep getting an error message that my browser is out of date and that I need to upgrade to the latest version.  However, whether I hit the "Download and install" prompt for Chrome,
Firefox, or Internet Explorer, it asks me if I want to run the download, but then nothung happens.  When I check my download folder, none of these browser options appear.

My problem started because my computer was being bogged down despite having Norton Security installed.  In desperation, I did a restore, but now am really in a bind.

Read other answers
RELEVANCY SCORE 38.8

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

Read other answers
RELEVANCY SCORE 38.8

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

Read other answers
RELEVANCY SCORE 38.8

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

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

Read other 16 answers
RELEVANCY SCORE 38.8

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?

A: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.

Read other 2 answers
RELEVANCY SCORE 38.8

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.  

Read other answers
RELEVANCY SCORE 38.8

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.
 

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

Read other 10 answers
RELEVANCY SCORE 38.8

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!
 

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

Read other 16 answers
RELEVANCY SCORE 38.8

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?

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

Read other 8 answers
RELEVANCY SCORE 38.8

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

A: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.

Read other 1 answers
RELEVANCY SCORE 38.8

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!
 

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

Read other 7 answers
RELEVANCY SCORE 38.8

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.
 

A: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.
 

Read other 1 answers
RELEVANCY SCORE 38.8

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
 

A: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?
 

Read other 3 answers
RELEVANCY SCORE 38.8

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

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

Read other 9 answers
RELEVANCY SCORE 38.8

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

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

Hi Steven,
 
Thanks for the post!
 
When you set the Short date to ddd dd/MM/yyyy, the date by the clock is shown with slash, however, the date in Task Scheduler doesn’t show the slash. This behavior
is by design. When you double click the time and the trigger tab (for example) in task scheduler, the details are shown with slash.
 
When you change the Short date to dd/MM/yy, the date in the Task Scheduler and the clock become the same.
 
For the Excel date problems, I recommend you ask this question in
Office Forum.
 
The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and
other communities who read the forums regularly can either share their knowledge or learn from your interaction with us. 

 
Thanks for your understanding and cooperation!
 
Best Regards,
Miya Yao
 This posting is provided "AS IS" with no warranties, and confers no rights. | Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer
your question. This can be beneficial to other community members reading the thread.

Read other 5 answers
RELEVANCY SCORE 38.4

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.

A:error 2701 time and date settings

Hello Rose,

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

Read other 1 answers
RELEVANCY SCORE 38.4

Hi everyone,I'm having trouble with another friend's computer, Compaq Presario R4000, XP SP2. She stated that one day she tried to start the computer and it would briefly start and then shutdown. I was able to get past this problem. Now when it starts, there is a 'Notification dll has not been registered, program will not work correctly' message and 'HP Wireless Assistant is not supported on this machine'. I tried installing MBAM and received error messages upon installation and the vbalsgrid6.ocx message when trying to run the program. The following programs have also been run:Avira A/V disk - no viruses foundAVG 8.0.176 - no viruses founddrweb-cureit - found and deleted a few itemsfixacl.exe - aclreset.txt created, but save to C:\aclreset.txt and access is denied (even when trying to copy using the cmd prompt).FixPolices.exe ? pops up, but nothing changes.subinacl.msi - couldn't run, Windows Installer.Dial-a-fix ? select ?Policies? to run, ?no restrictive policies were found?.HJT (had to change the name) - log is below.dds.scr ? attached attach.txtI also pulled the hd and place it in an external case to run AVG and MBAM, both showed the drive as clean. One last thing, the paste function is disabled. I can only copy/paste from within the cmd prompt.********************Logfile of Trend Micro HijackThis v2.0.2Scan saved at 9:03:06 PM, on 2/8/2009Platform: Windows XP SP2 (WinNT 5.01.2600)MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180)Boot mode: NormalRunning pro... Read more

A:MBAM error message, vbalsgrid6.ocx is out of date

I was able to access the aclreset.txt by logging into Safe Mode as the Administrator. Here are the first 3 lines from the file.

HKEY_CLASSES_ROOT\CLSID\{d5bf49a2-94f1-42bd-f434-3604812c807d} : 2 The system cannot find the file specified.

HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{D5BF49A2-94F1-42BD-F434-3604812C807D}\InProcServer32 : 2 The system cannot find the file specified.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\Browser : 2 The system cannot find the file specified.

Read other 16 answers
RELEVANCY SCORE 38.4

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?
 

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

Read other 3 answers
RELEVANCY SCORE 38.4

Why me? The devil is out to get me!

Range("b72").Select
ActiveCell.FormulaR1C1 = InputBox("Inv date")

Changed regional OS settings couple times, rebooted, formatted B72, checked date function in cmd,
everything kosher. When entering directly into the cell date format comes up right, but not when using the above inputbox.

Australia dd/mm/yy format is what I require but using input box like 5/2 (day/month/year) I get mm/dd/yy. If I type 12 feb comes up correct. What the ....?

Has anyone else come across this problem before? My computer? Excel misfiring? OS crook?
 

Read other answers
RELEVANCY SCORE 38.4

Hi,

I have a laptop Dell Inspiron E1505 and I have had many problems since I re install windows. Originally, my computer has Windows media player, and I switch it to WinXP. Now, I do not have any sound. I just can listen some songs I think that depends on how high is the original sound..... but the problem is when I tried to listen something after a couple of seconds the computer turn into a blue screen with a Kernel Data error. I've tried many times to figure out this situation, but it does not work out even re-installing winxp.....

When I am listening something, I loose control of my computer for a moment and then turns blue..... but if I allow "mute" from the main screen, I can watch videos, but I cannot listen anything....

I think that this is a problem of the decibels, as higher is the sound of the song, I can listen it for a while and then, the computer is "out of order" with a blue sign... I can take a picture of this screen and send it to you if you need... Please SOS I cannot survive no listen any music!!!!

Anybody who can help me.. please SOS...

Ralph.
 

Read other answers
RELEVANCY SCORE 38.4

Hi guys,
My Laptop Inspiron 1525,Windows 7Ultimate,32 bit,started to display an out- of-date error frequently ,When I adjust the date and time  setting in the BIOS ,the problem again appears on the next day.Would anyone suggest a remedy for this problem.
Regards

A:BIOS error(out of date) frequent message

Hi TARMOH,
Are you using an original Dell OEM Adapter? Is the adapter frayed? Could you test with another power adapter if possible? 
Restart the system and press f2 key to enter BIOS - check the adapter status in BIOS with and without the adapter plugged in. Also, wiggle the adapter cable at the end and see if the status changes in BIOS at any point. Check the battery health in BIOS (if applicable).
If possible, update / flash the BIOS - http://dell.to/2dcAKFq
Restart and enter BIOS and reset defaults - save and exit and check again. Also, ensure the time in Windows is set to current local time and date.
If the issue is still unresolved, then download the service manual here - http://dell.to/2cEg4VT - and reseat the cmos battery and check.
If it still does not work, then replace the CMOS battery, you would need this part - http://bit.ly/2cOxWuM
If the issue stands unresolved, then you would need to replace the motherboard. 
Personally, I would suggest you to invest your money on a new machine than to repair this old system.
Also, please click my DELL-username and write me a private conversation with the service tag and your contact details(Name and Email) for case records.
Let us know if you have any other queries.

Read other 2 answers
RELEVANCY SCORE 38.4

Hey everyone,

After a recent vista os reinstall, I noticed that when I use the "date modified" sorting option files that I have recently downloaded or created refer to a much older date. I use date modified to easily tell which of my files are more recent, but after this "bug" I cannot do so anymore. However, the "date created" sorting option recognizes new files by their date, but still is not as accurate as my previous working date modified option. I would appreciate any help regarding this problem!

Thanks in advance.

A:[SOLVED] Date Modified Setting Error

Hi -

What "bug" are you referring to?

Since re-install, have you re-validated your Vista installation with Microsoft Genuine Advantage? Here is MS page - validation button is on left 1/2 way down.

http://www.microsoft.com/genuine/

Regards. . .

jcgriff2

.

Read other 5 answers
RELEVANCY SCORE 38.4

I get a Counter-strike executable out of date error when i try to play CS,HL or ANY half life mod. I have formatted windows and reinstalled eveyrthing all over and still get the error. I have never installed a cheat program, but I have used tweaks like ex_interp,maxerrordistance,cmupdrate and blah blah.In fact I started getting this error after a month of not playing CS or even using my computer for gaming. I asked a friend to send me his HL.exe and I was able to play. Once i left the server and tried playing later that day I got the error again. My friends HL.exe was smaller than the one giving me errors. Does anyone know how to fix this problem? reply or contact me on Aol Instant Messanger (iicucumbaii). Please help a desprate CS player in need! =).
 

A:CS incorrect Executable error,with up to date patches..

Read other 11 answers
RELEVANCY SCORE 38.4

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

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

Read other 6 answers
RELEVANCY SCORE 38.4

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

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

Read other 2 answers
RELEVANCY SCORE 38.4

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!
 

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

Read other 7 answers
RELEVANCY SCORE 38.4

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?
 

A:Solved: Access - Convert Date Time to Date

Read other 10 answers