Computer Support Forum

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

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

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

Relevance 100%
Preferred Solution: Taskbar Time / Date area quit expanding to fit desired date format

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

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

On my XPS 15 (L502X) I'd like to widen the day and date area so that the day and date fit on one line. For instance, for today, I'd like it to display "Friday/09/16/2016." I have made this change in settings, and when I hover the mouse over that area, the display is correct. But because the display area isn't wide enough, it otherwise shows only the time. This works fine on my desktop PC--plenty of room there. I don't want to increase the taskbar height. I want only to widen the day/time/date area to accommodate the day and date on one line. So how do I widen the day and date area on my laptop? Thanks.

More replies
Relevance 84.68%

XPPausing my mouse pointer over the time (task bar RH corner) used to give me the current date in the format DDMMYY. For some reason it now displays the date in the format YYMMDD ie. 07-11-16. Any way to change this ?

Answer:Pop up Date format behind taskbar time.

Check the settings in Control Panel > Regional and Language Options.

1 more replies
Relevance 104.96%

Since installing Windows 10 - previously on Windows 7 - all dates in Excel have turned into the American date format i.e. previously 12/08/15 in a cell displayed as 12th August 2015. Now it displays correctly but the cell contents have changed, so, in previous example, the cell now contains 08/12/15. How can I put this right? I have gone into anything I could see re language and have ensured it is English (United Kingdom) but this hasn't made any difference.

Answer:Windows 10 has turned my British date format in Excel into the American date format. How can I get it to turn back?

Freeeeeeeeeeeeedom!

10 more replies
Relevance 98.4%

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

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

Although I have "Use Small Icons" UNticked & a screen resolution of 1280 x 1024, I find the notification area and the date/time display rather small (yes, my eyesight is NOT that brilliant!!). I do NOT want to switch screen resolution, but would like these items larger. Any ideas please, anyone?

Answer:Notification area icons and date/time font sizes

Why don't you take a look at some of the many 3rd party date/time apps that are available?

Also, some of your system's font size settings are directly affecting the font size of your date and time display.

As another person who prefers (and needs) larger fonts and images, I'm happy to share my list of settings with you. As you go through them, you'll see which one(s) affect the time and date display:

1. Fonts - Change - This is the one of the main setting tools for setting various locations of Windows font sizes. Right-click on the Desktop and go to Personalize, Window Color and Appearance. Click on Advanced, and in the drop-down menu, select the item that controls the location where you wish to change the font size. (Note: the last one, Window, does not have an option to control font size.)

2. DPI - How to Change the Display DPI Size in Windows 7
Right click on Desktop, Personalize, On Personalization Page, (OR go to Start Menu, Control Panel, Display, and in left column select Custom DPI setting.) go to left column to: Adjust Font size ? DPI, DPI Scaling: Click on Large scale (120 DPI), and click Apply. OR Click ?Set custom text size (DPI)? in the left pane to customize the text size and drag the ruler with your mouse to increase or decrease the percentage.

3. Screen Resolution - TechTalkz.com Technology & Computer Troubleshooting Forums > Operating Systems > Windows 7 ? Guide to How to Change Font Size + Icon Size

Right-click on the Desktop, choo... Read more

9 more replies
Relevance 97.58%

Hello all

i would like to have Date+Time displayed in the taskbar (i know that i can use large font,resize taskbar etc etc and dont want to use those solutions or any other 3rd party app just to be clear)

On my windows 7 i could achieve this by using Windows Styles builder then open the relevant theme end edit the required resource (namely Clock Font from size 11 i think, down to 9 or 8) and thus i could see both the time and the date without using large fonts or resizing the taskbar.

Tried the same method with windows 10 Pro X64 A.U this method appears not to work anymore.

any suggestions are welcome

Answer:Help with Date+Time in taskbar

Am I misunderstanding something? All my Windows 10 machines show both time and date in Taskbar. I have normally vertical Taskbar at left but when testing this just now, moving Taskbar to default position and size, I get this:
Having taskbar at left (or right) I even get day of the week:

9 more replies
Relevance 97.58%

I asked how to put back date and time on taskbar.  They told me to right click on taskbar and look for Properties.  I did that but no Properties is showing 

More replies
Relevance 97.58%

