Computer Support Forum

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

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

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.

Relevance 100%
Preferred Solution: How sort by 2nd field (date) without grouping when date changes?

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: How sort by 2nd field (date) without grouping when date changes?

7 more replies
Relevance 106.19%

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

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

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

Hello,

I have a large report of application forms which have been submitted including the date when they were submitted however the dates are formatted incorrectly.

1. Although the cell formatting is dd/mm/yyyy the data is being shown in mm/dd/yyyy which means the dates are incorrect (e.g. 2nd January would read as 1st February.)
2. As a result of this dates which are passed the 12th of a month are not accepted as dates (it reads the day figure as months and there is no 13th month etc)

I have tried to use the text to columns function but that makes no difference and I have tried to extract just the dates but I've had no luck.

Can anyone help, I've attached a small sample of the data.

Thanks

Daniel
 

Answer:Exported date field not recognized as date in Excel

Where does the data come from?
What do you get if you have no cell format?
 

3 more replies
Relevance 97.58%

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

I use due dates on my Outlook tasks. When I customize my Tasks list (in the Calendar view) to group by due date, I just get too many groupings (one for each due date!). I would like to know if I can create a custom field called 'Due Month' and/or 'Due Week', extracted from the 'Due Date', so I can view my tasks by what is due during a given week or month. If the answer is yes, any suggestions on the technique I would use would be greatly appreciated.
Thanks in advance,
Mac
 

More replies
Relevance 92.66%

I need a date field changed into a text field of YYYYMMDD so for example the date of birth field is 3/17/1953 and I need that converted to 19530317 in the Excel spreadsheet. Thanks.

Answer:I need a date field changed into a text field of YYYYMMDD

under the format options.

5 more replies
Relevance 91.84%

I'm hoping someone can help me with this....

I am grouping by week. The issue that I have is the grouping date that I am using does not always have activity for every day.

Example weeks go Sunday to Saturday
for week Sept 12 thru 18th there is only data for the date of spet 15th. So in my grouping header it used the 15th as the start date.

I want to be able to list start date and end date for each week.
It would look like this.

9-12-2010 to 9-18-2010
9-19-2010 to 9-25-2010
 

More replies
Relevance 91.84%

I created a pivot table using a sum of values under the date and line by line for each customer (it is an order book), once I had this set up it gives customer with a total value under the dates on which they are forecast. I then clicked on the date and told it to group by month and year, this worked fine and I had a total per month for each customer.Once I sent this out for data to be checked and dates amended I tried to update the table so as to use the updated dates, the grouping element came off so I had individual dates across the top again, no problem, click on date and group again - got the message "Cannot Group this selection". o matter what I do it will not group, even starting the pivot tabel from scratch and it comes up with the same error.I can't understand why it works one minute and happily groups then decides it can't do it, anybody any ideas at all please?Craig

Answer:Grouping by date in a pivot table

click here may help.

3 more replies
Relevance 91.84%

I have an agents worksheet and sold worksheet. The sold worksheet has a list of sold properties in it including the agent code, selling price and sale date.

My problem is that i need to display commission by agent for a specified time period. I placed the commission at the end of the sold properties list. I have no problem with calculating the commission.

I can't figure out how i can display commission by agent for a specified time period. I created a criteria range to be used for advanced filter but how am i going to so-called 'link' my agent code and sale date from my sold worksheet with the agent details in my agent worksheet to be displayed in another worksheet to be filtered?

Or am i going about it all wrong? Is there an easier way to get all this done?

Sold Worksheet
PropertyCode..Branch..SaleDate..AgentCode..SellingPrice..Commission
.......1.............East......1-1-03..........5...........430,000........7,985

Agents Worksheet
AgentCode...FirstName...LastName...Branch
.....5.............Dany..........Lim...........East

And lastly i have a criteria range for my startDate but i'm unsure of how to end up getting commission by agent for a specified date. I'm guessing it requires some sort of grouping but i don't know how to. Please Help!
 

