Computer Support Forum

Sort date daily

Question: Sort date daily

I have a big problem with this daily report since I have to do it manually every single day. Is there a way to automated this in macro or vlookup . Help Name Room Status From DateWayne,G 440-2 Medicare AAA 1/23/10Chin, P 520-3 Private BBB 2/23/10King, L 422-4 Insurance CCC 1/23/10Cohen, A 545-3 Medicare AAA 2/23/101. This data base keep adding up daily so data range will not work.2. Need to print report on daily admissions. So all patients admit for 1/23/10 will be print out of 1/23/10 Date Name Status1/23/10 King, L. Insurance1/23/10 Wayne, G. Medicare

Relevance 100%
Preferred Solution: Sort date daily

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: Sort date daily

Hi,Here is a macro that should do what you want.Your source data is in a worksheet named "Source"Your report is created in a worksheet named "Report"If these are not the names used, either change the names of the worksheets or change them in these lines in the macro: 'change name of source worksheet here
strSrcWS = "Source"
'change name of report worksheet here
strRptWS = "Report"The source data is in these columns, starting at row 2 A B C D E
1 Name Room Status From Date
2 Wayne, Greg 440-2 Medicare AAA 1/23/10
3 Chin, Peter 520-3 Private BBB 2/23/10
4 King, Larry 422-4 Insurance CCC 1/23/10
5 Cohen, Alex 545-3 Medicare AAA 2/23/10
Due to the way that the macro finds the end of the source data, all cells in column A below the last data must be empty.On the report page the date will be entered in cell C1 as follows: A B C
1 Report for 1/23/10
2 Date Name StatusAdd the other headings, as shown.When the macro is run, this is the result: A B C
1 Report for 1/23/10
2 Date Name Status
3 1/23/10 Wayne, Greg Medicare
4 1/23/10 King, Larry Insurance
The macro is triggered by either changing the date in cell C1 on the report page, or to re-run for the same date, select C2, click in the formula bar and click the adjacent check mark.As changes made by Macros cannot be undone with the Undo button, test this macro on a copy of your data. Always make a backup of your Workbook before running this macro. This code has only been tested on sample data, and it has not been tested in your environment, so test it on copies of your data to ensure that it works 'as expected'To load the macro, do this:In the worksheet named "Report", right-click on the name tab at the bottom of the worksheet.Select View codeIn the visual basic window that opens, enter this: Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo ErrHnd:

'stop changes made by this macro from re-triggering it
Application.EnableEvents = False

If Target.Address = "$C$1" Then
Dim rngStart As Range
Dim rngEnd As Range
Dim rngCell As Range
Dim rngDestStart As Range
Dim intDestOffst As Integer
Dim strSrcWS As String
Dim strRptWS As String

'change name of source worksheet here
strSrcWS = "Source"
'change name of report worksheet here
strRptWS = "Report"

'set start of source data range
Set rngStart = Worksheets(strSrcWS).Range("A2")
'find end of source data
Set rngEnd = Worksheets(strSrcWS).Range("A" & CStr(Application.Rows.Count)) _
.End(xlUp)
'set start of destination data
Set rngDestStart = Worksheets(strRptWS).Range("A3")
'set destination offset counter
intDestOffst = 0

'loop through all dates in column E
'and find those equal to requested date in cell C1
For Each rngCell In Worksheets(strSrcWS).Range(rngStart, rngEnd)
'date is in column E - offset =4 from column A
If rngCell.Offset(0, 4).Text = Target.Text Then
'dates match - so put data into report table
'source data is in cols. E, A & C (source offsets 4, 0 & 2)
'put date in column A - offset 0 from column A
rngCell.Offset(0, 4).Copy _
Destination:=rngDestStart.Offset(intDestOffst, 0)
'put name in column B - offset 1 from column A
rngCell.Offset(0, 0).Copy _
Destination:=rngDestStart.Offset(intDestOffst, 1)
'put status in column C - offset 2 from column A
rngCell.Offset(0, 2).Copy _
Destination:=rngDestStart.Offset(intDestOffst, 2)
'increment destination row offset
intDestOffst = intDestOffst + 1
End If
Next rngCell
End If
're-enable events
Application.EnableEvents = True
Exit Sub

'error handler
ErrHnd:
Err.Clear
're-enable events
Application.EnableEvents = True
End SubFrom the Visual Basic menu click File - Save.Click Alt + f11 (the Alt key and function key 11 pressed together)This takes you back to the main Excel window.Now enter a date in cell C1 on the Report page.The data should now appear as shown.As an extra, you can create a drop-down in cell C1 which gives you today and the last 7 days' dates, so that you can quickly select a date for a report.On the report worksheet in cell K2 enter this formula=INT(NOW())-(ROW()-2)Drag the formula down to cell K9Now select all the cells K2 to K9, right-click and select Format cells...Format the cels with this custom format: m/dd/yy which exactly matches the date format you are using.Click OKApply the same formatting to cell C1Again with cell C1:From the Ribbon select 'Data' and in 'Data Tools' select 'Data Validation'.From the drop-down select 'Data Validation' and in the dialog box that opens select List from the 'Allow:' box.In the 'Source:' box enter the range of cells like this: =$K$2:$K$9Click OKNow selecting Cell C1 will display a short list of dates to select from.Regards

5 more replies
Relevance 63.55%

Help! This should be easy but I can't get it to work.

I have a report that must group by Trip# and sort by ascending activity date all of the various activities that took place on multiple days of the trip.
Further, the trip with the earliest date must come first regardless of the Trip#.
I've accomplished getting the earliest starting date trip first and grouping its detail with a unique string made up of the earliest date of each trip formatted to YYYYMMDD+Trip#. This prints a trip total and works fine.