I could not find this in MG, so have submitted it for their consideration / inclusion.

Do a google search for TclockEx. Latest version is around v1.4.2

I am not posting a link, so as not to plug another download site.

It works fine on XP and W98SE, that I have tried it on.

Bazza
 

Answer:Add day and date to the time in your taskbar

Fantastic! Just put it on my work computer (98SE), see how it does before I use it on XP.

Has quite a few functions, Thank's Bazza.

Steve
 

10 more replies
Relevance 97.58%

I asked how to put back date and time on taskbar.  They told me to right click on taskbar and look for Properties.  I did that, but no Properties is showing on the list.  I have Windows 10

More replies
Relevance 97.58%

Hello all

i would like to have Date+Time displayed in the taskbar (i know that i can use large font,resize taskbar etc etc and dont want to use those solutions or any other 3rd party app just to be clear)

On my windows 7 i could achieve this by using Windows Styles builder then open the relevant theme end edit the required resource (namely Clock Font from size 11 i think, down to 9 or 8) and thus i could see both the time and the date without using large fonts or resizing the taskbar.

Tried the same method with windows 10 Pro X64 A.U this method appears not to work anymore.

any suggestions are welcome

Answer:Help with Date+Time in taskbar

Am I misunderstanding something? All my Windows 10 machines show both time and date in Taskbar. I have normally vertical Taskbar at left but when testing this just now, moving Taskbar to default position and size, I get this:
Having taskbar at left (or right) I even get day of the week:

2 more replies
Relevance 97.58%
Question: time/date/taskbar

can u get the day to be displayed on bar.

Answer:time/date/taskbar

click here

3 more replies
Relevance 97.17%

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

Hello, I found this problem extremely annoying and there was no answer on all the message boards that worked, so when I solved it I wanted to let people know how to fix it. Just go to your screen resolution, lower it, hit apply. You'll notice your taskbar fixes itself, then go change your resolution back up again.If for some reason that doesn't work you can download a date & time software for your taskbar. These are sure solutions beyond that Control Panel-Regional Date & Time settings thing.Regards,Skye

Answer:Date & Time on Taskbar Would like 2 Lines Only!

Thank you for posting. It is surprising how many niggling little issues can be fixed on computers by re-applying settings.Always pop back and let us know the outcome - thanks

2 more replies
Relevance 96.35%

Hello all:
I know that I can hide the date in the taskbar by checking "use small icons" in the taskbar properties dialog, but it still shows the time. Is there a way to hide both the date and time in the taskbar? I've looked all over the web, but all of the little apps on offer don't seem quite legit.

Any ideas?

Answer:Hide Time & Date In Taskbar

Hi siouxdax,

Right-click your taskbar and click 'Properties'. On the Taskbar and Start Menu Properties window, under Notification area click 'Customize...'. Click 'Turn system icons on or off' and look for Clock and its corresponding drop down menu. From there, choose OFF, and click OK.

System Icons - Turn On or Off

Hope this helps.

4 more replies
Relevance 96.35%

Hello,

i just restarted my computer, did not install anything new and the taskbar now does not show date or time. I tried to increase the size of the taskbar to 3 rows but it still does not show date and time. I have checked the properties and notifications centre and restored them to default. But when i move the mouse to where the time is supposed to be and right click , i can see the time/date properties. I have also checked them nothnig unusual there. I have restored to default wherever possible.In the porperties, it says show clock , i have checked that. but ot no avail.

Help !

Answer:Time and Date not visible in Taskbar

Hello noofr, and welcome to Seven Forums.

Please go ahead and post back with a screenshot showing the clock area on your taskbar to see if that may be able to help ID what the issue may be.

Screenshots and Files - Upload and Post in Seven Forums

7 more replies
Relevance 96.35%

Noticed on a browser picture submitted by another member that the task-bar displays the time and date. Mine only displays the time.

Is this a windows 7 option I can turn on? Looked in properties but could not find out how.

Answer:How to show time and date on taskbar?

Hello Manuel,

You can get the time and date by setting the "Short date" format using dd-MMM-yy as below.

Date Format for Taskbar System Tray - Show Full Day and Month Names



Hope this helps,
Shawn

9 more replies
Relevance 96.35%

Unable to easily see date hidden behind XP taskbar found this great freeware utility displaying day/date/hrs:mins:secsclick here