Answer:Grouping and date problems [urgent!]

Please describe better:

so-called 'link' my agent code and sale date from my sold worksheet with

Exactly what are your groups?
 

1 more replies
Relevance 88.56%

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

Not sure how to go about this. I am not a programmer by any means but need to make a program.

I have a text file that is in what is called BAI format (bank standard format to send info). Basically this is a CSV file with a header. Right now I use a mail merge file to update the date field. I am looking to automate this so I would only need one "dummy" file and have a program that will update the date field automatically. The file is opened with notepad. I have done some VB but not a lot. I am looking for the best way to go about doing this. I tried to get some of the programmers to do it but no one wants to worry about supporting it, so I am taking a crack at it.

All help is very much appreciated. One idea I had is maybe a macro in excel but not sure if it would mess up the formating. I will try to get a copy of the file I use and post it.
 

Answer:Updating date field

6 more replies
Relevance 85.28%

Is it possible with Access 2010 to have a date field that would change to current date whenever another particular field is modified. For example, we have comment field and we would like to have another date field that would change to the current date when the comment field has a change.
 

Answer:field modified date

Yes you can do it with simple VBA code, you could also add it to the comment itself, so it appears at the beginning of the comment.
 

1 more replies
Relevance 85.28%

Hi,I'm trying to create an if formula and I'm a bit stuck.Column L contains dates separated by commas. I'm trying to create a formula to say:if L2 contains (fixed date from a single cell) then "Exclude" else "No"There are two issues. How do I make the if statement contains not just equals? How do I copy the cells down and keep the field with date in fixed?For example I added the date I needed to 'Delivery sheets d1':=IF(Data!L2='Delivery sheets'!D1,"exclude","No") but when I try and fill down the D1 continues in a series e.g. d1, d2, d3 etcI hope this makes sense. Thanks in advance!

More replies
Relevance 85.28%
Question: Update date field

Thanks in advance for your help!

I used to know this and I did a search and couldn't find the answer.

How do you update a field to a date either 6 months away or 12 months away for the current date in that field?

Thanks again!
 

Answer:Update date field

6 more replies
Relevance 85.28%

I work with MS Access 2003.

I am creating a query to show all contracts set up in a certain year that have been cancelled in that specific year. This "Cancelled" field is not a yes/no field, but includes the date on which it has been cancelled (always starting 31/12/YYYY).

First, to show me the contracts set up in a certain year (say 2008) , i created a parameter under the "Contract Year" field, asking which year you want to see (in this case 2008).

I wish to add a criteria that then shows cancelled contracts at the end of that specific year, so 31/12/2008. So whether it is "2008" or another year is dependent on the value in the "Contract Year" field.

I tried the following as criteria for the Column "Cancelled":

#31/12/[Contract Year]#

to try and have it take the year mentioned in that field.
But it doesn't work. Access sees is as a second parameter, instead of a field name.
I tried adding LIKE to it and the &-sign, still no luck.

Is it possible to use a field name in a date criteria and if so, how could i do it?

Thank you very much in advance for your help.
 

More replies
Relevance 84.46%
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 84.05%

hi, i searched in vain for an answer to this question:
when i edit an image file and resave, the date modified date does not change. since i started using computers 100s of years ago, this was automatic. how can i enable this (obvious) field? what point is there in even having a date modified field if it stays the same as the date created field? thanks!

Answer:date modification field does not change

Are you sure you have the Date Modified selected as a column to display?

Right click on the header column (has Name, Date, Type, etc.) and select the Date Modified tag.

9 more replies
Relevance 84.05%

Hi guys,