But the daily activity for the trip is out of date sequence.
Adding a Date field to the 'Sorting and Grouping' insists on breaking on and printing a sub-total for each of the trips activity dates.
Without the sorting & grouping by date the trip records are out of sequence even though the data source query is sorted ascending by activity date.

(see attachments that show the above)

The only solution I can think of is to create a sub-report sorted by activity date.

Does anyone have any better ideas?

Jim Shannon
JES Computer Systems
Access Developer.
 

Answer:How sort by 2nd field (date) without grouping when date changes?

7 more replies
Relevance 61.09%

Is there a programme/add on that will display the date down by the clock in the System Tray?As I get older I find myself increasingly unaware not just of the hour but even the day!

Answer:Date on Screen (No, not that sort of date!)

Try unlocking the toolbar and raise it a bit. The clock will now show the time, day and date. Lock the toolbar.

10 more replies
Relevance 57.4%
Question: Sort by Date

Just switched from 2kpro to XP and i like my music sorted by date. Is there a way to do this is XP? I dont see a 'sort by date' option.
 

Answer:Sort by Date

Sort by Modified is the same thing in XP.
 

10 more replies
Relevance 56.99%

Hey I want to know how to sort by both date and type for my folders and files in the explorer...

Everytime I change it to date it no longer sorts it by type anymore...

Is there a way to do this so I can have both set??

Thank you!! Highly appreciated.

Answer:How do I sort by both Date AND Type??

Have a read of this thread and see if it is of any help to you.
sort files/folders using multiple criteria

3 more replies
Relevance 56.99%

Does not seem to matter which I choose oldest to newest or newest to oldest. I have tried changing the date format. thanks Maggie 5/10/20125/21/20128/20/201212/2/20122/2/20132/27/20132/8/20121/22/20131/26/201211/9/20113/13/20123/18/2013

Answer:Cannot get date to sort correctly. See example.

The only thing I can think of is your dates are getting stored as text. I found this link that explains what I'm talking about.http://office.microsoft.com/en-us/e...Let me know if this helps.

11 more replies
Relevance 56.99%

Hi,

I have lots of files in certain folders and one thing that was useful in windows ME was the option to sort files by date. I now have XP but cannot find this option. Is there something in XP that will sort files in folders from the oldest to the latest. I was able to the files I wanted quickly this way

Cubbycuddly
 

Answer:Sort icons by date?

6 more replies
Relevance 56.99%

I have a column in an Excel spreadsheet that is formatted as dd.mm.yyyy.

I need something that will read this column and output it as yyyy.mm.dd into a separate filed so Excel will sort it properly in chronological sequence.

At present the "date" sort only sorts on the first 2 numerics, ie dd and sorts then from 1-31, irrespective of the balance of the date field.

Hope someone can help.


Bazza
 

Answer:Need help with an Excel date sort

You would have to do a little work in VB in order to get it to work. I found this http://office.microsoft.com/en-us/assistance/HP052093431033.aspx
 

6 more replies
Relevance 56.99%

Hello,
Is there any way to sort by the most recent date on my phone? Bing gives me only relevance.
Help?

More replies
Relevance 56.99%

My time date function is not stable and goes fast, about an hour a day. I have it set to update automatically AND I can and do manually reset it. But it is wild. I had the same problem on XP home and recently updated to xp pro and updated the whole thing with service pack 2. My computer is a fast emachine and is 3 months old.

Any advice?
 

Answer:Time/date is not stable...goes fast! daily!

8 more replies
Relevance 56.17%

Hello, I am having difficulty getting Excel to sort by date with the following dates:

Column A
09/20/2012
09/21/2012
10/20/2012
02/20/2012

When I select "sort newest to oldest" it sorts the dates this way:

10/20/2012
09/20/2012
09/21/2012
02/20/2012

I have verified that the dates are not formatted as text and have altered the way the date is shown, trying it without the zero and with the zero and nothing changes.

Help!
 

Answer:Solved: Excel Sort by Date

I think I discovered my error, the dates showing 02/20/12 should be 02/20/13!
 

2 more replies
Relevance 56.17%

hi,
when i download photos from my canon camera, they are all put in a folder that is named according to the DOWNLOAD DATE. i'd like the photos to go into folders that are named according to the SHOOTING DATES. this was the behavior of windows in the past and for some reason it changed.
can you tell me how to change this and to get the photos sorted according to the date they were taken?

can you also tell me how to number the photos continuously, instead of numbering from 1 on each new date? i'd like the photos from day one numbered 1 to 14, from day two 15 to 23, and so on.

Answer:Sort downloaded photos by date taken

Hi tamirhoresh

I use the following free application to organize my images as part of my workflow.

cam2pc - Image Viewer and fully featured Digital Imaging software to Download, Organize, Modify and Share your photos

It has a down loader that should work with your camera and will allow much finer control than any of the manufacturers offerings. It will even re-name your existing structure to what you decide to go with

It can actually create folders and image filenames from the files own internal MetaData.

There is a Paid version but have found that the freeware does everything I need.

It is compatible with MS photo programs but actually contains a good set of display options so may even replace them

1 more replies
Relevance 56.17%

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

I've used Outlook Express for many years, so I'm somewhat embarrassed to be asking this question now. I frequently have to locate all the message sent by someone, so click the "From" column header to group the messages by sender. Problem is, I'd also like the message for each sender by in descending date order. I can't find any way to do that; it seems OE will only sort on one column and the date column is random. Is there as way to sort message by more than one column?
 

Answer:Solved: Sort msgs by name AND date

7 more replies
Relevance 56.17%

Hello!

Im looking for a program or batch file to sort files in new folders according to the files date.