Answer:Show day,date and time in XP taskbar

or free desktop clockclick here

7 more replies
Relevance 96.35%

I upgraded like everyone else in July and my laptop is working perfectly however my desktop is having the problems.
When I go to where the date and time is and left-click on it nothing happens. If I right click it will give me the options to adjust date/time etc.. But what I want to fix is when I left-click there the time/calendar to open.
Has anyone else experienced this issue? And is there a fix for it?

Answer:Date/Time will not open in taskbar

maddog65 said:

I upgraded like everyone else in July and my laptop is working perfectly however my desktop is having the problems.
When I go to where the date and time is and left-click on it nothing happens. If I right click it will give me the options to adjust date/time etc.. But what I want to fix is when I left-click there the time/calendar to open.
Has anyone else experienced this issue? And is there a fix for it?



Yes, I am experiencing this problem too

2 more replies
Relevance 96.35%

I see that the time is displayed but in spite of setting date it does not show on the taskbar, what am I not doing or doing wrong?

Thanks for responding

Answer:How do i get the OS to show both date and time on the taskbar?

If you would like the date in the System Tray along with the time, right-click on the Taskbar (ensure that Lock the Taskbar is deselected) then drag the top edge of the Taskbar upward until it snaps to twice its normal height. The clock displays three lines rather than one, showing the current time, the day of the week, and the current date.

9 more replies
Relevance 96.35%

(At least the Recycle Bin can be removed without a registry edit hack. These have always been my top 2 peeves of Windows.)

How please.

From the desktop view I simply want to look down and to the right to see the ?Sunday, September 8, 2013 ? 2:17PM? I see now ... but have to move my mouse over there and hover over it first. Why would I want to have to do that?

It wasn't possible in XP (that I know of) ? not without having to expand your taskbar to twice the width. (And let's face it, there is nothing quite as intimidating as a big huge fat thick taskbar.)

Answer:How to change desktop taskbar time to date+time?

Hello Win8fait,

If you like, you could use the method in the tutorial below to show the full date and time on your taskbar.

Date Format for Taskbar System Tray - Show Full Day and Month Names - Windows 7 Help Forums

Hope this helps,
Shawn

16 more replies
Relevance 95.94%

Hello, I'm new here. Just starting with a question re the event log of Windows 7:

In what format are date and time of logged events in .evtx files? How can I find and translate them when I look at the file content with a hex viewer? (File seems to be corrupt. Can't open it with the Windows event viewer.)

Thanks in advance!

Answer:event log: format of date and time

  
Quote: Originally Posted by tripleclick


Hello, I'm new here. Just starting with a question re the event log of Windows 7:

In what format are date and time of logged events in .evtx files? How can I find and translate them when I look at the file content with a hex viewer? (File seems to be corrupt. Can't open it with the Windows event viewer.)

Thanks in advance!


Welcome to SevenForums.

Let Win 7 open your .evtx files. The default is Event Viewer.

The average user will be using Event Viewer to view the event logs.

True, with a healthy work in time, you can learn to use PowerShell to extract and parse event logs.

I use a powershell script to clear all of my event logs - not for the space savings but to make the job of separating the wheat from the chaff easier.

9 more replies
Relevance 95.94%

Hi
I want change format Time& Date but when i change country to a format special for example English (united state) after click OK button at once return to previous format
help me!

Answer:Not Change Format Time & Date

Time Format - Change

Date Format - Change

Date and Time - Change

Format Regional Language - Change

1 more replies
Relevance 95.94%

Using Windows 8 Pro (RTM)
Seems like the calendar app does not obey the language settings.
W8 display language is English (US I think) and that is the way I want it even if I want day names and time format as choosen in language settings.

Hints ?

Answer:Calendar app time/date format

Hi eager2008. Welcome to the forum.

Right click the app -> Uninstall

Reboot.

Open Store (tile) -> Mouse curser to upper right (Charms menu for store app slides out) -> Find (magnifying glass) -> type calendar. It will bring up the app to install again.

Please let us know if that works or not. Good luck.

14 more replies
Relevance 95.53%

I turned on my computer and the entire bar on the bottom is gone.  I tried properties but the only thing that shows under general is okay, cancel and apply. I checked the certificates but nothing under that link has anything to do with the bottom
taskbar.  Any advice?

More replies
Relevance 95.53%

Hello Windows 8 Forum Communities,

I appologize if there is already a thread with this information. I searched for one first, but got frustrated when I couldn't find one with in 10-15 minutes (maybe I'm searching wrong). Either way, the other day I accidentally removed the date and time from the bottom right hand corner of the Windows 8 taskbar. I did this when i was trying to set the time from the Windows defaulted US Pacific Time to US Eastern Standard Time. I can not figure out how to get it back on the taskbar. Any help would be greatly appreciated. Also if anyone knows why my Java location on my computer is saying that it is "corrupted". I think it is related to Windows 8 upgrade.

Again apologies if there are already established links for this content. I simply couldn't find them.

Thanks Again

jtfrizzy

Answer:Accidentally removed Date and Time from taskbar Help

My java quit working on Win 8 Pro so I uninstalled it.

see 3 pictures about clock ( view from bottom to top.) ---

System Icons - Turn On or Off - Windows 7 Support Forums

1 more replies
Relevance 95.53%

I run Windows 7 (64-bit) and miss the date showing as with XP. How does one get the date to show?

I have the "gadget" but that only shows when the desktop is naked. When I fill the screen with a window, you can't see the gadget.
 

Answer:Solved: Displaying date along with time on Taskbar

13 more replies
Relevance 95.53%

With Windows Ultimate, I can have the date and time in the taskbar, both small - so don't take up much space.But on another PC using Windows Home, I can only get Time and Date to show in the Taskbar if I drag it down so its very wide.I can't get the Date and Time to be small and fill in the normal space - small size.Any way to do this?Thanks

Answer:Show Time and Date in Windows 7 Taskbar

Right-click Start button and click Properties.Click Taskbar tab and uncheck Show small icons.Click Apply button and exit.CoolGuy

3 more replies
Relevance 95.53%

Hi guys, I've been having this problem for a few days now. It isn't major in itself but after some research of what the cause might be, although I'm skeptical of it, I'm wary of what no action may lead to in the long run.

Problem
My taskbar date & time is acting up. The time is cycling around in the same hour, that hour being whatever hour I last set it to in an attempt to set it on course again (now it is 11pm). To be clear it doesn't advance onto the next hour once it reaches it, it just cycles back to the beginning of what it was before. Because of this the date is not advancing either.

Possible Cause
After doing some research I've seen a lot of people suggest that the CMOS battery may be dying. Due to the volume of people suggesting this I would have reason to believe this is the case.

Skepticism of Possible Cause
However, I've just recently built myself a new PC (the one I'm having this issue with). Everything was sound during the build and everything ran smoothly when I turned it on. I bought a completely new motherboard (Asus Maximus VI Hero - hell of a name), so I find it hard to believe the battery is already dying.

I filled out my specs when I joined up, there may be a way for you to access them but here they are anyway, my C drive is an SSD:
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i7-4770 CPU @ 3.40GHz, Intel64 Family 6 Model 60 Stepping 3
Processor Count: 8
RA... Read more

Answer:Taskbar date & time is slow/stuck

Battery as you've been told.
For the minor cost, it is not worth wasting the time and effort not doing it first.
 

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

Hello,
I'm setting up a database and have several date/time fields, which I'd like to have in a custom format - Short Date (UK) plus Short Time format, with a hyphen separating.

I'm trying the Input Mask:
00/00/00" - "00:00

I also tried editing the Date Format to:
dd/mm/yy - hh:nn

But either option (or both) gives me an error message that "The value you entered isn't valid for this field".
I've tried a couple of variations, but I'm evidently missing the principle of how this works.

I'm sure I've done this before, but can't remember how to fix it - oh, and I can't really mess with the PC's regional settings.

Thanks
Gram123
 

Answer:MS Access 2002 Date and Time format

Sorry I cannot work out how to do it either. I can suggest that you use seperate fields to
input the date and time if you have to input them, why not just use the system time?
 

3 more replies
Relevance 95.12%

