Computer Support Forum

why are my emails not in order by date in out

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

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

Relevance 100%
Preferred Solution: why are my emails not in order by date in out

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

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

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

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

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

2 more replies
Relevance 78.31%

I wish to save my old emails so I transfered them to a new folder. But although they are sorted as created by date order they will not sort into date order on my new folder just into name order which I do not want. How do I get them to sort into date received order.Help please.

Answer:EMails cannot sort into date order in folder

In the new folder, clicking the "Received" column header should sort the contents by date received. Clicking it again will toggle between oldest or newest date first.

7 more replies
Relevance 77.49%

I'm tracing my family tree, and have quite a few contacts now that send me data by email to Outlook Express. I have created a folder for each of them in my ?In Box? as a dropdown menu, but as there is now a fair amount for each person in each folder, I want to put all the emails in date order received,(and sent). Is this possible? If not, is there any way that I could transfer them easily to an external drive maybe? I do transfer the data to a family tree program on my PC, but I need to go back to individual emails at times so that I do not duplicate items that I have sent before etc. I try to cross reference by date order in the program. Any ideas would be very welcome.

Answer:Storing emails in date order in Outlook Express?

Just click on the "Received" column at the top to arrange all e-mails in time date order.

3 more replies
Relevance 65.6%

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

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

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

1 more replies
Relevance 63.96%

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

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

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

1 more replies
Relevance 60.27%

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 56.58%
Answer:Notepad F5 gives time then date, need to reverse order, to date then time

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

3 more replies
Relevance 56.58%
Relevance 55.35%

Hi I have the following issue:

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

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

Answer:Solved: order of date

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

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

3 more replies
Relevance 54.94%

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

Answer:Outlook Express - date order

Regional Settings in Control Panel sets this for all Windows applications

3 more replies
Relevance 54.94%

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

Answer:date order for e-mail received

In OE, go to View - Sort By - Received

3 more replies
Relevance 54.94%

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

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

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

9 more replies
Relevance 54.94%

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

Answer:{Solved} Message date order

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

3 more replies
Relevance 54.94%

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

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

Answer:Solved: Date Order In View

9 more replies
Relevance 54.12%

Whenever I add files (photos) to Nero Express they automatically reorganise themselves and appear in a jumble.This is OK when viewing on the PC as I can rearrange them back via 'View>Arrange Icons By Date 'before looking at them.I can't do this on my DVD player so the CD is useless in this instance.How can I add my photos to Nero in date order like thet are in the photo folder ?Selecting All + Dragging and Dropping, and Copy and Paste don't work.Can this be done please ? (Using Windows Millenium )

More replies
Relevance 54.12%

How do you arrange e-mails in descending date order in Windows Mail?

Thanks
 

Answer:Solved: Windows Mail - Date Order

Select View --Sort By-- and check off Received and Descending.


 

3 more replies
Relevance 54.12%

Hello and good morning to u all. I have itunes on my windows XP machine which ive been using for over 4 years...i think itunes is the best music player out there, but ive got one problem that i'm hoping that can be sorted out for me here today. I have an extensive music library(like most people)...and my music is sorted by DATE ADDED,...as i'm accustomed to this way...but here is my problem...when I sort by date added...the track numbers in the all my albums appear out of order....just like here:click hereI'm sure like myself, there are loads of people that like to listen to an album in the EXACT WAY that is on the CD recorded by the artist. I know i can re-arrange this as a playlist but its a lot of hassle and it wont solve the problem in my actual music library which will still show in the incorrect order. There MUST be a solution out there.....When I listen to music I most start my listening session with the music I have added most recently. If I have added an entire album recently I want to hear the album in the order the "artist" intended it to be heard. I would think many people would be keen to hear the things they have added most recently. The lack of an option to sort by "Date Added by Track#" is terribly annoying for me.

Answer:Serious itunes problem when sorted by date order

Hello very strange....still no response from anyone so far...and ive written this post since this morning.....any suggestions/ help for me with this pls??

3 more replies
Relevance 54.12%

my files are all over the place as far as the date of the file is concerned. They range from 2003 to current, but are random and I can find "added" files that I need. I only see one page of files and I know there are more than that and I know that many of these are recent. How do I re-order them by current date first?

Answer:Arrange files in order of most recent date

What sort of files do you mean?Text files?Music files?Movie files?Etc, etc, etc.