I have a huge folder with pictures that I want to sort in subfolders by date.
The subfolders names should be same as files date.
Im running windows xp.

Ive googled for this but couldnt find anything?
So now I need your help

// Regards Per W Sweden
 

Answer:Sort files in new folders by date

16 more replies
Relevance 56.17%

Hello, I recently updated Mozilla Thunderbird and now my sort by date for sent emails isn't working. The sort by date in the inbox works fine. I use sent mail sorting to confirm outgoing messages have been sent. Any suggestions? Thanks.

Answer:Thunderbird sort by date not working.

6/23 new TBird version today. See if it fixes. You are left clicking on "Date", correct?

3 more replies
Relevance 56.17%

Whenever I open a folder and want to "sort by date (modified)", Windows 7 sorts by descending order. I have to click again to get ascending order (in XP this was not a problem). Is there a registry hack or some other way of getting Windows 7 to sort by (modified) date in ascending order when you click on "sort by date"? Various searches have only come up with bogus or obvious answers (e.g., click again to change order, "group by" (which doesn't maintain setting when reset to "sort by date"), etc.). Thanks for any "real" help.

Answer:sort by date (modified) ascending

Go to Utube and request c9CUEUarYQg

6 more replies
Relevance 56.17%

I have input dates into my database table in the short date formula for example: 01/07/2005. Can anyone tell me how to sort these dates in a chronological order? If i try to sort them as they are they just appear in ascending order using the first 2 numbers for example using the above date layout '01'. I have several different years on the database. How can the years and dates be sorted chronologically???Help much appreciated thankyou!!!

Answer:Access 2000 'date sort'

it sounds like you are recording the dates as text. This is why they are being sorted 01/01, 01/02 etc.The easiest solution would be to see if you can convert the field in the table to a date field.If this is not possibel then you could try either the format, or convert function in the query to convert the field to a date, then sort on that.If you need any help on the convert or format function please post back here.

2 more replies
Relevance 56.17%

I understand that by right clicking on the sorting bar you can choose and add dozens of ways to sort your files. How do I apply one (Date Accessed) not just for one folder, but for on the folders on my drive?

Answer:How to sort by Date Accessed in all folders?

I'm assuming this is what you are after.
1. Click the Start Menu Orb and then Search for cmd. Once that comes up Right-Click cmd.exe and SelectRun as administrator.
2. The UAC prompt will appear… Click Yes!
3. Now in the cmd prompt, Type in “ fsutil behavior set disablelastaccess 0 “ and Press Enter.
4. Restart your PC for changes to take affect.

After restart
1. Switch the Window view to Details.
2. Right-Click category bar and Click More…
3. On the next window Scroll down and Check the box for Date Accessed and then Press OK.
That’s it! Now when you do Windows Searches it will pull up and show the Date accessed category.

Hope this helps Dan

1 more replies
Relevance 56.17%

I am using a program that OCR's a page and then creates a folder for it inside an output folder...
Goes like this:
Input folder -> OCR program -> Output folder -> [Folder just for that document]

I keep the output folder open so that i can see the new folders being created for the OCR records, which i can then drag additional files to that records folder.
Since im dealing with thousands of folders im depending on vista to sort by date modified so that the newest one shows up on top.... But im running into a problem

I've done about 700 records now (700 folders have been created) and for some reason the date modified stopped working. Now the new folder is showing up at the end instead of the beginning. If i hit F5 to refresh the window it move to the top where it should be.... but im going through thousands of records and hitting F5 for every record consumes time and makes room for error.

Why did vista stop sorting by date modified? I didnt change anything, all of the sudden it just stopped being consistent. I can restart the computer and sometimes it will start working properly again for about 30 records, but its not guaranteee.

Please help me fix this, THANKS!

More replies
Relevance 56.17%

Hello

How do I sort my files in File Manager (in Windows 10 Pro x64) so that the folders are at the top, and then the files are in date last modified order.

With thanks

J

Answer:How do I sort by foldername, then by file date

ship69 said:

Hello

How do I sort my files in File Manager (in Windows 10 Pro x64) so that the folders are at the top, and then the files are in date last modified order.

With thanks

J



One option is to create a Library with your preference. Don't know why, but Libraries are sorted folders first and then by date (if you select by date of course..)

Creating Library is simple... First make sure Libraries are shown (in file explorer in left tree right click on empty space and select New. Then you add folders.

5 more replies
Relevance 56.17%

Why can't i see this option? Is there some place i have to enable it? I want to be able to sort my files in explorer by the last date modified. Argg!
 

Answer:date modified sort in vista

Right click the folder, select properties, select the customize tab (or press Alt-V, "Customize this folder" from inside the folder) and make sure "All items" is selected from the first drop down.

I wish Vista would always just default to the All items view. It selects a bad default way too often.
 

2 more replies
Relevance 55.76%

It seems like it's always what would seem like the easiest things always turn out to be the the hardest to actually accomplish.

I'm running Netscape 7.1 and right now my email is sorting my various email folders in ascending order by date. I know that by clicking on the date header you can change that sorting to descending order. The problem is that I can't seem to get that change to "save". Everytime I open the email interface the sort order is back to ascending order. What do I need to do to make that change to descending order the default - and to make it stick.
 

Answer:Solved: Sort Email By Date in Netscape 7.1

6 more replies
Relevance 55.76%

Ive got vista x64 and Im tryin to figure out how to sort a folder by the date I DLed the contents. In Xp it was np but I cant seem to get it work in vista. Ive tried Date Received Date Modified Date Taken... everything with Date in the sort type and none of em work they either dont change at all or just end up in abc order. What Im goin for is sorting the contents exactly by date and time of how they ended up in the folder. Any ideas? Also before I forget about it. Ive got a folder on an HDD that wasnt modified when I installed vista I installed vista on a completely new HDD. Now in windows explorer in vista that folder thats on a completely separate drive is missing roughly 100 files completely randomly. Not any specific order I can find to whats missing (date, abc, etc) theyre just not showin up. The file size of the folder doesnt indicate theyve been deleted they just arent showin up.

More replies
Relevance 55.76%

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

I created a folder on my desktop and add images of books I have sold almost daily. With Windows XP, the images would stay in order as I added them, but with Windows 7 they are always in order of the image name.
I have tried using the different sort by date options, but they are always sorted by the image name (which is a 5 digit number). How can I sort them by the date I add them to the folder?
Thanks,
Fritz

Answer:How to sort images by date added to a folder

Hello Fritz, and welcome to Seven Forums.

I would think that adding the column "Date last saved", then having the folder set to be sorted by it would do the trick.

Hope this helps,
Shawn

3 more replies
Relevance 55.76%

can i sort videos by upload date, so the most recent are at the top ? if yes, how ? someone said on the 'results page' , under the search bar, i could 'filter' by uploaded day/wk/mo, or upper right corner of page click 'sort by' ? i don't know what he was talking about . thanks
 

Answer:YOU TUBE : sort videos by date uploaded ?

Yup, see the attached screenshot, you can either use the "Sort By" and select "Upload Date" from the drop down OR use the "Search Options" and then select "Upload Date":
 

1 more replies
Relevance 55.76%

In windows file explorer I am wondering if its possible to list folder first then have the last accessed files right under the folders afterwords. I need to have the ability to see folders first , then last used / modified files. 

If i list folders first now, then the last accessed files comes down at the bottom. 
 

More replies
Relevance 55.76%

Hi!
This has been annoying me a lot.
Let's say I have a folder with many files to which I download to.
On XP if I download a new file to it in order to find it the easiest for me is to SORT BY Date Modified and then it will show at the very last file on the list...easy enough.
In comes Vista 64 and that does not work at all...it still shows up somewhere else.
Any ideas?
Thanks
 

Answer:Help me make Sort By Date Modified the same on Vista as it is on XP please

shaolin95 said:


Hi!
This has been annoying me a lot.
Let's say I have a folder with many files to which I download to.
On XP if I download a new file to it in order to find it the easiest for me is to SORT BY Date Modified and then it will show at the very last file on the list...easy enough.
In comes Vista 64 and that does not work at all...it still shows up somewhere else.
Any ideas?
ThanksClick to expand...

The same feature exists in Vista and Win7. Just be sure to right-click on the headers at the top of ecah olumn to pick the headings you want (be sure to add Modified Date), drag the new header(s) you added to the right position you'd like them -then click on any of them to sort by that column header.
 

1 more replies
Relevance 55.76%

This is a feature I miss tremendously from XP. The closest thing I can do is sort by date modified, and desktop is where I put a lot of my new files. They go all over the place. And if I copy an older file to desktop, they go right in the middle of my icons. And yes, I need a lot of icons on my desktop.
tl;dr: How to sort icons on desktop by Date Created?
 

Answer:W7: How to sort desktop icons by DATE CREATED

You cannot sort by penis.
 

3 more replies
Relevance 55.76%

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

I tried several different sort by date items and not sorts by the date the actual file was added to the folder.

Answer:How to sort by date added to current folder

File Explorer Columns - Add or Remove in Windows 8

5 more replies
Relevance 55.76%

Hi all,

I've been a long time reader of these fourms but first time poster but am looking for any advice on the following.

I use the movie library function to view & play movies that are "ripped" and recorded from TV. I have now 300+ movies and add movies every week. The sort by date added only seems to work for recorded from tv movies but not "ripped" movies. I use My Movie Finder to get the rest of the metadata & folder.jpg i can't work out how date added works.

Anyone else sorted this issue other that using Media Browser/My Movies etc..

Thanks for the advice,

Steve..

Answer:Movie Library sort by date added?

For ease of use, take a look a an app developed by one of our own here @ sevenforums... YAMMM. It will automatically go out on the net and grab the needed meta data, images, etc. It is a great... GREAT time saver! My sort by date works fine!

Oh yeah, welcome to the forum faloony!

1 more replies
Relevance 55.76%

I would like a folder and everything inside it to be sorted by Date Modified in an Ascending order. Can it be done with of without additional programs?

Answer:How do I mass sort files by Date Modified?

Hello.

This should be done by simply clicking Date Modified at the top of the folder window. For ascending order the arrow should be pointed down.

4 more replies
Relevance 55.76%

On my external hard drive, I have a ton of photos from different cameras that retain the weird file-naming scheme that the camera implements so the order is weird and out of whack. I've been wanting to organize these photos and thought the best way to do it would be to sort it by date; however, when I click the sort-by date tab, it takes FOREVER to sort it.

It's weird because this seems to only happen with certain folders and not others within the same drive so I'm pretty baffled as to why this happens and how to fix it.

I tried to do a search on the forum to see if anyone else encountered a similar problem by searching the word "sort" but I came up empty. Any help would be appreciated!

Answer:Problems with Sort by Date in Windows Explorer

Well that was quick... of course I find the solution after I make a post.

I don't know if this solution is permanent but I hope it is. Basically, what I did was I optimized the folder for "General Files" after going to the folder's Properties and clicking the "Customize" tab.

2 more replies
Relevance 55.76%

Hello. If I select Date from the "Arranged By" field in Outlook 2007, it sorts by the date each message was received. I know that I can sort by the sent date by clicking on "Custom", then under Sort selecting Sent. This is a pain to go through all of this, however, since Outlook reverts back to the received date every time I sort by something else or search for an email, etc. I'd like to know if there is a way I can change Outlook so the default date sort is the sent date instead of the received date. I'm fine with editing the registry and what-not if need be.

Thanks in advance,
Micky
 

Answer:Outlook 2007 default sort to sent date

10 more replies
Relevance 55.76%

We have a list of ladies and the dates their babies are due. There's another column in the list with a date that they left our care - maybe moved away or transferred to another office. I'd like to sort the list by due date, unless they have left our care - and then have those ladies at the end of the list. So if the transfer date is blank, sort by due date, with all those transferred at the end.

Advice please? Thanks!
 

More replies
Relevance 55.76%

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

(Running Windows 7 Professional x64 SP1)
I'm a professional photographer and have recently begun shooting with two cameras simultaneously at events. They use different file names to avoid duplicate names/confusion, i.e. IMG_175000 and XMG_175000. Often times I'll take a photo with one camera and then take a photo immediately after it with the other camera and I'd like both of these images to be organized in the same subfolder and shown sequentially, but by default Windows Explorer lists all the "XMG_######" photos at the end and the IMG_###### photos at the beginning. I can manually sort each individual folder by going to "Sort by - Date" or even better, selecting "Sort by - More... and putting a check mark next to "Date Taken" so that it shows up in the Sort options (which it doesn't automatically) and then sorting by Date Taken, but since I'm dealing with hundreds of subfolders with hundreds of thousands of photo and video files I'd like a way to do this for all the files in these subfolders that isn't manual.

Is there a way to make Windows Explorer automatically arrange every file (both image and movie files) inside the various subfolders inside one root folder by Date or Date Taken instead of automatically always sorting them by name?

Thanks in advance!

Answer:Making files in subfolders sort by "Date" or "Date Taken" by default?

Hello XMGING, and welcome to Seven Forums.

If you like, you could set a folder how you like it, then use the method in the tutorial below to apply it to all folders that use the same folder template.

Folder View - Apply to Folders

Hope this helps,
Shawn

1 more replies
Relevance 54.94%

I desperately need to sort my files downloaded using DownThemAll by the date the file was added to the directory. Date created could have been months or years in the past. Date saved could have been months or years in the past. Is there a way to sort the files by the date the file was added to the directory. I need to download to the same general directory in order to avoid dups.

Thank you in advance for your reply.
 

Answer:Solved: Sort Files In Dirctory By Date Added

Howdee to you too.
If it's in Windows explorer, just change the view to detail and press the date column to sort the either ascending or descending,
In Windows 7 you can show more columns by right clicking the top bar just check there, there are quite a few date options.
Hope you can use this
 

2 more replies
Relevance 54.94%

I have a folder of about 20,000 photos from a digicam that I'm organizing for a friend, since I'm rebuilding the system I couldn't bare the mess and had to tackle this too. I've gone through with software to remove the duplicates but now I want to put them into folders labeled by their date created, or date modified. Is there a command for this? Or even a prog.
 

Answer:Command to sort 20k photos into date modified albums?

I use ThumbsPlus to organize my photos. It has an auto rename feature, so you could sort by date and then rename by year/month or whatever, but it's notsuper automated - you would basically need to rename each months worth of files, which may or may not be a lot of work.

It's not super cheap if all you want to do is rename some files, but I think it has a free 30 day trial.
 

17 more replies
Relevance 54.94%

Hi,

Want a macro to sort data from (Column B,C,D,E) with whatever date mentioned in Cell A2.
Column B,C,D,E have different dates what I want is to sort those columns as per the date mentioned in cell A2.
Suppose if in cell A2 the date is 11/26/2009 then it should sort the data from the Column B,C,D,E with that particular date in a new sheet in that workbook.
And would like to assign that particular macro to a button

Please help
 

Answer:Solved: Sort today date with Macro in excel

16 more replies
Relevance 54.94%

All,
Windows Explorer is sorting files on a network drive always by name. It doesn't save sorting by modification date. Where can I reset this behavior?
We had temporarily activated GPOs at "User Configuration," / "Preferences" / "Control Panel Settings." / "Folder Options (Windows Vista and later)." / (Hide Extensions for Known File Types), but I think that's not
directly related.
Thank you in advance.
- Chris

More replies
Relevance 54.94%

I have a folder that I am pasting files into (all cut and pasted to one folder from various other folders) but is there a way to sort the files by the date last pasted (not the date the file was last saved or modified)?

Btw Is this a suitable question for this forum? Or should I sign up for a windows usage forum?
 

Answer:Windows 7 file manger, how to sort by date pasted?

No, you can't do this with Windows.
 

3 more replies
Relevance 54.94%

Is it possible, without scripting in VBA, to sort Outlook 2003 contacts by last saved/edited date? I need to import contacts to my cell phone, which has a primitive mechanism that requires me to manually synchronize with Outlook. This sorting ability would help determine which entries have changed since the last time I updated my phone.
 

Answer:Sort Outlook 2003 contacts by last saved date?

Welcome to the forum.

I found a last saved time field but it did not seem to work for some reason.
 

1 more replies
Relevance 54.53%

I have a music folder with 1,440 files and 38 folders and I like to keep the ones I've just added at the top. When I set the folder to sort by Date, it usually takes about a minute for the folder to show fully. The hard drive is a Seagate Barracuda 7200.10. Is there anything I can do to speed it up? I don't want to put them all on an SSD (12.5GB).

Edit: I fixed it by changing the shortcut I was using from D:\Users\x\AppData\Roaming\Microsoft\Windows\Libraries\Music.library-ms\ to D:\Users\x\Music\.

Answer:Sort by date takes long time for items to show

could you give me more info on your pc

A great way to do this is going to your start menu and at the search typing in dxdiag and hitting enter.

then clicking save all information (this will save it to a .txt file) and copying that information onto here

Thankyou :P

1 more replies
Relevance 54.12%

When I open file explorer and select certain folders, it opens in the alpha sort. When I go to sort on dates, it takes forever in Windows 10, and has pretty much since launch. Don't remember this on Win7. Are there any switches I could throw, or other config changes I can make to address this?

Answer:File Explorer - Folder w/1,300+ files takes >2 minutes to sort by date

I originally misread the thread, after rereading it, decided to remove my original post; I'll be listening in and learning!

2 more replies
Relevance 54.12%

Hoping to get some help on this question please. I have reviewed the forum and found a similar post, but the sample data is more predictable than mine and the Macro posted doesn't work on my data. See post "Excel Macro to Move data in Rows to column" 28-Aug-2008, 05:47 AM".

On my data, I would like to be able to take the yellow row, and move the data up to the previous row starting in column "R". The rows I would like on the same line, all begin with a date. I don't know how to make a looping Macro that will identify the "date lines", and take the "second date line", and move it to the "first date line's" row.

Any help would be appreciated.
I have attached some sample data. (I hope that's okay?!)

Thank you!!!!
Christine

PS - The range on data varies.
 

Answer:Solved: Excel Macro to sort data by date, then move to new cell

Christine,

this macro below works well with the sample data.
Code:
Sub sorting()
Dim Rng As Range, c As Range, i As Long
Set Rng = Range("A:A").SpecialCells(xlCellTypeConstants, xlNumbers)
For Each c In Rng
i = (i + 1) Mod 2
If i = 0 Then
With c.Resize(, 15)
.Copy .Offset(-1, 17)
.ClearContents
End With
End If
Next
End Sub

How it works:
1. Takes all those cells in column A of the active sheet that contain numbers. (Dates are actually numbers, only formatted to look like dates.)
2. In a loop, it takes every second cell of the set of cells selected in Step #1.
3. Takes a 15 cells wide region starting with the cell selected in Step #2, and copies it to the region starting with the cell positioned one row up and 17 columns to the right.
4. Deletes the content of the original 15 cells wide region.

Caution:
1. If there are any numbers in column A besides dates, then the algorithm is wrong and the macro will fail.
2. If the dataset in the second date line is wider than 15 cells wide then the rest will remain in place. But the macro can be easily updated, just change the Resize line.
3. Don't run it twice on the same worksheet.
4. Always make a backup copy of your data before running the macro, because it is not Undo-able.

Jimmy
 

3 more replies
Relevance 54.12%

my mom has 6 years of photos on one of her 500GB HD's. She hates windows 7. Her latest complaint that I have not been able to figure out is folder sorting.

Mom has a folder called "camera dump" in the "my pictures" folder.
In the camera dump she has 6 years of folders containing photographs.

Currently windows 7 is sorting the left side screen like this:

1-18-2013
1-21-2014
2-05-2011
2-05-2012

The problem is mom wants them in proper chronological order.. In other words, all of 2011 in proper order Jan to Dec, and 2012 after that, and 2013 after that.

1-06-2011
2-29-2012
3-09-2013
5-28-2014
Can anyone tell me how to do that? Ive tried just about every sorting option I can find in windows 7.
I suggested to her that she use YEAR master folders, then put the months inside as sub folders.

Thanks.
 

Answer:How do I make windows 7 sort photo folders by year, month, date?

11 more replies
Relevance 49.61%

Every disk and/ or folder when I tick sort by name-ascending the damn thing reverts to date modified-descending if I leave said disk or folder and return. I tried "Enable_Auto_Arrange_in_File_Explorer.bat" and "Reset_Folder_View_Settings_of_All_Folders_to_Default.bat" courtesy of Brink to no avail.

Is there a way to get file explorer back to default sort (by name-ascending) for all disks, folders and sub-folders at once?

It was all fine last week and I've no recollection of playing with any settings. Very frustrating.
Thank You.

Answer:File explorer sort reverts to "date modified"

Solved by reinstalling. Pity but also got rid of a lot of rubbish.

1 more replies
Relevance 49.61%

Every disk and/ or folder when I tick sort by name-ascending the damn thing reverts to date modified-descending if I leave said disk or folder and return. I tried "Enable_Auto_Arrange_in_File_Explorer.bat" and "Reset_Folder_View_Settings_of_All_Folders_to_Default.bat" courtesy of Brink to no avail.

Is there a way to get file explorer back to default sort (by name-ascending) for all disks, folders and sub-folders at once?

It was all fine last week and I've no recollection of playing with any settings. Very frustrating.
Thank You.

Answer:File explorer sort reverts to "date modified"

Solved by reinstalling. Pity but also got rid of a lot of rubbish.

0 more replies
Relevance 49.61%

Hello there & Happy New Year.

I have encountered this particular inconvenience on the 2nd day of 2012 while i was transfering photos and files into my PC with Win7.

In my Win7 PC, all files/folders created or modified within Dec'2011 and earlier are now all grouped under as "A Long Time Ago". This happens when I changed the folder to be "Group by Date" or "Group by Date Modified" with a combo of "Sort by type". I tried sorting in different ways of view to see if I can get it back to what it should be. Then i realised even folder newly created on 25 Dec 2011 is also grouped as "A Long Time Ago" too. I am not sure if this is an intended feature.

The only helpful part is that i will still see the newer files in chronological order if I sort by date modified on top of group by date modified.

I have been using this setting for folder view even for Win XP. As for Win XP, i will get "Yesterday", "Last Week", "Last Month", "Last Year", "Two Years Ago" and ultimately the whole chunk of much older files under "A Long Time Ago". Such perfect chronological order.

I tried to google for a while and not much of returns to this issue I am having. Perhaps majority of people does not group their files/folders in such way. But for me, I like the way how it was displayed that I know i have edited/created/moved whichever files/folders last year, the previous month or ... Read more

Answer:Win 7 sort by date issue - 2011 files/folders now "A Long Time Ago"

Same for me! Must be a Windows 7 thing, and hopefully someone at Microsoft is onto a fix.

4 more replies
Relevance 49.61%

Is it possible to add "Date Created" to the 'Sort By' menu for every folder in one step rather then having to add it manually to folders?

Answer:add "date created" to global Sort by menu??

Maybe: sorting - How do I add the "Date Created" sort-by option to the shell in Windows 7? - Super User

1 more replies
Relevance 49.61%

Hello!
I have been trying to get this done for Windows 10 and wow is driving me crazy. It seems that the tweaks I find work for some folders but not for folders there I have photos which is exactly where I want to be able to do this.
I always have to go through the options and add the Date Modified first. Gets very annoying so maybe some expert out there can tell me how to do this?

Thanks!
 

More replies
Relevance 48.79%

The win 7 start menu download folder item on the right sorts by name. This is very annoying. I cannot find a download unless I know its name. If by date I just look up a recent download at top of list.

How do I change behavior so downloads in start menu (right column) sorts by date?

NB. I changed the folder properties in explorer so the download folder sorts by date. It does there no problem. But not in the start menu.

Rob

Answer:sort start menu download menu by date not name

What a worthless feature to sort by name when it is downloads. I am checking for a registry work around, but it is a slow bushiness for me.

1 more replies
Relevance 46.33%

hi help me please.

Problem signature
Problem Event Name: BlueScreen
OS Version: 6.1.7600.2.0.0.256.1
Locale ID: 1033
Extra information about the problem
BCCode: 1000007e
BCP1: FFFFFFFFC0000005
BCP2: FFFFF80002F6B93E
BCP3: FFFFF88002FF5A48
BCP4: FFFFF88002FF52B0
OS Version: 6_1_7600
Service Pack: 0_0
Product: 256_1

Answer:Daily Daily Blue Screens on win7 64bit

  
Quote: Originally Posted by freeangel


hi help me please.

Problem signature
Problem Event Name: BlueScreen
OS Version: 6.1.7600.2.0.0.256.1
Locale ID: 1033
Extra information about the problem
BCCode: 1000007e
BCP1: FFFFFFFFC0000005
BCP2: FFFFF80002F6B93E
BCP3: FFFFF88002FF5A48
BCP4: FFFFF88002FF52B0
OS Version: 6_1_7600
Service Pack: 0_0
Product: 256_1



Freeangel hi and welcome
Most of these point to a memory exception. caused by several different thins. Your video driver, USBPORT, and others. to get a handle on this we should first verify you memory. Everything should be set to default no over clocking

Download a copy of Memtest86 and burn the ISO to a CD using Iso Recorder or another ISO burning program. Boot from the CD, and leave it running for at least 5 or 6 passes.

let us know the results
Ken

8 more replies
Relevance 46.33%

Hi,please help - this has been going on for a long time. I get daily error messages, especially when using the net. These windows then shut down once I've had to click "ok" on the error message dialogue box and then I'm back to my desktop.These errors have so far been:EXPLORER CAUSED A GENERAL PROTECTION FAULT IN MODULE KRNL.386.EXE AT 0001:00003a48.EXPLORER HAS CAUSED AN ERROR IN OLE32.DLLEXPLORER HAS CAUSED AN ERROR IN unknown>,KERNEL32.DLLACRORD32 HAS CAUSED AN ERROR IN COOLTYPE.DLLOLE32.DLLKERNEL32.DLLRPCRT4.DLLKERNEL32.DLLMSHTML.DLLGDI.EXEDDHELP HAS CAUSED AN ERROR IN DDRAW.DLLWININET.DLLCOMCTL32.DLLWININET.DLL.There have been other error messages, but I am losing patience with having to write them down all the time.If the computer is just left to automatically hibernate after inactivity, it sometimes crashes as well and won't "wake up".I have also had the following: WINDOWS PROTECTION ERROR. YOU NEED TO RESTART YOUR COMPUTER. SYSTEM HALTED. (this is on a blue screen)Does anyone have any idea what's going on? My PC is a pentium 4 1.4, running off Windows ME with 128 RAM. I would really appreciate the help as I have a dissertation to write soon and I don't want to risk losing 20,000 words worth of work!!!Thanks.

Answer:Multiple daily error messages, daily crashes

I can't help with this but suggest you backup your work now.

10 more replies
Relevance 45.1%

I have discovered some disconcerting behavior in how excel 2010 sorts. I have information in a worksheet that gets added to everyday. Once a week that information gets copied in bulk and pasted into a new sheet in the workbook to get sorted. On a straight copy paste operation some of the information that is in columns bfore the sort column are changed from their original values. When I copy then paste special values and formatiing this does not occur.
Has anyone else observed this behavior and if so does anyone know a better fix?

Answer:Excel 2010 sort issue data in columns prior to sort column change

BF
Tried to replicate this in my Excel 2010 without success. Copied cells Sheet1/A1:A12 to Sheet2/C1:C12 with data in preceding columns A & B. On selecting 'Sort' for C1:C12 I get a window informing me there is data next to my selection and since it is not selected will not be sorted. There are then two options: Expand selection or Continue with current selection. Selecting second option sorts data normally.

1 more replies
Relevance 45.1%

Once you have setup your named groups in the Start Menu is there a way to sort them alphabetically? Also, can you sort each item with a group as well?

Thanks!

More replies
Relevance 43.46%

Hi I have this assignment for school, I think I did everything except the step number 9 and 11, it seems I do something wrong or not sure about that. How to SORT THE DATASHEET in descending order and how to Sort YOUR TABLE in ascending order? Is there difference how to sort "your table" and "the datasheet".
Also in step 10) they are asking to close the datasheet view without saving changes, does it means I just right click on the table and "close it"? Sorry for my explanation, but it is difficult for me to explain this things and ask right questions. I attached the steps I have to do, I believe I did everything except the step 9) and 11)
I have Access 2013)
1. Create a Database named YOUR NAME_DRIVERS
2. Create a Table in DESIGN VIEW
3. Define the following fields as follows:
FIELD NAME DATA TYPE DESCRIPTION
DRIVER ID AUTONUMBER IDENTIFICATION NUMBER
FIRST NAME TEXT DRIVER'S FIRST NAME
LAST NAME TEXT DRIVER'S LAST NAME
AGE NUMBER DRIVER'S AGE (No decimals)
COUNTRY TEXT DRIVER'S COUNTRY OF ORIGIN
(USE TAB OR ENTER KEY TO MOVE FROM ONE AREA TO THE NEXT ONE)