I run a query for a quarterly report that has 8 fields, 2 of which are dates. The dates have to be in the mm/dd/yyyy format. When I run the query everything displays correctly. when I save the data to a table everything displays correctly. However, when I export it to a comma delimited txt file, the time also displays: mm/dd/yyyy 00:00:00. I checked the formatting for the 2 date fields, and they are both the 'Short Date' format with an Input Mask of 99/99/9999;0;" ". I also tried using other placeholders, which didn't work.

I can get rid of the 00:00:00 if I export it as a tab deliminated file, but then I lose the commas, which are a requirement. The report has to be a .txt file, with strings wrapped in quotation marks, dates (no time) in the mm/dd/yyyy format, and fields separated by commas with no spaces in between.

Are there any other places I should try to change the format, or tricks to make sure the date and only the date print? Or is it an Access glitch and I need to do a re-install? Thanks for any help.
 

Answer:Access 2K Date/Time Format problem

Add a column using the expression left([date],10) and export the query.
 

1 more replies
Relevance 95.12%

My DAQ system outputs the time and date for each data point collected in the first column along with the various signals in other columns, and I have at least 4k data points in each column. Time and data is given as shown below.11:54:23:11 - 23 MAY 1011:54:38:11 - 23 MAY 10I am trying to extract the time diference between the two data points by subracting the info in two cells, and obviously Excel does not recognize the info in the cell because of the presence of ":11" after hh:mm:ss info.How would I delete ":11" from the column and convert the given info to a Excel readable time/date format so that info in two cells could be subtracted to get the time difference.Thanks

Answer:Time and Date Format in Excel 2007

Are the Time & Date together in one cell?If the times are in there own cells, then Custom Format as:[h]:mm:ss.00This will allow you to keep the full time.MIKEhttp://www.skeptic.com/

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

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

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

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

3 more replies
Relevance 94.71%

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

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

I need just the 2/11/12

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

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

Any suggestions?
 

Answer:Solved: Access - Convert Date Time to Date

10 more replies
Relevance 94.71%

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

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

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

OK, I've done the settings for the time & date. However, no matter how wide I make the Taskbar, the short form continues to be shown. In Windows 7, when the Taskbar was widened, the long form would be shown. Is there something I need to do here? Or is this YET ANOTHER BUG?

Answer:How to get the Taskbar to show the long form of the time & date?

Date and Time Format - Change in Windows 8

Try that out.

9 more replies
Relevance 93.89%

Should be a simple one I reckon but I can't figure it out - how can I change the way that the date/time is displayed next to my received messages in outlook express 6. Currently it is shown as month/day/year. can I change that to day/month/year?Many thanks.

Answer:Outlook Express 6 - change time/date format?

click here

4 more replies
Relevance 93.89%

Is it possible to add space(s) between the date and the time?
i.e. instead of 19/06/2012 16:55, I'd prefer: 19/06/2012 *** 16:55

(* = Space. The editor is removing the spaces).

Thank you.
 

More replies
Relevance 93.89%

Hello

Using NotePad, I could enter the time and date using the <F5> function key. The format display is:

HH:MM:SS YYYYMMdd

Is it possible to change it do the date came before the time

YYYYMMdd HH:MM:SS

Martin

Answer:Using NotePad, change the behavior of the date time format

Hello Martin,

You might see if these tutorials may help.

Date Format - Change

Time Format - Change


Hope this helps,
Shawn

5 more replies
Relevance 93.48%

Right now, and for no apparent reason, when I click on the task bar on the start menu, the search function or the date/time, nothing happens....