Something weird is happening. Some of my movie files (file type doesn't matter) became corrupted; when I play them in VLC they cause errors, they were just fine before and nothing has changed. I noticed in Explorer that these files have no Date Modified field, it's simply blank; I've never seen anything like that.

I did a chkdsk on the drive and see no errors. What could it be ?

Thanks.

Answer:Blank Date Modified Field ?

VLC should rebuild the Index, but that is a temporary fix. Depending on what format they are, there is "DIVFIX" and "Meteor MKV repair" you can try to run the faulty content through which of those is appropriate, you'll have to google it, cant remember the links.

3 more replies
Relevance 84.05%

Hello everyone,

I'm working on an order management database and I'm stuck on one item.

I have a form that users can fill in with purchase order data. One section of the form relates to contract review completion.

I would like to have a checkbox that the user can check when contract review is complete, but I'd also like for a completion date field to be auto-filled when the checkbox is checked.

I've tried a couple of things, both unsuccessful.

Any ideas?

Thanks.
 

Answer:MS Access - autofill date field

6 more replies
Relevance 84.05%

Hello, I need help with the following:
I have a field (called Date_Time) which displays for example 1/31/2005 12:00:00 AM. I would like to run a query that converts that value to '200501' in a created field.
I tried the following below but I keep having problems.

select Account_Number, Date_Time,
concat(year(Date_Time), month(Date_Time)) as Date_Time_Modified
from table
where Account_Number = xxxx

Any insight into this would be greatly appreciated. Thank you.


 

Answer:Concatenating Date and Time Field in SQL

Just wanted to add some more examples:

Account_Number: Integer Type
Date_Time: Date Type
Date_Time: Modified: Character Type

Account_Number Date_Time Date_Time_Modified
3246 1/31/2005 12:00:00 AM 200501
4920 11/30/2008 12:00:00 AM 200811
5932 6/30/2011 12:00:00 AM 201106
... ... ....
 

1 more replies
Relevance 84.05%

Is there a way to insert a date merge field where the date is spelled out (June 10, 2008) and will not change if the document is reopened, resaved, modified, etc?   Thanks for any help!

Answer:MS Word merge field for date

I'm not quite sure I understand the question, but depending on the Word document...you can use the "Insert" link from Word's toolbar to insert the date into a document...formatted to your liking.Once the document is saved...the date will always appear as you have set it.

2 more replies
Relevance 84.05%

Can someone help please?

I'm setting up a query in Excel from an SQL database. How do I (or what do I) do to ensure only todays data is shown - I suppose I'm looking for an"=TODAY" type thing but don't know enough to be able to do it.

Thanks in anticipation.

Moll )
 

Answer:Excel query on Date field

it can depend on how the date system is set up but the following page has pretty much every SQL date function going

http://www.connx.com/products/connx/Connx%208.5%20UserGuide/sql_date.htm
 

1 more replies
Relevance 83.23%

How do you insert a date field in Word 2007?

Answer:How do you insert a date field in Word 2007?

In Office 2010 at least, it should be under the "Home" or "Insert " tab. Then there should be a sub-category like "Date" or "Time".By the way. In the future, you'll get better office results here:http://www.computing.net/forum/offi...Ask and Answer. The way of learning.Dell Dimension 8300Intel Pentium 4 HT @ 3.20 GHz4 GB RAMNvidia Geforce FX5200

2 more replies
Relevance 83.23%

I receive periodic Word (.rtf) documents from a property rental agency whenever my property is rented. The document contains the dates rented, the renter's name, etc. There is a "date field" in each document which automatically shows today's date, rather than the date the doc was created and sent to me. If I want to forward the doc to the renter a week later how do I stop the date from updating when I send it and stop it from updating when the renter opens the file?
 

Answer:Solved: Stop Updating the Date Field

6 more replies
Relevance 83.23%

I have tried sending a message to a friend who, up until now has had no problem receiving. The message I am sending has no attachments. But this message has come back several times with the message:

This message has been rejected because it has
an overlength date field which can be used
to subvert Microsoft mail programs
The following URL has further information
http://www.securityfocus.com/frames/?content=/templates/article.html?id=61

but when I go to that hyperlink it is a page saying that the item 'might' have been removed.

Incidentally I have an uo to date virus checker running and have been able to send and receive emails to others since the first bounce of this email