4. Create a Primary Key on the field DRIVERID

5. SAVE YOUR TABLE AS: LOCATION

CLICK ON DATASHEET VIEW TO SEE TABLE

6. ENTER THE FOLLOWING DATA:

(DO NOT TYPE DRIVER ID-AUTONUMBER WILL DO IT)
DRIVER ID FIRST NAME LAST NAME AGE COUNTRY
1 MARIE GRAHAM 32 GERMANY
2 LOUIS BENNETT 23 UNITED STATES
3 ARMAND ORTEGA 26 VENEZUELA
4 CARL GILMORE 33 UNITED STATES
5 JOSH GON... Read more

Answer:how to sort datasheet and how to sort tables-what is the difference pl

Hi florida2001. When you set up your table did you create a field for each item?. In other words do you have a field for 1st Name & a new field for Last name & a new field for each of the others.
If you do have separate field for each then for your (9) answer Select the Last name field & click the Filter icon from the Home view & sort descending order order. This should give you the name in the first record closest to Z.
For (11) answer Select the Age column & then in the Home view Select the Binocular icon, it will ask you to find what, so type in 32.
Hope this helps. I also use Access 2013.

4 more replies
Relevance 42.23%

I am running windows xp media edition on a dell dimension 3100.
I am having trouble with internet searches, being told that I am infected and that I should download from a link to cure it and windows security saying that it is not set to automatic updates. When I check in control panel the automatic updates are set as they always have been but the icon on the lower right of my desktop says that my computer is at risk due to auto updates being turned off.
When I try to carry out a google search using mozilla firefox usually nothing happens, as if it is taking hours to carry out the search.
I know very little about viruses and am afraid to do much without expert advice as I don't wish to do further or irreparable damage to my system.
I have run deep scans with nod32, spybot s+d, vundo.exe and lavasoft ad-aware all of which get rid of things which soon come back.
Please help me with this as I have very little idea what to do for the best, thank you.