2 more replies
Relevance 54.12%

I always used to see my Recent Documents in (roughly) date order but now they in in alphabetic order.It's a trivial point but I would prefer to change it back - how do I do it????

Answer:sequencing 'RECENT DOCUMENTS' in date order

Click on the Date column header. Click again to reverse the date order.

7 more replies
Relevance 54.12%

Happy Holidays, everybody!

I've got a 90th birthday picture project that I'm assembling and am getting pictures from several sources. Sometimes I'll get two or three sets of image files, all of which are labeled "img_001.jpg, img002.jpg, img003.jpg", etc. These come from several past years. When they're dumped from a thumb drive to my working folder, and then displayed, they get all intermixed. (I use irfanview to view the collection, to assure they're sharp focused, etc.)

I sorted the folder by date, went to the first file and launched irfanview. I get the selected file. If I click the "next arrow", I might get the next physical file, not the next-by-date. The program has a slideshow function that will sort it for you and display by date.

What I really want is to get the files into the date order physically on the disk, so that when copied onto a digital picture frame, for example, it will play sequentially by date if possible. I don't know that they have a lot of intelligence, to sort the pix by itself.

I tried sorting by date and the copying to a different folder on a different disk, but it always changes when I access it afterward. With 400+ pictures, I don't want to do them one-by-one.

Any freeware out there that'll do it for me?

Thanks!
 

Answer:Solved: Putting files in date order?

9 more replies
Relevance 53.71%

Can anyone please advise how to get my e-mails downloaded in Day/date order instead of any order.I am using Outlook 2000 windows 98seThanks.

Answer:down load e-mails in date order outlook 2000

I'm not sure that you can change the order in which they are actually downloaded. However, you can change the order in which they are displayed. If you click on the "Received" tab it will sort them. Click it again and it will reverse the order and so on. You can also click e.g. the From tab to sort them that way.

2 more replies
Relevance 53.71%

When I download photos from my Sony Cybershot to my notebook, using Windows Camera wizard to MY PICTURES relevant sub-file, they remain in the jpg file (& date) number order. But when I view or edit them in MS Picture Manager, I find some of my photos date order has been mixed-up compared to the order of taking and storing them on the camera folder and in the Explorer/My Pictures sub-file. So, when I simply wish to view them in a slideshow sequentially they are of course displayed as well out of order. Nor can I find a facility in MS PM to re-arrange them in date order? Furthermore, MS PM will not allow me to drag & drop them back into the date order (which would be a long job sometimes with holiday photos in any case!).

Has anybody a solution how to overcome this frustrating time-waster, please?
 

Answer:MS Picture manager mixing up photos date order

Welcome to the TSG forum.

Sorry, not familiar with M$ PM ...
But the freeware Irfanview Image Viewer and Editor is very popular here at TSG.
http://www.irfanview.com/
This should have some more tools as compared with M$ PM
 

3 more replies
Relevance 53.71%

For a long time, if I downloaded a folder from Google chrome, it would go to the downloads folder in Microsoft explorer with the latest downloaded file on top. I'm not sure how I changed it, but somehow the download folder now has the looks of the music library with categories in the details view of "name","contributing artist", "title", "album". I can sort them by name alphabetically, but not by date downloaded. If I don't remember the name of the download, I'll have to search for it in this huge folder of lots of different downloads, and if it has a weird name as some downloads do, it will be difficult. Is there a way to go back to getting the downloads folder like a documents folder (or however it was) and be able to arrange them by date downloaded?

Answer:Download Folder has does not display downloads in order/by date

Right click and choose sort by date.

You should start organizing.

5 more replies
Relevance 53.71%

I have had to reinstall my ancient Quicken accounts program and cannot now work out how to change from the American month/day/year to the British day/month/year date order. Can anyone help?

Answer:Quicken 2000, changing from American date order

As per Jock1e - you need to check in Control Panel - Region & Language - under Location Tab make sure it is is set to United Kingdom. It cannot be changed from within the Quicken program itself.

1 more replies
Relevance 53.71%

Hi: My messages are coming in alphabetical order in Outlook Express. How do I change this so that they come in order of time and date?
 

Answer:Emails in alphabetical order in OE

6 more replies
Relevance 52.89%

Hi,
I would like to use a VLOOKUP formula in my bank statement sheets in order to populate item codes from a lookup table. Some of the entries (lookup values) in a statement contain a date in the form of ddmmm (e.i. 21JUL). Is there a way of creating a VLOOKUP formula that will ignore the date in the lookup value and therefore populate correct item codes into the statement sheets...for example I have several instances of the entry BANK TRANSFER ON ddmmm, where ddmmm is the date (21JUL, 11AUG, 05SEP). I would create a lookup table with a single entry BANK TRANSFER ON and the VLOOKUP formula will recognise this entry ignoring the date in the lookup value.
Hope it makes sense. Thank you in advance. Heidi
 

More replies
Relevance 52.89%

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

More replies
Relevance 52.89%

Hi guys,

I'm just setting up the mail app and I can't seem to change the order of email accounts on the left hand side. I looked up other possible solutions and it appears the "right click > move up/down" option is no longer available. Anyone else experience this?

Edit: I've also tried changing the names and the alphabetical order doesn't seem to matter.

Thanks for your time!

More replies
Relevance 52.48%

I run a small ISP and don't 'copy' peoples e-mail. Courts really expecting to see all their e-mail? Is it common practice to have a copy of peoples e-mail server side? I would just like to be prepared for the day, if it should come, law contacts me wanting this stuff.
 

Answer:Infinium court order to turn over emails...

It all has to do with being a corporation.

As a corporation, you have much more responsibility for documenting than communications than most businesses, especially between officers of the corporation (CEO, COO, CIO, etc). Generally corporations archive all emails, computerized records, and written records. They could preen out a lot of stuff that is not required to be archived (not business related), but it is just easier to archive everything.

As an ISP, you should consult an attorney about what you should archive and for how long. And most importantly, once you have that answer, even if it is at your discretion, make sure you have a written policy detailing how long you will archive the emails or that you will do no archiving. That way you are covered if a question of archiving comes up because someone lost something they feel is important or valuable.
 

2 more replies
Relevance 50.43%

In Outlook Emails show up with None as date. I have tried changed the "View" settings with no change.
 

More replies
Relevance 50.43%

in previous outlook versions I could add a followup date when flagging a email. however Windows ver 8 and 10 only have option to add or clear flag? I find the date feature very useful. Pse can someone me give some advice? tks

More replies
Relevance 50.43%

I like to save my emails under the name of the person I send them to/receive them from. Unfortunately, they save randomly within the folder. Is it possible to make them save in time and date order irrespective of what is written in the subject line?

Answer:How save emails according to date and time?

If you are using Outlook or Outlook express just click on the heading bar at the top of the list 'from' or 'to' and it will list them in order.

7 more replies
Relevance 50.43%

I can't get my WLM to sort by date, either ascenting or descending. New emails end up all over the place and I have to go down the list to find them. In the columns I have the date selected, along with "subject" and "from" and that's all. I did a repair of Windows Live Essentials, but it didn't help. Any suggestions would be appreciated. Thanks, Don.

Answer:WLM won't sort emails properly by date

  
Quote: Originally Posted by MuffinHat


I can't get my WLM to sort by date, either ascenting or descending. New emails end up all over the place and I have to go down the list to find them. In the columns I have the date selected, along with "subject" and "from" and that's all. I did a repair of Windows Live Essentials, but it didn't help. Any suggestions would be appreciated. Thanks, Don.


Don

How did you get it to sort for date, and subjust/from at the same time?

I assume you are looking in the inbox. How do you have quick views configured?

9 more replies
Relevance 50.43%

I am running Vista on a Lenovo laptop. My computer date is correct, but emails I send from my ymail account have incorrect dates on them. How is this possible?
 

Answer:Ymail emails have wrong date?

please do not duplicate posts - continue here http://forums.techguy.org/general-security/940615-possible-ymail-emails-have-wrong.html
 

1 more replies
Relevance 50.43%

After 2 problem free years using Mozzila Thunderbird for my emails, all of a sudden no date is appearing on sent or received messages. Only time appears. Any assistance offered in fixing this problem would be appreciated. Also, anybody have any thoughts as to why this has started to happen? Problem started today 30th March
 

Answer:Date nolonger appearing on emails

8 more replies
Relevance 50.43%

My clock is correct on my computer and when I send mail to myself it is correct. But in my mail to others it is always wrong. This is on my isp and webbased mail. What can I do? I have been online and sent mail and got it straight back and can see it for myself as well as hearing from people asking me what is wrong with my clock.
 

Answer:wrong date and times on Emails

8 more replies
Relevance 49.61%

It's a simple task I know, but I can't figure out how to do it on windows 10.

More replies
Relevance 49.61%

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

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

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

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

whos the email ISP with ?
 

1 more replies
Relevance 49.61%

On the 30th of Dec. my "received" column in Outlook 2002 changed to the 2003. Now it says 2004. The date in the actual email is correct when I open it.

It only does this with messages that I receive thru Yahoo. The ones I get thru another server have the right date.

All other programs and even the calendar in Outlook 2002 are all correct. It seems that Yahoo is somehow sending the wrong code to my browser.

This has not happened to me before and is doing it on both my computers.

I can't find a tech support address at Yahoo. Anyone have one for them?

Please help. I am frustrated!
 

Answer:wrong date on Yahoo emails with outlook

I'm having similar problems, some of these emails I've been getting are from "Beyond next month"
 

3 more replies
Relevance 49.61%

When you delete an email, it goes to the deleted email file and is sorted by the original date received. Is there a way to sort the deleted emails by the date they were deleted?

Thanks

Debby Durden

Answer:Sort deleted emails by delete date

Hello and welcome, @debbydurden:

Are you referring to the Win10 mail app, or to a different email client or webmail application?

Thanks,
MM

4 more replies
Relevance 49.61%

Only have the time not the date in Thunderbird - how do I show the date next to received emails ? Have tried to click on different fields but nothing works

Answer:thunderbird how to show date emails received

This happens, when the email, you received, is from the current day.Tomorrow, the email will be shown with date and time.

3 more replies
Relevance 49.61%

Windows 7, Windows Live MailWhen I print out an email there is a date stamp at the bottom of every page. How do I stop the date being added to the email?

More replies
Relevance 49.61%

Hi, Every month I save my emails to a folder on my hard disk by copying and pasting to that folder.  When they are pasted they file by subject line.  I want to file them by date. At the moment if I want to do that I have to go into the subject line while they are still sitting in Outlook and type in the date then I can copy and paste them to the folder by date.  Needless to say that is very time consuming. Is there another way I can file them to disk by date?  Hope someone can help.  RegardsJimP

Answer:Filing emails by date from Outlok 2003

Why not just use the AutoArchive facility (if you're using Microsoft Outlook)?  Much easier.

3 more replies
Relevance 49.61%

When you delete an email, it goes to the deleted email file and is sorted by the original date received. Is there a way to sort the deleted emails by the date they were deleted?

Thanks

Debby Durden

Answer:Sort deleted emails by delete date

Hello and welcome, @debbydurden:

Are you referring to the Win10 mail app, or to a different email client or webmail application?

Thanks,
MM

2 more replies
Relevance 49.61%

I work in a job where I have to constantly save emails to various files on the system. Every time I save a file I have to manually type in who the email was from/to and the date & time into the name of the email files. As you can imagine this is pretty tedious.

So my question is, is there a way of saving the email to a file where it automatically populates recipient details and time & date.

If you can help me do this then you will save hrs of my day and make me a happy man.

Answer:How to save emails with recipient and date sent details.

joezepher, welcome to the windows 7 forum.

One way that could work is to define a print to file printer and then select that printer as the default printer in your email program. Most times when I print a message it prints the whole thing including all the heading.

Just a thought.

Rich

2 more replies
Relevance 49.2%

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

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

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

4 more replies
Relevance 49.2%

I have recently had to reformat by Window XP Laptop reqiring a reinstallation of all ProgrammsOutlook 2003 has since this reload returned a none date when sending emails to the outbox.It should change the email into italics and have a send date by each email.Is there a simple setting to change this back.I have already tried uninstalling and reinstalling Office 2003 but to no avail.Does anyone have any ideas please?Thanks

More replies
Relevance 49.2%

I've been having this problem for about 1 week and I'm tearing my hair out. I send an email (happens on all accounts) and the time date is correct in my sent folder, but when I receive a reply from the recipient I notice that the time date is a different time and 1-1/2 years in the future.
This happens when using Windows mail on my desktop (Windows 10) or through Outlook from my browser. I've tried both Firefox (my default) and Edge. Some problem all around.
My date, time and region settings are all correct. I have removed and re-added accounts through Outlook online and Windows Mail.
ARGH! HELP!
See image for one just sent a bit ago at about 9:20ish AM on 11/30/2016

Answer:Outlook 365 email date-time wrong on sent emails

That time is when receive on your email server. The time setting is messed up on your email server. If you send yourself an email it still goes thru a SMTP server to your incoming email server.

2 more replies
Relevance 49.2%

I've just installed Windows Live Mail on this PC.

One thing that is bugging me is that I had many old emails (.eml files)

Since the WLM installation, when I browse to a folder containig any old emails, WLM (in cahoots with Explorer?) changes the Data Modified to the then current date.

-- why is that happening?
-- can I change it back?
-- can I stop it happening?
-- oddly, it did not always change all the emails in some folders.

Answer:Live Mail - has changed Date Modified on my old emails :(

... and if I then try to copy the email to a USB stick (FAT32 file system) I get this (I blanked out unnecessary details):

5 more replies
Relevance 49.2%

I have Microsoft Exchange Server 5.5 running on a Windows NT 4.0 SP6 server. All is well except for the 'sent' date on emails. Due to the rule in the Outlook calendar where all entries are pushed forward or back an hour when the time zone changes we have the "Automatically update for British Summertime" box unchecked on each server and computer and simply change the time every six months. The time on the email server is correct and the time on the desktop computers is correct. However when we send external emails they seem to arrive an hour before they were sent and when we send internal emails they seem to arrive an hour after they were sent. This does not make sense and I don't know where else to look for time settings, can anyone help please?
 

Answer:Exchange Server putting wrong date on emails

Delete the rules and see what it does. The emails should only get the timestamp from the server.
 

1 more replies
Relevance 48.79%

Hi
I am using Outlook 2007 and i keep about 2 years of all sent emails in the Sent emails folder.

The automatic archive for this folder are set so that any emails older than 2 years, are moved to the archive folder.

A number of months ago (been too busy to tackle this until now and can't remember if it started before i moved to Windows 7 or after) i noticed that many emails in my Sent folder have blank headers. By that i mean the following are blank Sent: Date and the To: Recipient's name

These emails appear to be all older than 4 months... but i am only guessing this based on looking at the content of the email and trying to remember when i sent them.

When i click on the email the content looks ok for the first few lines... and then the rest of the content seems to be chopped.

I have only seen this in the Sent folder, although i have many other large folders.
Many emails in my Sent folder appear fine and look normal.


Does anybody have an idea what the problem could be, or how it was caused, or how it could be fixed?

I have done many things over the past year including
? Moving from XP to Windows 7
? Searching for all emails greater than 3 Mb and deleting them
? After deleting the large emails, i resized the pst files so they became smaller

I have also seen a possibly unrelated problem whereby the Auto Archive fails with an error unable to open the Archive Pst file. I believe this has been ... Read more

Answer:Outlook emails chopped short and sent date and recipient blank

Try the OL Repair tools that come with Outlook.
Inbox Repair Tool or the OST Repair tool

9 more replies
Relevance 48.79%

HELP!! Does anyone know HOW to customzie the Date and Time stamp on emails in Outlook 2010? I want each and every single email to show up in my Inbox (whether read or un-read/new) as the DATE, i.e. 6/19/2012 9:24am I do NOT want the words "Today" or "Yesterday" or "Tues" - AND - I want the entire DATE to appear and the TIME to appear on every message. I find and sort emails by time and date. I used to have that as a default in Outlook 2003. How do I change the default in 2010 to be what I want?

 

Answer:HELP!!! OUTLOOK 2010 - Date&Time stamp on emails - can I customize?

9 more replies
Relevance 44.28%

Hello - strange problem one of our users is having - when she picks up a draft email (she has previously prepared) then sends it, the email is recieved with the draft date, instead of the sending date. This means that the recipient cant see the new message (they will find it in listed as being recieved on the "draft" date). I have been unable to duplicate this error! Has anyone heard of this happening?
(Outlook 2007/Exchange 2007)
Any help very welcome!
Thanks

Jon Morris
C&IT Services
Edinburgh Napier University
 

More replies
Relevance 44.28%

I am attempting to find add-ons for Outlook 2010. This is what I need the add-on to do:
Export an email from Outlook onto our server, and into a job folder.
Save file with date email was received, not exported out of Outlook, and subject line.
Thanks
 

Answer:Outlook 2010/export emails from outlook to CSV folder with received date and subject

Why not drag and drop the email to the file system?
 

3 more replies
Relevance 42.64%

Hi,I've an approved RMA for full refund for an X230 that I'd purchased from Depot. The restocking fee was waived as I'd ordered another X230 (better EPP deal).I shipped back the unopened X230 and Lenovo acknowledged the receipt of the laptop on Feb 5. And since then there has been no update on my refund. I was told it would take 6 business days for the refund to be posted back to my account.Now it's over 2 weeks and when I contacted post sales support - this is the reply I got from them: *************Hi,We regret to inform you that i am unable to get any information on this order, I am still working on your order. Once we get the information on the refund i will keep you updated on the same For further assistance please feel free to email me back and i will be glad to assist you Regards *************So what are my options now. An answer like "i am unable to get any information on this order" from customer care themselves doesn't really inspire confidence with Lenovo. The second X230 that I'd ordered, has issues with the IPS display having a yellow tint and the touchpad being super jumpy. Had sent it to their repair center who unfortunately were not able to see the problems at first but later accepted the problem with the touchpad alone and they're getting the laptop re-imaged. Display is as designed according to them. They're sending it back now. Will wait and see. If I still see the display problem, will get it returned. Thank you Lenovo, for that amazing buyi... Read more

More replies
Relevance 42.64%

The Windows Photo Viewer will not display photos in the order they are sorted by Windows Explorer.
This is not referring to the slide show feature, just the forward and back arrows.
The only order pictures can be viewed is by name despite Windows Explorer being set at view by date, ascending.
I have repaired Microsoft Live Essentials, uninstalled and reinstalled but the issue remains.
This is also not an issue with photo tags or photo names.
Windows Explorer sorts as selected but click a picture in the middle to view, click the forward arrow and instead of the next date picture being viewed, the next name picture is viewed.

Answer:Windows Photo Viewer; sorting order not the same as view order

Hi!

I upgraded to Windows 10 recently as well, I have the same problem and I also have a solution. However, I do not know, if it is ideal. :-)

What is obviously missing is an entry in the registry called DropTarget. This entry tells Windows Photo Viewer to display the images in the sorting order of the folder Photo Viewer got called from.

Non-solution:
I saw that at least in my registry there is a DropTarget defined in HKEY_CLASSES_ROOT\Applications\photoviewer.dll\shell\open\DropTarget. From the name of the key and from reading the docs this looks as if it would be applied to all calls to this program, but -if that actually is the case- for me this entry does not work. It has been there (at least) after my Windows 10 upgrade, also the "Clsid"="{FFE2A43C-56B9-4bf5-9A79-CC6D4285608A}" seems to be fine, but it does not do the job.

Solution:
For me, this problem was present for jpg and png files, but not for bmp, dib, gif, jfif and what else can be opened with Windows Photo Viewer. To fix this, I have added the following to the Windows Registry:


Code:
[HKEY_CLASSES_ROOT\jpegfile\shell\open\DropTarget]
"Clsid"="{FFE2A43C-56B9-4bf5-9A79-CC6D4285608A}"

[HKEY_CLASSES_ROOT\pngfile\shell\open\DropTarget]
"Clsid"="{FFE2A43C-56B9-4bf5-9A79-CC6D4285608A}"
After you added that to the registry, rightclick a jpg file, select "Open with", choose Windows Photo Viewer and click "Always open with this ... Read more

17 more replies
Relevance 42.64%

The Windows Photo Viewer will not display photos in the order they are sorted by Windows Explorer.
This is not referring to the slide show feature, just the forward and back arrows.
The only order pictures can be viewed is by name despite Windows Explorer being set at view by date, ascending.
I have repaired Microsoft Live Essentials, uninstalled and reinstalled but the issue remains.
This is also not an issue with photo tags or photo names.
Windows Explorer sorts as selected but click a picture in the middle to view, click the forward arrow and instead of the next date picture being viewed, the next name picture is viewed.

Answer:Windows Photo Viewer; sorting order not the same as view order

Hi!

I upgraded to Windows 10 recently as well, I have the same problem and I also have a solution. However, I do not know, if it is ideal. :-)

What is obviously missing is an entry in the registry called DropTarget. This entry tells Windows Photo Viewer to display the images in the sorting order of the folder Photo Viewer got called from.

Non-solution:
I saw that at least in my registry there is a DropTarget defined in HKEY_CLASSES_ROOT\Applications\photoviewer.dll\shell\open\DropTarget. From the name of the key and from reading the docs this looks as if it would be applied to all calls to this program, but -if that actually is the case- for me this entry does not work. It has been there (at least) after my Windows 10 upgrade, also the "Clsid"="{FFE2A43C-56B9-4bf5-9A79-CC6D4285608A}" seems to be fine, but it does not do the job.

Solution:
For me, this problem was present for jpg and png files, but not for bmp, dib, gif, jfif and what else can be opened with Windows Photo Viewer. To fix this, I have added the following to the Windows Registry:


Code:
[HKEY_CLASSES_ROOT\jpegfile\shell\open\DropTarget]
"Clsid"="{FFE2A43C-56B9-4bf5-9A79-CC6D4285608A}"

[HKEY_CLASSES_ROOT\pngfile\shell\open\DropTarget]
"Clsid"="{FFE2A43C-56B9-4bf5-9A79-CC6D4285608A}"

After you added that to the registry, rightclick a jpg file, select "Open with", choose Windows Photo Viewer and click "Always open with thi... Read more

20 more replies
Relevance 42.64%

 This is my Order Number: 2FFVLJI've always owned a Thinkpad for the past 10 years and am a staunch Thinkpad fan.  The R60 and Z60m have been reliable and faithful companions.  I have been recommending Thinkpad to my colleagues and friends.  Hence when I needed a new laptop, I went directly to lenovo's site and ordered a T510 (Web Special) on 4th August 2010 using a valid credit card.  For two days the status was "in process".  On Aug 6th, I was unable to login in usng the cust no and order no to see the status.  When I called the sales customer service, I was informed that the order was cancelled from lenovo's side.  They pointed me to the credit card department for further information.  When I called the credit card department, they claimed information mismatch as the reason for the cancellation but they could not point out what exactly was the mismatch.  I can assure you that the card is valid.  Currently I'm not able to place another order for the same model from lenovo's site as it is no longer available.  This is very regretful as I was really looking forward to getting my laptop of choice.  I tried calling the sales dept but they are not available as it is weekend now (everyone needs a break )  So I have emailed them for help.  I'm yet to get a response.  This has been a nail biting experience.  I'm anxiously waiting for the response from the sales dept.   Will it be possibl... Read more

More replies
Relevance 42.23%

I would like to see eBay and Amazon order list and order details

Answer:I want to see ebay and Amazon order list and order detials

I'm afraid we need more details than that, please...
Could you share the device name? OS version? How is the attempt to view being made: browser, app, etc? What happens when you try?
If you need additional help or have more questions or details to share, please join the site so you can reply in this thread. See this link for instructions on how to join Windows Central.

1 more replies
Relevance 42.23%

I have 400+ photos, all are in the same order by date created and by name, so no matter which way I sort them--by name or date created-- they are in the same order. When i view them with microsoft office picture manager, some of them -- about 20, at random throughout the list -- are out of order.

suggestions?
 

Answer:Photos in order on windows explorer; out of order on viewer

8 more replies
Relevance 40.59%

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

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

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

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

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

Greetings, and thanks in advance for your help..

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

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

Additional Notes that may help:

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

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

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

Thank You

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

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

1 more replies
Relevance 38.95%

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
Terry, East Grinstead, UK

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

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

2 more replies
Relevance 38.54%

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

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

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

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

Answer:Excel 2007 - Start Date and End Date question

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

3 more replies
Relevance 38.54%

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

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

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

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

The following Excel functions are volatile:

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

4 more replies
Relevance 38.54%

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

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

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

9 more replies
Relevance 38.54%

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

rst!dateIntoForce = Me!ActiveXCtlDOForce

I end up with this in my database:

1/6/2003 5:48:43 PM

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

1/6/2003

goes into the database
Thanks
 

Answer:Date Part only from MS Access Date picker control

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

1 more replies
Relevance 38.54%

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

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

Thank you for your help!
 

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

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

2 more replies
Relevance 38.54%

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

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

Any suggestion or links would be great.

Thanks,
Andre
 

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

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

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

2 more replies
Relevance 38.54%

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