Questions:
1. Is this a genuine response or some sort of problem at receivers end?
2. If genuine can someone explain what I might need to do, if anything can be done, at my end to get the message through. I have already tried maing the subject line smaller but that made no difference.
 

More replies
Relevance 83.23%

the answer to this might of been found with a search but hey i'm lazy today and wanted to see who the excel masters are

using excel 2007, cell a1 contains an array formula (CSE) like so - {=MAX(LEN(A2:A470000))}
cells a2 through a470000 contain dates such as
12/12/2011
etc, you get the idea, i need the formula or something else entirely to return 10 not 5

thanks in advance
 

Answer:Solved: excel length of date field

i'll answer if myself thanks to another web site, Mike these guys are slackin' 'round here it looks like

=MAX(LEN(TEXT(A2:A470000,"m/d/yyyy")))

exit celll with ctrl, shift, enter
 

1 more replies
Relevance 83.23%

Have sent email to several friends, there is no attachment, just relatively straight forward item with some borders and a table in the email body copy. In one case the email was bounced back as 'delivery failed' with the message:This message has been rejected because it has an overlength date field which can be used to subvert Microsoft mail programs The following URL has further information click hereHave gone to hyperlink which says 'page removed'. Other emails I sent to this friend get through. My questions are:1. I assume this is a genuine block?2. Has anyone come across this and do you know what it means?3. Is there something I can do to get my message through? [I had put a lot of work into it]Many thanks Tiggertwo using Outlook Express and windows95

Answer:Email bounced 'overlength date field'

Sounds like some sort of anti spam program which is a little too zealous. Have you tried it again to the same user?

1 more replies
Relevance 83.23%

I want to combine a text field and a date field into one field to use as a reference number. IE 'Mil - 05/11'.

I have got a field with the standard short date format 29/05/2011 (that I have to keep) and I have created a second field with the same date but formatted to a "mm/yy". When I concatenate the Operater Ref field "Mil" to the Date Ref field "05/11" I still get the full date format IE Mil - 29/05/2011.
 

Answer:MS Access Concatenate a date and text field

Jerry-

If you are creating the second field in your table, go to design view and change the Data Type to Text then try your concatenation. I built a mini-table and queried it and this worked for me... hope this works for you!
 

19 more replies
Relevance 83.23%

Hello,Have a Excel file with multiple sheets , each sheet is identified by the persons ID numberSee attached file.Here i need to copy data from FILE1 in each sheet to FILE2As you see in file1 that data for each person is scar tared , that is date are up and down ...that data need to be moved to file2 where already date from 21 oct to 20 nov is marked.THANKS

More replies
Relevance 83.23%

Hello,Have a Excel file with multiple sheets , each sheet is identified by the persons ID numberSee attached file.Here i need to copy data from FILE1 in each sheet to FILE2As you see in file1 that data for each person is scar tared , that is date are up and down ...that data need to be moved to file2 where already date from 21 oct to 20 nov is marked.THANKS

Answer:Moving rows with Date field from one worksheet to another

Quotei need to copy data from FILE1 in each sheet to FILE2I'm wondering about the wording of the quoted part of your post.  I suspect it would be better worded like this: i need to copy data from each sheet in FILE1 in to corresponding sheets in FILE2.   Is that correct?  Are FILE1 and FILE2 names of separate Excel files?

14 more replies
Relevance 83.23%

I am trying to add a sequential number to a date field in an Access form.
The format of the field is PS 18 Jan 11 xx, the PS is fixed, the current date and the xx is my sequential number I want to add.

Is there a way, to do this when the date is entered? And I would need the sequential number to reset to 01 with a new day.

I'm new to this, any help would be great!

Thanks!
 

Answer:Help in appending a sequential number to a date field

16 more replies
Relevance 83.23%

Greetings

It's been a long time since I last posted here, but hopefully all you wonderful people will be able to help...

Here is my problem:

A customer of mine has a SQL database where one of the fields is a date/time field that looks like this:

13/02/2003 14:32:58
14/02/2003 08:59:10
15/02/2003 17:09:37

Now, I need to delete all the records for a particular day (One of their HD's failed, and they had to restore the data and lost a day, but the entries are still in the database, and can not be re-entered until the old entries are deleted).

How do I structure a query to delete all the records for a particular day? Preferably, I would like a SELECT statement first, just to check that the records found correspond to the delete criteria, and then the DELETE statement.

Thanks

Reuel Miller

The Ex-NT moderator on this board

Every morning is the dawn of a new error
 

Answer:SQL Query help required with date/time field

Greetings

Not to worry chaps, I figured out the answer all by my lonesome

the statements I used were:

select * from {database name} where {date field} > '14 February 2003' and {date field} < '15 February 2003'

delete from {database name} where {date field} > '14 February 2003' and {date field} < '15 February 2003'
cheers

Reuel Miller
 

1 more replies
Relevance 83.23%

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

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

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

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 ... Read more

5 more replies
Relevance 83.23%

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

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

More replies
Relevance 82.41%

I have an excel sheet with dates displayed in European format dd/mm/yyyy :-)I import it into a letter ("you have been a member since") and it imports in American mm/dd/yyyy.I can't see how to properly format the merge field

Answer:Mail merge a date field screws the formatting!

It all has to do with how your Operating System Date is set up.If your in the US then the default is mm/dd/yyyyYou can change how Excel Displays the date to dd/mm/yyyy, but it Stores the date in the System Date format of mm/dd/yyyy.When you import the date to Word, the System Date format is used.See here for how to change the format:http://cybertext.wordpress.com/2009...alsohttp://www.ashbee.co.uk/index.php/f...MIKEhttp://www.skeptic.com/

4 more replies
Relevance 82.41%

Hello,

In Access, I am trying to develop a process for generating a unique client number that follows a very specific formula: XXX - XXXX - X - XXXX. The first group should represent the quarter and year when the client is first introduced (non-standard year: Feb-Jan). The second group should be a unique, sequential ID number with leading zeros (missing numbers won't matter and leading zeros seems impossible, so I'm planning to use a DMax calculation on the form that generates a sequential number). The third number represents the client's initial program phase ID. The final number relates to the grant contract ID.

I have generated the number with the following in a Select query:

UniqueNumber: DatePart("q",DateAdd("m",-1,[MonthStart])) & Format([MonthStart],"yy") & "-" & [SeqNum] & "-" & [InitialPhaseID] & "-" & [ContractID]

The table already has a primary key, but since I am required to generate client numbers in this format, I want the UniqueNumber to be saved and searchable. This field never needs to change once the original record is saved. I've tried an Append query, but can't make it work. I assume it's related to the fact that I'm combining Date and Number fields, not to mention the DatePart function. I consistently get a key violation error. Any thoughts on how I can proceed?
 

More replies
Relevance 82.41%

Hey everyone,

I'm having problems with Access, where I have a date/time field, which stores a month and a year (successfully), but still automatically assigns the first date of the month in question.

I used the following input mask (00/0000;;_) for the date field, and so far I haven't had any troubles with putting in a month and year. So far so good. But when I complete the date and move on, Access changes it to a full date. e.g. 06/2010 --> 01/06/2010.

Now, I'm actually fine with this part, my only problem is that I don't want it to do this in forms (both datasheet and normal view) or reports.