Answer:I Think I Have A Virus But I Don't Know What Sort, Some Sort Of Spyware I Think.

Hello and welcome. Please Run theses 2 scans and post back their results,thanks.S!Ri's SmitfraudFix Please download SmitfraudFixDouble-click SmitfraudFix.exeSelect option #1 - Search by typing 1 and press "Enter"; a text file will appear, which lists infected files (if present).Please copy/paste the content of that report into your next reply.Note : process.exe is detected by some antivirus programs (AntiVir, Dr.Web, Kaspersky) as a "RiskTool"; it is not a virus, but a program used to stop system processes. Antivirus programs cannot distinguish between "good" and "malicious" use of such programs, therefore they may alert the user.http://www.beyondlogic.org/consulting/proc...processutil.htmNEXT:Please download Malwarebytes Anti-Malware and save it to your desktop.alternate download link 1alternate download link 2Make sure you are connected to the Internet.Double-click on Download_mbam-setup.exe to install the application.When the installation begins, follow the prompts and do not make any changes to default settings.When installation has finished, make sure you leave both of these checked:Update Malwarebytes' Anti-MalwareLaunch Malwarebytes' Anti-MalwareThen click Finish.MBAM will automatically start and you will be asked to update the program before performing a scan. If an update is found, the program will automatically update itself. Press the OK button to close that box and continue. If you encounter any problems whil... Read more

20 more replies
Relevance 42.23%

I just updated to Windows 10, and have a Hotmail account. I want to mass delete a number of emails, but don't see how to do that or how to sort the mail.

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

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%

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%

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%

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%

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%

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%

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%

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

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%

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

This is about sorting dates and scores using excel. I need to have the sort take place each time I put the information in without having to manually do it. I was told that a macro needs to be used.I sort dates by oldest to newest. I drop the oldest and replace it with the newest then sort. I use excel 2010.

Answer:I am trying to get my sort to automatically sort.

Yes, you need to create and use a macro for that.

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

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%

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%

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%

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%

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

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%

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

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

I accidentally formatted the date cell & it only accept numbers

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

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

2 more replies
Relevance 38.54%

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

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

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

3 more replies
Relevance 38.54%

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

Thanks in advance!
 

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

That's not a Julian date, Beth.

That is actually a date value that Excel provides.

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

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

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

Learn lots about dates and times in Excel:

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

Be prepared to be there for a while.

Happy Thanksgiving!
 

2 more replies