This first appeared during a background Windows update (I realized later, during reboot, that Windows was updating. I was in a hurry for something I was doing on the Web and had to wait endlessly for Windows to be done with updating... Call me crazy, I've always thought that my PC should at least ask for permission, for proceeding with such things...)

Trully, I have nothing but issues, from day 1. My co-worker re-installed W7 immediately, after he played a little with W10 (and realized, among other things, W10 would not work with his printer) but I thought, I'll insist. And all I'm doing these days, is insisting...

Answer:Start button, search and date/time on the taskbar don't work

( I'm following some troubleshooting I found on the Web, right now )

3 more replies
Relevance 93.07%

I imported data from another program into Excel and it is giving me the date and time in this format:10012015 01:40I need it to look like this:10/01/2015 01:40The data is in Cell R72. When I use the formula below, it comes up as 8/15/03 1:40 instead of 10/01/2015 01:40.=DATE(MID(R72,1,4),MID(R72,5,2),MID(R72,7,2))+TIME(MID(R72,10,2),RIGHT(R72,2),0)Any help would be appreciated!message edited by rajasperson

Answer:Convert text string to Date and Time format in Excel

Try this:=DATE(MID(R72,5,4),LEFT(R72,2),MID(R72,3,2))+TIMEVALUE(RIGHT(R72,5))The syntax for the DATE() Function is: =DATE(Year , Month , Day)The Year starts at the 5th Character and is 4 Characters longFor the Month we get the First Two characters from the LEFT() side of the text string.For the Day we start at the 3rd Character and get 2 characters.MIKEhttp://www.skeptic.com/message edited by mmcconaghy

3 more replies
Relevance 93.07%

Hi, All,I have recently installed Format Factory and am very happy with it except for one thing: It stamps the wrong date and time on every converted file. I've had no response from their support e-mail. Does anyone have any suggestions on how to correct this?Ted.

Answer:Format Factory has wrong date & time on converted file.

Which date are you referring to. A file has three dates associated with it. Created date, modified date and accessed date. They can all be different. What format factory is probably doing is changing the creation date while leaving the accessed and/or midifed date the same or some other permutation.Be careful though as you can have a created date that is later than the modified date. There is a perfectly logical reason for this as the created date is the date it was created on that particular computer although it may have been modified at an earlier date on another computer.Stuart

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

Hello allIs there anyway that I can type in a date like: 010199 and it then gets recognized as a date format and displays it as 01-01-1999 ?I can do it the other way around, if I type 01-01-1999 and have modified the date format to be ddmmyy, it works, but somehow it doesnt work the other way around.Any ideas for this? I know it is possible to make it happen by using another column and the number 010199 then gets converted to 01-01-1999, but I need this to be done automaticly (and with no macros)Thanks in advance/Jacob

Answer:Date format when typing the date?

Where are you typing this address - presumably in an Excel column?

6 more replies
Relevance 84.46%

date/time format using d hh:mm How to suppress 0 days?

Answer:Excel date/time format as days hh:mm and suppress 0 days

As far as I can tell, there is no way to suppress the Zero using that Custom Format.You could probably process the data and remove the Zero but you will need either a formula or VBA.Is this the result of a calculation?MIKEhttp://www.skeptic.com/

2 more replies
Relevance 82.82%

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows XP Home Edition, Service Pack 3, v.3264, 32 bit
Processor: Intel Pentium III Xeon processor, x86 Family 6 Model 23 Stepping 10
Processor Count: 2
RAM: 1981 Mb
Graphics Card: Intel(R) G41 Express Chipset, 256 Mb
Hard Drives: C: Total - 39989 MB, Free - 5211 MB; D: Total - 36294 MB, Free - 8687 MB;
Motherboard: ECS, G41T-M
Antivirus: PC Cleaner Pro, Updated: Yes, On-Demand Scanner: Disabled

Hi All
Im using the attached vba code and would like to use the "title" format function to show the date of the day in the User Form, is it possible and is there any help on this matter.

Thanks in advance
Rusty
 

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

I am setting up a spreadsheet for the year and want to use it year over year. I have the cell set up with the date (1/1/2011) with a format of d so that it displays the date as Sat, 1/2/2011 - Sun, etc. Since I want to use this year after year with minimal work and I want to highlight the cells that are equal to Sat and Sun, how would I set up that formula. I tried the basic =A1="Sat" and without quotes but it just returns #NAME. I know working with dates in formulas is different but can't figure out what I need to use.
 

Answer:Solved: Excel 2007: conditional format when date displayed as format d

8 more replies
Relevance 80.36%

I have a spreadsheet with a date row on the top of the page. For some columns (i.e. dates) there are other dates appearing other than what I type in there. I have tried clear all but the erroneous dates continue to appear. Please advise.

Answer:there are extra numbers in date area

Sunday as 1 through to Saturday as 7Do you have any Macros running?MIKEhttp://www.skeptic.com/

7 more replies
Relevance 80.36%

Hi, I have strange problem. Today's date is now missing from my notify area. I found this problem either in x86 and x64 version on home and work pc, so I think maybe some windows update can do this. I try search solution on google, but no luck. I even had doubts if there was a date information on my taskbar, but I found my old desktop screenshots and date was there. Thanks for any help.

(screnshot: old state vs. new state (date and name of day only))

More replies
Relevance 79.54%

I am working on creating a identifier for my data but when I enter in the formula into Excel 2010, the results are not appearing as I expected.Here is my formula: =A2&(LEFT(C2,3))&LEFT(B2,3)&LEFT(F2,1)where the cell A2 contains the date 11/23/1982However, in the results, it is appearing as 30278.The most frustrating part is I did the same formula in another spreadsheet and it worked as expected! The dates in that spreadsheet showed in the date format. Unfortunately, I did not save the other spreadsheet since that was just a draft to get the identifier.message edited by luthientinuviel

Answer:Formula is returning the text format instead of date format

Untested...=TEXT(A2,"m/d/y") & the rest of your stuffor=DATE(MONTH(A2)&"/"&DAY(A2)&"/"&YEAR(A2)) & the rest of your stuffClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.message edited by DerbyDad03

6 more replies
Relevance 78.72%

On my laptop I'd like to widen the day and date area so that the day and date fit on one line. For instance, for today, I'd like it to display "Thursday/09/15/2016." I have made this change in settings, and when I hover the mouse over that area, the display is correct. But because the display area is too small, it otherwise shows only the time. This works fine on my desktop PC--plenty of room there (see illustrations for comparison). So how do I widen the day and date area on my laptop? Or would shrinking the font size there let them fit, and how do I do that? Thanks.

More replies
Relevance 78.72%

On my laptop I'd like to widen the day and date area so that the day and date fit on one line. For instance, for today, I'd like it to display "Thursday/09/15/2016." I have made this change in settings, and when I hover the mouse over that area, the display is correct. But because the display area is too small, it otherwise shows only the time. This works fine on my desktop PC--plenty of room there (see illustrations for comparison). So how do I widen the day and date area on my laptop? Or would shrinking the font size there let them fit, and how do I do that? Thanks.

Answer:Widen notification bar day and date area to fit single line

This might be a partial solution to your issue. If you right click a blank area of the taskbar you should get a pop-up menu. Click on Properties. A dialog box should open with a check box that allows you to use small taskbar buttons. If I uncheck that box my taskbar gets wider to accommodate the larger buttons and correspondingly the clock will also show the date. Unfortunately, it doesn't show the day. Perhaps someone smarter than me will have a better answer.

5 more replies
Relevance 78.31%

As above, I recently upgraded to XP from ME and since then the date format in the Received column of Outlook 2000 is in US format while in the Control Panel, everything is set correctly to the UK format.

Is there any way of forcing the issue in Outlook to make it behave as per the Control Panel?

Cheers all.
 

Answer:XP is on UK date format, Outlook 2000 is on US format

Hi Simes

After a cursory look through Outlook,
How does the time display in Outlook 2000,
Tools > Options > Calendar tab > Time Zone?
 

3 more replies
Relevance 78.31%

in spread sheet if I format a cell as English uk date format dd/mm/yy I have to input data as mm/dd/yy and it shows it as uk format but if I input it as uk format it does not. All my older version spread sheets and accounts when opened with excel 10 give me wrong format. I have checked that the transition mormula boxes are unchecked

Answer:date format in excel 10 will not show uk format dd/mm/yy

It is not an Excel issue.I believe what you need to do is change the System Date Format, it is probably set for US and you need to change to UK.Look here for instructions on changing the System Date:http://windows.microsoft.com/en-us/...This is for Win 7, but Win 10 should be similar.MIKEhttp://www.skeptic.com/message edited by mmcconaghy

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

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%

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%

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%

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%

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%

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%

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%

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%

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

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

Would this help? enter link description here

1 more replies
Relevance 77.9%

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%

hi, i'm trying to find a way to keep the date on the task bar next to the time. i know it appears when you resize the task bar but i'd rather not have my taskbar double size. i know there are downloadable programs that can change it but i'd rather not clutter my comp with programs either! (unless it's a really small application) is there anything i can do with the registry?

Answer:date on the taskbar?

You don't need to resize the taskbar, just hover the cursor over the time - the date will appear!

10 more replies
Relevance 77.49%
Question: date on taskbar

Hi I'm new to this and not too clued up on the tech stuff. My problem is I have replaced the battery in the PC and updated the time and date via right click on task bar clock.The time holds fine but each time I shut down and restart PC the date reverts to 10 January 2008 as revealed by hovering curser over task bar time and similarly on the calendar revealed by right click. Can anyone help me with this problem Thanks all.
 

Answer:date on taskbar

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

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

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

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

Dim wksCurr As Worksheet
Dim rngTarget As Range

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

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

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

Proc_Exit:

Exit Sub

Proc_Error:

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

Exit Sub

End Sub

3 more replies
Relevance 77.49%

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

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

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

2 more replies
Relevance 77.49%

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%

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

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

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

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

Answer:Excel 2010: Cell Date Change with Current Date

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

1 more replies
Relevance 77.49%

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

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

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

4 more replies
Relevance 77.08%
Question: Date Format

In Excel 2007 if I enter the date September 15, 2010 and format it to text I get 40436. What does the 40436 represent?

Answer:Date Format

The number of days since 1/1/1900, apparently. Change the formatting on the cell to one of the date formats.

3 more replies
Relevance 77.08%
Question: date format in xp

The system default short date format is: dd-MM-yyyy. We have an application that runs with the date format in: mm/dd/yy. and changes automatically Is there any method (e.g. batch) so that we can launch the application and then change back to the system default after close the application without the need to ask user to do the change manually via the Control Panel? ThanksThanks, any help appreciated

Answer:date format in xp

Is there any method (e.g. batch) so that we can launch.. You better post this in the programming section.Happy is ONE who says I am an OttoMAN.

3 more replies
Relevance 77.08%
Question: Date Format

Hi,

The default date format is MM/DD/YYYY. How can I save and display as DD/MM/YYYY? This is very important cos' after I entered in DD/MM/YYYY, Access still convert it as MM/DD/YYY.

Thk a million!
 

Answer:Date Format

Form Access Help
Microsoft Access can display a wide range of international formats. To help ensure consistency among applications, Microsoft Access uses the regional settings in Microsoft Windows Control Panel for the predefined Number and Date/Time formats. If your data isn't displayed in the right format for your country/region, change the regional settings specified in Control Panel.

But you can set them manually as well.
 

1 more replies
Relevance 77.08%
Question: Date format

Is there a way to change the date format the machine uses.
For example, my machine organizes pictures by date, but mm/dd/yyyy doesn't really facilitate finding anything.

yyyy/mm/dd would be much better.

TIA

Answer:Date format

This might be what you are looking for. Click here

1 more replies
Relevance 77.08%

Hi I'm in the UK. I'm running windows 7 (32)
I have a particular program that will not even start up if the regional date setting is not set to USA format i.e. Month/Day/Year it just gives an error message saying time date error. With the date set as USA format this program works fine. The problem is, all my accounts are run using excel. Where invoices, receipts and bank statements are all sorted by date using the UK Format Day/Month/Year. Invoices I sent out on 3rd Nov 2017 (show up as 11/03/17) are now listed in March's invoices.
is there any way around this. for example using a batch file to change the date format before the program starts and the returning it to UK date format after program finishes, or any other way around this dilemma.
 

Answer:Date format changes

Hello

Hopefully some of our members will chime i soon.

@phillpower2 @georgeks
 

0 more replies
Relevance 77.08%
Question: Date format in DOS

i am using windows 2000 platform. i want to create a dos batch files that would create a backup or archive files.

e.g.

Code:

d:\data\in
09/05/2006 05:46 PM 12,747,232 file01.txt
09/05/2006 05:46 PM 335,320 file02.txt
09/05/2006 05:46 PM 287,742 file03.txt

when the batch runs it will check for the current system date and will copy the files to another folder as

d:\archive\in

09/05/2006 05:46 PM 12,747,232 file01-09062006.txt
09/05/2006 05:46 PM 335,320 file02-09062006.txt
09/05/2006 05:46 PM 287,742 file03-09062006.txt

how do i achieve this? thanks.
 

Answer:Date format in DOS

It has been so long since I have worked in MS-DOS it is not funny but here is a page that might be of some help to you

http://www.chebucto.ns.ca/~ak621/DOS/Bat-Adv2.html

Have fun and enjoy
 

3 more replies