I heard something about using a Format (http://office.microsoft.com/en-us/access/HP010990151033.aspx) to adjust the display, but I can't seem to get that to work. Is there any other way to tell Access how to display the date field, like what can be done in Excel?

This is rather urgent as I have a project due tomorrow and this problem (as well as others) have now been reached and I'd like to solve them as soon as possible.

Any help is appreciated, and I look forward to your responses.
 

Answer:Solved: Urgent: How do you format the DISPLAY of a date field?

8 more replies
Relevance 82.41%

I want to be able to place the date in reverse order in the subject line of new emails when I press a button on the toolbar. The format of the date should read '20061003' for the 3rd Oct 2006 - I know i should be able to use a macro or write VB scipt, bit i am not that clever - please help - many thanks

Answer:MS Outlook 2003 - Reverse Date in Subject Field

06.10.03 - subject.It's easier to read and there will not be a filing problem for the next 94 years or so.I'll leave the technical stuff to others

8 more replies
Relevance 82.41%

The company I work for has asked me to work with the DB (as you may well guess in this economy I now have to learn how to work with Access DB. This DB was created by someone who had a book “Access 2000 for dummies” in 2002, I have since then converted the 2000 DB to 2007 accdb format. That being said, in a form that is used to track records-TS# is the primary key, they want a YES/NO or actual name- Completed *check box for yes and blank for no*. I created the check box as you may know that was easy enough. The problem comes in when I go to the next record the box remains in whatever state it was on the previous record and does not show up anywhere else. I am sure this is likely because there are steps that I am omitting or not aware of. Any help offered would be amazing as I continue to work on this train wreck.

-Mike
 

Answer:Solved: Access 2007 YES/NO field with time/date

Mike, the Check Box field has to be in the Table that the Form uses as it's Record Source. The Check box has to be "Bound" to that table's field, i.e. it's "Contorl Source" of the check box in design view must be the table field.
 

2 more replies
Relevance 82.41%

I have a linked Excel spreadsheet to show invoices received and I insert a date when they are paid. I cannot figure out the expression to use to show all records where no date has been inserted. Can anyone help please.Thankyou

More replies
Relevance 82.41%

Hi guys, I'm very new to access and I'm having some issues. I have made a field for an expiry date, and I have attempted to create a calculated yes/no field that gets ticked when the expiry date is up, so basically I have a box that I want ticked for when the expiry date is before the current date (I hope that makes sense). Thanks guys,

George
 

More replies
Relevance 82.41%

I have a field that is date/time, formatted to display the long date (which starts with the day of the week). This has been extremely useful for some append, update and delete queries.

However, I would like to be able to do an update query based on the day of the week for each record. I know that the date/time field is stored as a number so I can't search for any string of letters. But, is there a way to take the long date format and copy what's there as a string so I can then extract the day of the week out of it? Otherwise, I guess I'm stuck with adding a separate field for day of the week, and manually inputting it. Seems like such a waste.
 

Answer:Solved: Access, Date/Time Field to String -- is it possible

7 more replies
Relevance 82.41%

This one has got me. Has anyone figured out a way to do this easily? I can create a new column and extract the right characters and make it work ... but just wondering if there is a quicker way out there!

Thanks in advance for your time/help ...
 

Answer:Excel: Extract hour ONLY from a date/time field

Ok, got it to work ... but not sure if there is a better way.

I created a 2nd colummn and used the =RIGHT(D107,5) to isolate the time (10:32) from the date/time field (JAN 12,2014 10:32)

I then created another column and used =TIME(HOUR(C107),0,0) to pull out the hour ONLY in 10:00 AM format.

Is there a quicker way out there?
 

2 more replies
Relevance 82.41%

Hi all,

I am looking for help on VB script to send automated emails based on the date column in excel sheet..

Uploading the excel sheet as well. The email should trigger on dates in column F to corresponding email addressed in column E ..

The email body should say :
Hi,

Your employee "Column C" is approaching his probation period on "Col D". Kindly confirm if you want to confirm on the date of "Column D" or modify it.
 

Answer:Need help to send automated email based on the date field

Have a look at the attached I have written the code necessary however if you have any changes you would like made let me know.
 

1 more replies
Relevance 82.41%

I have a Date field in a Form. I want the Date to be appear in red when it is more than 6 months older than today's date. Where and how do I make that happen?
Thanks
 

Answer:Access 2010 Date Field in Form Macro or ()Iff ??

10 more replies
Relevance 82.41%

Hello

Access 2003
Windows XP

I am creating a new table and would like to format a field to short date. Here is my code. Is there a way to format to short date from here?

Thanks

Set fld = tbl.CreateField("Date", dbDate)
fld.Required = True
tbl.Fields.Append fld
 

Answer:Access 2003 - Format field to Short Date

try this:
fld.NumberFormat = "m/d/yyyy"
 

3 more replies
Relevance 82.41%

from email address removed by Dreamboat

I have a database with a date field; 'Birthday'.

I want to take the month info from the date field and have access put it into another (adjacent) field. Ie;

Name:
Addr:
Birthday:
Month of B'day (New Field)

Also I want to be able to query the birthday field from previous data base tables which do not have the month field and make a table with the month information extrapolated to a new 'Month of B'day' field.

(Month([Birthday])) does not work.

I have printed a report with the 'Month of B'day" info extrapolated to the report but it is not useful because the report does not sort by the new information.

I know these must be possible but . . . . . AAAaaagh I'm going nuts.
 

Answer:Solved: Extrapolate Month from an Access date field

16 more replies
Relevance 82.41%

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

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

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

Hello!

I´m 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.
I´m running windows xp.

I´ve googled for this but couldn´t find anything?
So now I need your help

// Regards Per W Sweden
 

Answer:Sort files in new folders by date

16 more replies
Relevance 82.41%

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

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

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

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

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

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

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

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

Access 2007 Update Query For Updating A Date Field

Hi I have been asked to write a query for an Access 2007 db

I need to update a date field in a table based on another date field in the same table

1st date field is the person's start date (StartDate)
2nd date field is the person's project date (ProjectDate)
Without going into too much detail, the Project Start date always begins on the 1st of the month

If the person's StartDate is between the 1st - 14th the project start date is counted as on the first day of the StartDate month/year

If the person's StartDate is between the 15th - end of month the project start date is counted on the 1st day of the NEXT month

Example:
StartDate = 7/1/2011
ProjectDate = 7/1/2011

StartDate = 7/14/2011
ProjectDate = 7/1/2011

StartDate = 7/15/2011
ProjectDate = 8/1/2011

StartDate = 7/30/2011
ProjectDate = 8/1/2011

I would like to update the ProjectDate in an update query

Any suggestions? Thanks
 

Answer:Access 2007 Update Query For Updating A Date Field

Create a Column heading like this
numdays: format([StartDate], "dd")
or
numdays: datepart("dd", [StartDate])
this will give you the day of the month on it's own
add a second Column
NewProjdate: IIf([numdays]>14,Format([StartDate],"mm")+1 & "/01/" & Format([StartDate],"yyyy"),Format([StartDate],"mm") & "/01/" & Format([StartDate],"yyyy"))

This will give you the date to use in the update query.
 

3 more replies
Relevance 81.59%

I am furious at not knowing why my date/clock in Windows 7 keep changins its appearance. It is as if the files or settings for Windows change mysteriously back and forth and I don't like it one bit.

The issue pertains to this clock/date shown at the bottom right corner on the screen just beside the system tray.

Sometimes it tells me the clock and no date or anything else is shown.
Some hours later it changes mysteriously to show the clock and the date format I once set, so that I get to see the day of the week, the date in numeral and the month in letters, and finally showing the year.

Something appear to be horribly wrong in Windows and I have no hope fixing it.

Only hope here is if this issue is familiar to other people.

Answer:Weird behavior by Windows 7, clock/date field changing

Do these changes happen when you hover your curser over the date? A few screenshots would be helpful!

9 more replies
Relevance 81.59%

While searching for some information in some old files, I noticed that every time I open a Word document, using Word 2007, the "date modified" shown in Windows Explorer automatically updates and changes the file properties to reflect the current date and time. I make no changes to the file and at no time am I asked to “Save” the document, which would justify the update of the “Date Modified” field.

This happens in both Vista and XP.

Is there any way I can change this setting? I only want the date modified to change when I actually make a modification to the document.
 

Answer:How to stop updates to Date Modified field in Windows Explorer

7 more replies
Relevance 81.59%

I want to add a validation rule to a date/time field in Access 2010. This worked in 2003 and I'd like to know why it won't work now.

The rule is

Is Null Or <= Date()

I have entered this through the expression builder as well as typing it to avoid typos.

The error message is:

Unknown function 'Date' in validation expression or default value on 'Artists.Date edited'.

I am doing this at work: we are running Windows 8, Server 2012, Access 2010 via virtual desktop.

Any help would be gratefully received!

Thank you
Alison
 

Answer:Solved: Access 2010 date field validation problem

Alison, welcome to the Forum.
I think you will find that this is an Access problem of Access 2010.
You may be able to overcome it by using Now() instead of Date().
If not I can provide you with some simple VBA code that will do the same thing that may work.
I have also seen advice to open a new 2010 blank database and import everything in to it to solve this problem.
 

2 more replies
Relevance 81.59%

Good day guys

My puzzler today (and has been for ages) is this:

In my Access report, I pull in "StartDate" and "EndDate" fields from the calling form and wish to display them as part of a report subtitle.

I therefore have a field called "DateDetails" in my report header whose ControlSource is:
Code:
="Records Selected between " & Forms!Reports!StartDate & " and " & Forms!Reports!EndDate
The dates actually derive from a table and the date format for both fields in that table is "General Date".

The result is that the report shows the following as an example:
Records Selected between 17/05/07 12:00:07 and 10/08/07 12:00:07

BUT what I want is the following:

Records Selected between 17/05/07 and 10/08/07

or even nicer

Records Selected between 17-May-2007 and 10-August-2007

Can this be done in such a control?

Chris
 

Answer:Solved: Access 2003 - Date Format in a Calculated Field

7 more replies
Relevance 81.59%

How do I stop update of date field in Word? I set the date to original date and try to save as PDF but it updates on save.

Answer:can't stop date field in Word from auto update in old docs

What did you do to get the Date, Insert --> Date and Time?Or did you use a DATE FIELD:If you are using: { DATE } Then it will always display TODAY'S date.If you are using: { CREATEDATE } Then it will display the date the document was created or saved using Save As.MIKEhttp://www.skeptic.com/

2 more replies
Relevance 81.59%

I've searched the forum and can't find the help I need...perhaps I'm not using the right keywords.

Anyway, I want to automatically have a time stamp entered in a field named "CancelDate" if a yes/no field named "Cancel?" is checked. On the form I use an action button for that field.

I'm new with VBA, but after some research I entered this code in the AfterUpdate line in Properties:

Private Sub CancelDate_AfterUpdate()
If Me.txtCancel?.value = 1 Then Me.txtCancelDate = Now()
End If
End Sub

...and it doesn't work. It seems to hang up because of the question mark. I get a Compile Error: Expected:Then or GoTo.

Can anyone help me?
 

Answer:Solved: Access 2007 Record Date When Field Updated

10 more replies
Relevance 81.59%

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Windows repeatedly asks me to update with the little yellow exclamation mark in the tray but it always fails and then keeps asking over and over again. It's trying to update something I don't even use I think PowerPoint or something; I had the option off at one point for those programs so it wouldn't keep asking but then a message pops up saying are you sure you want to leave these off you might need them.

Any ideas on how to get past this?
 

Answer:Windows Update...date...date...date....

Have a look at this link and see if it helps.

http://support.microsoft.com/kb/910339/en-us
 

1 more replies
Relevance 80.77%

When items are loaned out we want them returned in 30 working days (approximately 6 weeks I'm not going to bother trying to calculate holidays) but to only come back on a week day Monday through Friday.

Field Name ReturnDate_Fld this needs to be calculated as 30 working days from the current date

or should I not worry about the extra effort and use the approximate by adding 42 to the BorrowDate_Fld (plus 42 days = 6 weeks)

Should I worry about this in a form or only set it as field in the report/query?
 

Answer:Solved: Access 2010 Set a date field to today plus 30 working days

16 more replies