Computer Support Forum

Comparing a date in column against today's date

Question: Comparing a date in column against today's date

In excel I am trying to compare a column of various dates against the current date (reported in one cell using the =today() function) and if the dates in the column is past today's date it will report "Late" in the adjacent row or if the date in the column is the same as the current date it will report "Due" in the adjacent row. "If/then" doesnt seem to work. I have thousands of columns of dates but simplied exampleCurrent Date = 04/21/2014Column A, Column B, Due Date, Status, 04/12/2014, Late04/21/2014, Due

Relevance 100%
Preferred Solution: Comparing a date in column against today's date

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: Comparing a date in column against today's date

First, a posting tip...If you click on the blue line at the bottom of this post, you can read the instructions on how to post data in this forum so that the columns line up and your data is easier for us to read. It may take some trial and error via the Preview screen, as explained in the instructions, but it can be done. Second, you told us what you want if the date to be checked has past or is the same as TODAY(), but you didn't tell us what you want if the date is later than TODAY().I assumed you want a blank cell.

A B
1 =TODAY()
2 Due Date Status
3 4/12/2014 =IF(A3<$A$1,"Late",IF(A3=$A$1,"Due",""))
4 4/21/2014 =IF(A4<$A$1,"Late",IF(A4=$A$1,"Due","")) Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.message edited by DerbyDad03

3 more replies
Relevance 93.67%

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

=IF(ISNUMBER(MATCH(D13,Status!B:B,0)),INDEX(Status!BD:BD,MATCH(D13,Status!B:B,0)),0)BD column is a date. I have two colums with the Column BD reference.1.) If the date is in the future it will populate a blank and if date has past it will produce date in cell.2.) If the date is in the future it will populate date and if in the past it will produce blank.I have tried adding >today(),"" and I guess I've stared at this too long and can not fix it. Or I'm adding it in the wrong place, missing a comma or something. Appreciate your help. :-)

Answer:BD column is a date. I need to add a statement ....today

I'm having a bit of trouble figuring out what you are trying to do by just seeing the formula.Would it be possible to post a few pieces of example data and the expected output based on that data?Please click on the blue line at the end of this post and read the instructions on how to post example data in this forum. Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

4 more replies
Relevance 104.96%

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

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

--
Terry, East Grinstead, UK

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

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

2 more replies
Relevance 103.73%

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

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

Hi Everyone,

I have a date column in my spreadsheet and there are several actions that I would like to apply to it -

1). Auto populate the date column with the current date only when the column to the left has data entered into it (please see below)

2). Make the date column read only so that it cannot be modified by other parties.

Any help will be greatly appreciated.

Kind Regards,

Davo
 

Answer:Solved: Automatically enter date into a column and make that column read only

6 more replies
Relevance 91.84%

Greetings,

I know that this is a Windows 7 forum, but I thought I would give it a try.

My ultimate goal is to have a vbs script run after a certain date on a computer image.

I thought that this would be best done with a simple batch file. In Windows XP, whenever you would create a Scheduled Task and run Sysprep, the task would not run because it loses credentials and must be restored in order to work. I don't know if this is true in Windows 7, but not to take the chance, I'm thinking using the Registry Run option to point to the batch file each bootup.

I think it might be simple to do, but I can't figure it out. I'm open to other options as well. But for now here's my for example,

if "%date%"=="Fri 10/28/2011" echo %date%

I need it to check to see if it's "Fri 10/28/2011" or any day after, so something like...

if "%date%"== or >"Fri 10/28/2011" echo %date%

Thanks!

Answer:Need help with DOS Date comparing

The task scheduler has had major improvements since xp.
I use mine to run similar tasks all the time without issue.

9 more replies
Relevance 91.43%

Filename: SysInfo.exe
Full Path: c:\Users\JIMBO\AppData\Local\Microsoft\Windows\INetCache\IE\RBAGCWGH\SysInfo.exe

____________________________

____________________________
Developers
Not Available

Version
1.0.0.2

Identified
6/27/2016 at 5:17:31 PM

Last Used
Not Available

Startup Item
No
____________________________
Many Users
Thousands of users in the Norton Community have used this file.

Mature
This file was released 4 years 8 months ago.

Good
Norton has given this file a good rating.
____________________________
Source File:
sysinfo.exe

____________________________
File Thumbprint - SHA:
8243b4ea661b060fe8cf4babc11ab5f51eadd28a0c9d66303183e8eceace8234
File Thumbprint - MD5:
Not available
 

Answer:excel Today's date (year) - cell date (year

11 more replies
Relevance 90.61%

I have a key drive that I use for transferring my Minecraft to other computers so I can play my mods and saves on any accessible computer, but I come across a problem concerning the logic for transferring to and from my computer. On other computers I just need to download, play and reupload which I figured the coding for thanks to this site, but for my home computer I dont always have the key drive plugged in to run a script like that and to make sure I dont save over a newer version/save with an old one I need a way to get and compare the modified dates so that older versions/save get auto saved over with the newer ones.

I get I'll nee the FOR process but the %%~t command is for created date, what is the one for modified?
 

More replies
Relevance 87.33%

I have a field for data a appoinment is for in an access table and i need to apply validation to allow entry of todays dat or anydate after today.
I have tryed stuff like ">=Now()" or ">Now() and =Now()" but nothing works please help
also can anybody help with my other problem about No changes to certain field in a table or form
see

http://forums.techguy.org/business-applications/495256-access-no-editing-certain-field.html
THANKS
 

Answer:Solved: Access Date Today or after today

If this is the same field as the first post then you will be stuck with the default value of Now() or Date().
If it is a different field then in the validation property use >=Date().
Date() is used when you do not need to store the "Time" as well as the date, Now() stores the Date and the Time.
 

2 more replies
Relevance 86.51%
Question: date column

This morning I updated to the latest BitDefender and while doing so their instructions did not indicate to not select uninstall as the installer would complete this task automatically even though a message did pop up asking me to uninstall. I believe this was the reason for the errors that followed regarding this new install.
I also believe this may have caused the problem in windows 10 control panel uninstall date column becoming empty.
Prior to this BitDefender issue, the windows 10 control panel uninstall date column was not empty.
I have searched extensively for why this date column would be empty, but no answers seem available.
Obviously, this is not an issue with BitDefender that I need to contact their support; it must be something with this OS.

More replies
Relevance 85.69%

The workbook is a log of video clips from a granny cam. It spans a period of approx 3 weeks, there is a row for each clip - a total of approximately 1900 clips. There are columns for date, time, clip no., length, and notes on the clips. Our problem is the date column is arbitrarily changing random dates. They are easy to spot b/c of the time column, since the videos were motion activated that dates would obviously change at 12:01 am. The problem for ex.will be a date or several dates of 8/16/08 mixed in with 8/15/08, and it progresses that way throughout all the rows in the workbook with no discernable pattern. The workbook also updates the dates with daylight savings time changes. (I would like to stop that as well).

Answer:Random changes in date column

Are you the creator of this spreadsheet?If not I would speak to the person who created it and ask that they modify it to suit your needs.Sounds like you might have several macros running, if it auto updates.MIKEhttp://www.skeptic.com/

4 more replies
Relevance 84.87%

HI, I hope someone can help me here. I have a table. Column A is a month (numeric), Col B is year (numeric), Col C is a monetary value. For each month there are a variable number of entries, so the table would look something like below (shortened example - each month normally has about 70 to 80 entries:A B C1 2010 35.991 2010 27.991 2010 15.992 2010 12.992 2010 45.993 2010 33.993 2010 23.993 2010 56.99Each month, new data is added so the columns keep extending.OK, to the right of this table, I sum each month, i use K,L,M columns for thisK contains the calculation, L the month, M the YearK L Msumifs 1 2010sumifs 2 2010sumifs 3 2010I am using SUMIFS at the moment, as follows:K1 = SUMIFS($C$2:$C$2000,$A$2:$A$2000,L2,$B$2:$B$2000,M2)K2 = SUMIFS($C$2:$C$2000,$A$2:$A$2000,L3,$B$2:$B$2000,M3)This does work, but I continually have to adjust the "2000" in the example to be the full length of the columns as they continues to grow as i add new data for new motnhsI am sure there is a "proper" way to do this, but I just don;t know how. Any help would be very much appreciated.

Answer:Excel sum by date on growing column

Use just the column as a reference. Example A:AI'm still learning everyday.

3 more replies
Relevance 84.87%

lets say I have columnslike,name code date statusabc 132 27/05/2017 00:00:00 Activeneed to change the date to sysdateI need to create a batch script for thismessage edited by Gourab

Answer:How to change date of a column in a .csv file

Batch? Really? Not VBScript? Not PowerShell?Also, you say you have a .CSV, but I don't see any commas. How To Ask Questions The Smart Way

2 more replies
Relevance 84.87%

Currently have Excel 2003 and have day of week in one column (F3:F30)- Formula (=j3-d3) formatted as Number/Custom/dddd.
Also have date in Column G which represents the date I arrive in a town, and column J is the day I depart.
In columns F and I are the days relating to dates in columns G & J.

If possible I would like "Saturday 18 July 09" to appear in cell F3 and "Sunday 19 July 09" in cell I3 with resultant formula being dragged down page as necessary.
Columns G and J to be cleared for other useage.

Copy of spreadsheet attached

Pedro
 

Answer:Solved: Day of week and Date in same column

Solved.
Went to Format /Number/Custom and inserted the option

HTML:
[$-C09]dddd, d/mm/yy

This produced

HTML:
Sunday, 19/07/09
Pedro
 

1 more replies
Relevance 84.87%

Hi,

I have a column containing set of dates; i need to get the dates exactly after two months to appear in next column automatically. e.g, I have cell with date 6-Feb-09, I need 6-Apr-09 to come in next cell automatically. Which formula can I use it?
 

Answer:Solved: 2 month later date in next column

6 more replies
Relevance 84.87%

I have created a macro that filters information and have created a submacro that updates information after the macro runs. Here is the submacro:

Sub macro1()
For MY_ROWS = Range("L65536").End(xlUp).Row To 1 Step -1
If Range("L" & MY_ROWS).Value = "CANCEL" Or IsDate(Range("L" & MY_ROWS)) Then
Rows(MY_ROWS).Hidden = True
End If
If Range("L" & MY_ROWS).Value = "N/A" Or IsDate(Range("L" & MY_ROWS)) Then
Rows(MY_ROWS).Hidden = True
End If
Next MY_ROWS
End Sub

What I need now is to add a column in front of A1 and calculate a new date, which would be the date in column L minus two days. Is this possible or would I need to have column A blank 1st rather than inserting a new column? By the way, column A already has data.

Thanks for your help.
 

More replies
Relevance 84.87%

I am changing a current report we do from excel to access. I have a column for sales for the day, sales for the same day last week, week to date sales, month to date, and year to date sales. I have a form which i enter the sales date into, it runs the queries and puts them into the report.

Right now, I have to enter the parameter for the beginning of the week date too. I am trying to make it automatically enter the beginning of the weeks date (Monday) based off of the one date that I enter.

The way it figures the month to date is from queries for each month Example( >=#6/1/2010# And <=[FORMS]![REPORT DATES]![ZZZDATE])

Week to Date = (>=[FORMS]![REPORT DATES]![WKDATE] And <=[FORMS]![REPORT DATES]![zzzdate])

How do I make it find the beginning of the week, without having to enter the parameter?

I am using Access 2003 on Windows XP.
 

Answer:Week to Date Sales Column

Charliana, wlecome to the Forum.
I almost missed this question as it does not have Access in it's title.
You can calculate the Monday's date based on the Curent Date on the Form and use that in the Query's Criteria.
You can also use the
between #6/1/2010# And [FORMS]![REPORT DATES]![ZZZDATE])
in the query
 

1 more replies
Relevance 84.87%

I have a spreadsheet with bank transactions and want to insert a blank row every time the date in column A changes. Can someone help me write a macro to do this? Thanks!

Answer:excel: insert row when date in column changes

Hi MarvinHere is something that might work although you should try it out on a copy of your workbook.
Sub AddRow()

NoRows = Range("A" & Rows.Count).End(xlUp).Row

For i = 2 To NoRows

If Cells(i, 1) <> Cells(i - 1, 1) And Cells(i, 1) <> "" And Cells(i - 1, 1) <> "" Then
Cells(i, 1).EntireRow.Insert
i = i + 1
End If
Next

End Sub

3 more replies
Relevance 83.64%

BC friends,I have a couple of esoteric questions to ask of Windows gurus. Your advice may help me correct a couple of annoying Windows XP S2 behaviors.1) SECURE/NONSECURE error msg which interrupts browsing and thinking flow constantly. This makes for time-outs and annoyances during online sessions.I generally use SlimBrowser or Foxfire for browsing. It seems like about 1/3 the time when I click to go to a new URL, I get interrupted by a dialog Y/N message box, displaying the message:-----------"This page contains both secure and nonsecure items.Do you want to display the nonsecure items?"-------------After about the 2,000th time of being interrupted, I'm becoming neurotically irritated about this! Is there any way to set Windows or the browser to turn this thing off? It's getting to be a real pain to be blocked every other time I click on something!2) ?? IN DIRECTORY LIST - I have a desktop and a laptop. My desktop somehow (I think it was after a backup?) got set so that it inserts "?" (QUESTION MARK) into date strings of a directory listing.E.g., ?3/?25/2008 ??9:43 AM ?11/?22/?2007 ??10:03 PMHow do I correct this. I assume it is some configuration setting or Registry thing, but I've not heard of this before.3) ACTIVEX [prohibits something] - In Slimbrowser & IE I often get messages about ActiveX settings... a) Case 1 - An error message tells me that ActiveX is set to prohibiting something. Of course, it doesn't tell ... Read more

Answer:Xp - "display Nonsecure?"; ? In Date Column, Activex

Hi,For your first question do this to eliminate the warning message:When you get the error message, click YesIn Internet Explorer, go to Tools--> Internet Options--> click the Security tab--> In "Select a zone..." window make sure Internet is selected--> Click Custom Level--> Scroll down about half way to "Display mixed content" in the Miscellaneous section. Change it from Prompt to Enable.Click OK, Yes, and OK. In Firefox, I guess the following would work:Go to Tools--> Options--> Security--> In 'Warning Messages' at the bottom, click 'Settings'--> Untick the last box to the left of: 'I'm about to view an encrypted page that contains some unencrypted information'--> ok--> okI don't know about SlimBrowser because I have never used it.I am not sure about your second question, so I'll leave it to someone else.As for your last question, I am not clear about the Active X error message. Are you talking about the 'yellow bar' that appears at the top of the Internet Explorer window? What does it say exactly?

1 more replies
Relevance 83.64%

I have a column with dates in format yyyy/mm/ddI copy dates from other files that has the date format yyyy-mmI would like the dates with the format yyyy-mm to change to yyyy/mm/dd when I paste them in my column. I have already set the format in that colum to be yyyy/mm/dd, the way I want it but still the dates I copy does not changes their format.Please if anyone have some ab code that could help me with this do tell me and were I chould save it. I have already tried many ways but does not get it to work, and I can't download any converter to do the job for me. So Thank you for helping.

Answer:Change date automatic in an excel column

I copy dates from other files that has the date format yyyy-mmIs the other file an Excel file?After you have copied it, does it left justify in the cell?If you apply a Custom Format of General does it change into a number?MIKEhttp://www.skeptic.com/

18 more replies
Relevance 83.64%

please helpI have formula called =IF(ISBLANK(T964),"",TODAY()) in Column Sand i would like VBA code to update with the date and freeze, don't update everyday. below VBA code i havebut seems to be not working. please help.Private Sub Worksheet_Change(ByVal Target As Range)If Target.Column <> 19 Then Exit SubApplication.EnableEvents = FalseTarget.Offset(0, -1).Value = DateApplication.EnableEvents = TrueEnd SubDim astrLinks As VariantastrLinks = wbNew.LinkSources(Type:=xlLinkTypeExcelLinks)' Break the first link in the active workbook.On Error Resume NextWith wbNew.Sheets(1) .Select .Unprotect .BreakLink Name:=astrLinks(1), _ Type:=xlLinkTypeExcelLinksOn Error GoTo 0 .ProtectEnd With

More replies
Relevance 83.64%

I am using excel to develop a stock management sheet. The worksheet (called Action Sheet) is laid out with code(A), name(B), date(C), action(D), user(E) and quantity(F & G).The name column uses the cell formula [=LOOKUP('Action Sheet'!A:A,'Chemical Lookup'!A:B)] to update itself from another worksheet (Chemical Lookup) when an entry is made in the code column.I want to a similar task in the date column [=IF(A2>1,$I$1,"")] (I1 is =TODAY()) when an entry is made but want the date to remain static for the entry i.e. I do not want the date to change when I am making further entries on a different date.Please help as this is beginning to drive me nuts!

Answer:Stop the automatic update of a date column

Hi,You can't do that with a formula.Depending on your exact requirements, it is likely possible with some Visual Basic code.To clarify:When a code is entered in Column A and the code value is greater than 1, you want a date stamp in the same row in Column C.Question 1:Will the value entered in column A ever be changed, and If so do you want a new date stamp.Question 2:Why is your lookup on the value in column A based on a value greater than 1.What is in the cells in column A before you enter a valid code number.Regards

14 more replies
Relevance 83.64%

Hi,I have the following problemI enter a date into cell "K6"I then have a command button with an assigned macro to paste the date to two locations on the same worksheet, "D5:D6" (merged cells) and to the next blank cell in Column "R"What I require is to ensure that the date entered cannot paste to the desired locations if the date already exists in Column "R"I attach the macro as followsSub datepaste()
'
' datepaste Macro
If MsgBox("Is the Competition Date Correct?", vbYesNo Or vbInformation, "Date") = vbYes Then
' date is entered in to this cell
Range("K6").Select
Selection.Copy
' date is pasted into this range of merged cells
Range("D5:E5").Select
ActiveSheet.Paste
' date is pasted into the next blank cell in column R
nxtRow = Sheets("SCARD").Range("R" & Rows.Count).End(xlUp).Row + 1
Sheets("SCARD").Range("K6").Copy _
Destination:=Sheets("SCARD").Range("R" & nxtRow)

Else
MsgBox "Please re-enter the Correct Date", vbCritical Or vbOKOnly, "Date"
End If
End SubAny ideas as I think the check between the Date entered in "K6" and what exists in Column"R" must take place before the first line of the above macro.Any assistance or ideas of how to overcome this would be greatly appreciated.

Answer:stop date being entered if it already exists in a column

First, there is no need to Select the ranges you want to perform the Copy and Paste operations on.You don't do it for the Copy/Paste for Column R, why do it for D5:E5? I have modified that section of your code.The following code will check Column R for the Date in K6 before presenting the confirmation message box. You will note that I moved the instruction to determine the last Row in Column R to the top of code so that it can be used to set the Range that .Find will use.Sub datepaste()
'
' datepaste Macro
nxtRow = Sheets("SCARD").Range("R" & Rows.Count).End(xlUp).Row + 1
With Sheets("SCARD").Range("R1" & ":R" & nxtRow)
Set d = .Find(Range("K6"))
If d Is Nothing Then
If MsgBox("Is the Competition Date Correct?", vbYesNo Or vbInformation, "Date") = vbYes Then
' Date is Copied and pasted into this range of merged cells
Range("K6").Copy _
Destination:=Range("D5:E5")
' date is pasted into the next blank cell in column R
Sheets("SCARD").Range("K6").Copy _
Destination:=Sheets("SCARD").Range("R" & nxtRow)
Else
MsgBox "Please re-enter the Correct Date", vbCritical Or vbOKOnly, "Date"
End If
Else
MsgBox "Date Already Exists. Please Try Again", vbCritical Or vbOKOnly, "Date"
End If
End With
End Sub
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

4 more replies
Relevance 83.64%

I want to have 7 columns with headings Mon 14/4/2014 Tue 15/4/2014 etc through to Sun with a vacant column between each main cell with no headingsI want to be able to alter the Monday date only and all cells will change to the correct day & dates across the spreadsheet automaticallymessage edited by ASFRon

Answer:need to auto fill day & date in column headings

with a vacant column between eachHere is one way to do it:In Column A enter you Monday Date as you normally would,then for Tuesday, in column C, your next date column, enter the formula:=A1+1For Wednesday enter, in column E=A1+2For Thursday enter, in column G=A1+3etc. etc.See how that works for you. MIKEhttp://www.skeptic.com/

9 more replies
Relevance 83.64%

please helpI have formula called =IF(ISBLANK(T964),"",TODAY()) in Column Sand i would like VBA code to update with the date and freeze, don't update everyday. below VBA code i havebut seems to be not working. please help.Private Sub Worksheet_Change(ByVal Target As Range)If Target.Column <> 19 Then Exit SubApplication.EnableEvents = FalseTarget.Offset(0, -1).Value = DateApplication.EnableEvents = TrueEnd SubDim astrLinks As VariantastrLinks = wbNew.LinkSources(Type:=xlLinkTypeExcelLinks)' Break the first link in the active workbook.On Error Resume NextWith wbNew.Sheets(1) .Select .Unprotect .BreakLink Name:=astrLinks(1), _ Type:=xlLinkTypeExcelLinksOn Error GoTo 0 .ProtectEnd With

More replies
Relevance 83.64%

I have a date column displaying all payment dates.

Is it possible for the user to query by year only, thus displaying payments only from the desired year? [DD/MM/####]

I know how to set up input queries, but am not sure how to prompt for only the year correctly. Thanks for any help!!
 

Answer:Date Column, Query Criteria only Year

6 more replies
Relevance 83.64%
Relevance 82.82%

One change I dislike in Win 10 is the 'Date' column. This seems to be the same as Date Created, which I rarely want to see. By far the most useful date for me is Date Modified, which was the standard in XP. How do I set that as the column that will always appear in all folders please, replacing 'Date'?

--
Terry, East Grinstead, UK

Answer:Changing default Date column in File Explorer

If you right click in the column title area you can turn on "Date Modified" and disable "Date Created".Then in the ribbon at the top, on right hand side click "Options". Then View tab, then "Apply to folders"

7 more replies
Relevance 82.82%

How do I convert a date that appears in 3 columns to a single column date i.e. column A has MONTH( Jan shows as a 1, Feb as a 2), column B has DAY(I.E. 3 OR 4 OR 10) and column C has Year (2 DIGITS 2010 shows as 10 or 2011 as 11)..want to convert to signle column 01/03/10...

Answer:in excel convert 3 column date to single colu

Concatenation (&) of values from multiple cells creates a "text string".DATEVALUE converts a text string into a date as long as Excel can recognize the structure of the text string as a date.Putting those 2 facts together, try this:=DATEVALUE(A1 & "/" & B1 & "/" & C1)

4 more replies
Relevance 82.82%

Just like the title says, when I click the detail view, it only shows Name and Size. Don't even know how this happened, is there anyway to fix this?

Answer:Programs and Features missing installed date column

Hi Xirw If you right-click on the columns, you should have a context menu displaying various column names and whether they are enabled (checked) or not (not checked). Just check the "Installed date" in that menu and the column will appear.

3 more replies
Relevance 82.82%

Col A has dates over last years. The rest of the table has production results from various machines on each day since. Each day a new row of production tonnages added. I would like to have a formula to add the tonnages produced from a given date, 3/8/2009 until today =today()Cannot change the existing basic data table!Table:A B C Ddate tonnage Mach 1 tonnage Mach 2 tonnage Mach 3and so on....I hope you can help me, breaking my brain.

Answer:Need to sum from a lookup date until today

Please read the How To referenced in my signature line and repost your data in columns to make it easier for us to read. Include some example numbers and the expected result so that we don't waste time trying to guess at what your data looks like. Keep in mind that we can't see your spreadsheet from where we're sitting.That will save all of us some time and energy.Posting Tip: Before posting Data or VBA Code, read this How-To.

2 more replies
Relevance 82.82%

I maintain a web site using DW8 but I'm having trouble displaying today's date on the template. Has any one got a "fool's" guide or code I can use please?Many thanks

Answer:How do I insert today's date

click here

2 more replies
Relevance 82%

I need to Enable Date Accessed Column for All Windows Explorer via registry or GPO,
Instead of using this Option View->Add columns->choosing Date accessed.
Need to apply these settings for all user machines. 

More replies
Relevance 82%

Hi,
I want to lock a range of cell ( Column) after data entry. Cell should lock automatically.

for example if D2= today(), then range of cell from D3 to D20000 is ediatble otherwise cell should be blocked.

No body can touch cell for yesterday or tomorrow...

cell should be open only for the date...

pl help, its urgent
[email protected]
 

More replies
Relevance 81.59%

I am looking to make an IF statement for the following:In cell J1 there is a date in it and I want I1 to read "Calibration Due" if the date in column J is less than or equal to 45 days from today's date, and remain blank if this is not true.Any help would be great!Thanks!

Answer:IF statement in Excel using today's date

Try:=IF((J1+45)>=TODAY(),"Calibration Due","")MIKEhttp://www.skeptic.com/

4 more replies
Relevance 81.59%

i have a gantt chart that i am using to plan tasks and i would like to hide columns of the Gantt chart that have already past their date in Row 1 starting in Cell H1 and going to the right.

Answer:hide columns that have date before today

Sorry guys never mind i just ended up freezing the panes so as you scroll a long the columns are hidden. something simple and no code.

2 more replies
Relevance 81.59%

There is a file shared by my group where we track work orders scheduled by date. Column 1 contains a list of dates, in order, like so
5/30/06
5/31/06
6/01/06
etc.
Sometimes, when you open the file, someone else has scrolled up or down the page, so if you want to view today's date, you have to scroll up or down to find it. What I would like to do is create a macro that takes you to the cell containing today's date. I tried creating a macro that did the following:
1- Go to a cell containing a formula =TODAY()
2- Copy the value of that cell (this will be today's date)
3- Open the Edit --> Find window
4- Paste in the value I just copied
5- Click find

This worked great on the day that I created it, but today, it still goes to yesterday's date. When I look at the macro, what it's doing is always searching for the value that "TODAY" had on the date I created the macro. It's not smart enough to actually paste in the value I copied, but instead sees it as FIND: WHAT="5/30/2006"

Is there a way to use the Find or CTRL-G, or any other formula to take me to the cell containing today's date? It seems like this should be a simple thing, but I just can't figure out a way to make it work.

Thanks for any help you can offer!
 

Answer:Excel: Go to cell containing today's date

If you have a cell on the worksheet with =Today() in it, that cell will always show the current date. You look up that in your macro and use that to find your current date in the data.
 

3 more replies
Relevance 81.59%

Currently i using microsoft Excel 2000, i put formula =IF(A1<>"",today(),"") in cell A2. When i key in all my entry data in cell A1, cell A2 will auto prompt up today date.But when i save the file and open it in next day all the date  in cell A2 became new date not yesterday date or previous date.How to kept  the previous date without when open the file on the day.Anyone can give advices???

Answer:Today and previous date problem

HiEvery version of Excel lacks compatibility with both later and earlier releases.What works for one version may need adapting for the next version.This solution works on OpenOffice spreadsheets, and with luck you can do something similar with Excel 2000.1) After creating your spreadsheet, select the cell(s) or columns which have "dynamic" dates and click COPY.2) Choose a suitable destination and use Menu controlsEdit > Paste SpecialUncheck options "Paste All" and "Formulas"Check options "Text" and NumbersExperiment with other options if the first attempt is not quite right.3) Paste to your chosen destinationThat should give exactly the same appearance as the original data, but it is now static and will not get recalculated when the date or any other parameter changes.If you wish you can select and copy a complete sheet and then select a different sheet as destination for a paste special.You MAY be able to do a paste special direct on top of the source - but Windows get confused at the best of times and this could easily push it over the edge !!!RegardsAlan

1 more replies
Relevance 81.59%

Whenever I boot my PC, the date is always a year from the current date. I go into the date and time settings and reset it, but the next time I start the machine a year has been added. The same thing occurs if the PC is on past midnight. At 11:59:59 the date will be 1-29-2001, but then it becomes 1-30-2002.

This is a 3-month old Gateway P933. Gateway says this is 'impossible' and that some software must be setting the date incorrectly. I've run 2 virus checkers (nothing found) and don't have any unusual programs running automatically. I KNOW that this IS possible because it's happening. What are some possible causes.

Thanks
 

Answer:Date always resets to a year from today

7 more replies
Relevance 81.18%

I have the following macro below which works great for when any value is entered in Column C, it time/date stamps the adjacent cell in Column D. However, I need it to do the same thing a few columns over (ie, when any value is entered in Column H, it will time/date stamp the adjacent cell in Column J)

For the life of me, and cannot get it to repeat . Any ideas? I'm a bit new at this, but thanks in advance for the help. Feel free to spell it out - I won't be offended.

Thanks! Here's the current macro:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Count > 1 Then Exit Sub
If Not Intersect(Range("C3:C9999"), .Cells) Is Nothing Then
Application.EnableEvents = False
If IsEmpty(.Value) Then
.Offset(0, 1).ClearContents
Else
With .Offset(0, 1)
.NumberFormat = "dd mmm yyyy hh:mm:ss"
.Value = Now
End With
End If
Application.EnableEvents = True
End If
End With
End Sub

 

Answer:Solved: Excel Macro - Repeat Time/Date Stamp for Different Column?

6 more replies
Relevance 81.18%

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

Any ideas on how to get past this?
 

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

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

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

1 more replies
Relevance 80.77%

I want to get today's date in a column of cells, but only when there is text in the adjacent cell.message edited by Cabri

Answer:How do I get today's date in a cell, only with text in anoth

This is a possible way, however there are some flaws with this, if you enter some text in A1 today, B1 will display todays date, however, when you open the workbook tomorrow it will change to tomorrows date. Not sure how to overcome this really, wait for some of the Excel Gurus they'll more than likely have a much better way than me :)Put this in B1 and then type something in A1=IF(A1="","",TODAY())

9 more replies
Relevance 80.77%

Hi all,My outlook express 6, when i forward my email the date inside the original email date is changing today date. Actually this email received by last two weeks ago. If we forward the existing email inside sent items it have two dates, one is the old email's incoming date and another one is our current date. But all two dates is changing the current today right now date time. So strange! Is anyone have an idea please?Best Regards,Horace

Answer:Outlook express forward today date

horacetrever, suspect that what you need to do is c/p the fwd. into a new mail and send it rather than simply fwd. it. If you desire, put the original date in the new title. You will have today's date on the mail, but you can show the original date within the body of the mail if you'd rather. It also gives you the option to get rid of that annoying chain of fwd. addresses if you wish.HTHEd in Texas

3 more replies
Relevance 80.77%

Hello All,

I am using Thunderbird 2 and need to Change the display format for today's date. I have
tried making a user.js file since there was none in my folders nor documents and settings
folder, but that did no good. Does anyone know how to Change the display format for today's date
on Thunderbird 2 ??

Thanks in advance...
 

Answer:Changing the display format for today's date

Did you happen to check out the MozillaZinr KB article regarding this?
 

1 more replies
Relevance 80.77%

I have the same problem. I am not looking for a workaround, as suggested already.My system is Windows Xp, SP3 running Outlook Express 6, Ver 6.00.2900.5512 (xpsp.080413-2105)My mailbox is an IMAP, not sure if if that has any bearing. However, other workstations with the same configurations work as they should.

Answer:Original sent date on forwarded messages is set to today.

Sorted.I reinstalled OE to no avail. Further investigations revealed that the messages being forwarded did NOT contain any date / time stamp of when the message was actually sent in the message header. So, when it was forwarded, OE added the current date.Digging deeper, I discovered that these emails were created by the scanner application bundled with a Hewlett Packard desktop scanner and not by OE. With the app, the user is able to scan the documents and email them directly to a recipient in the OE address book. The sent message ends up in the OE sent items but the message headers have not date and time of when the message was sent; though there is a time stamp in the Sent message list column, Sent.If you are experiencing the same issue, check the message headers: highlight the message in the list view, select Properties from the file menu, Details Tab, click on the Message Source button. You should see an entry beginning with 'Date:'. If its missing then you know the problem is NOT with OE.So, there is really no fix for this (other than getting HP to fix their app). If its important to you then you just have to remember to correct the date and time when forwarding the message.Hope this helps someone :)

2 more replies
Relevance 80.77%

Is it possible to put today's date into the Formula field in the design view of a table?

There is a string that includes that field as its prefix. Right now it's just a static value. The rest of the string includes just an incrementing value.

For example... the field contains A and the count is 000000. Thus the result is A-000000. The result is stored into one of my tables. I would like to be able to use dates so that it would be easier read.

I would like it to say... 103103-000000 ... 103103-000001 (later today)... 110103-000002 (if tomorrow)...

TIA
 

More replies
Relevance 80.77%

Good Day, I'm new here and I've got a strange sort of problem. Recently my computer decided that system restore would come up stating that it couldn't restore my computer to that day's date. It also states that this is the result of an improper shutdown which was done during the system restore. The only thing is I hadn't done a system restore during that time. I tried going back before the date by two days and although it said that the restore was done successfully it still comes up now it comes up with the same message and the day's date that the computer has been started up. Has anyone ever seen this and do you have any ideas on how to correct it? Any help would be greatly appreciated.
Regards,
WAR1

Answer:System Restore keeps saying it can't be restored to today's date

I would think it was something that is corrupted in the system restore database or however is stores the information.

Only thing i could think of, would be to turn off the system restore for a day or two, then try turning it back on (might forget the old restores).

10 more replies
Relevance 80.77%

Hey guys,I'm working on an Excel Spreadsheet that maps out due dates.You enter the date a document was submitted and it fills out the course that a user has to follow for the remaining timeline of that document.With the due dates, I want to color-code warning dates, and past-due dates.Example:01/01/2012 - Document submittedExcel will show the submission and the due date01/10/2012 - Follow-Up dueSo let's say the C5 is the user input box for the date.C11 is the box that declares the due date for follow-up.C12 is a reference box as to the "status" of it's follow up.I want to box C12 change colors accordingly;Light Yellow - 5 to 1 days before dueYellow (darker) - on due dateRed - any date after dueI used the following conditional formats:Red =C11<TODAY()Yellow (darker) =C11=TODAY()These both worked out fine for me and do what I wanted.I am lost on the light yellow variation though.None of the formulas I tried for the TODAY() function and the date range have worked.Any help if appreciated, Thanks.

Answer:Today Function and Date Range in Excel

How about this:=AND(C11>TODAY(),C11<TODAY()+6)Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 79.95%

I have an excel spreadsheet with lots of dates on it. One time, I saw someone create an arrow or bar that automatically went to today's date on the spreadsheet, so a person would not have to scroll down through past dates to get to today's date. I tried to " create a new rule" in conditional formatting so that today's date was highlighted yellow. The highlighting feature works, but when I open the spreadsheet I am not taken automatically to today's date. Is that some other feature? Can it be done on the excel in google drive?
 

Answer:Go to today's date automatically in Excel in Google Drive

Hi,

I'm not sure about the "Conditional formating". But, You can have a code in the "Thisworkbook module" that will go to today's date.
 

1 more replies
Relevance 79.95%

I need to change a cells fill if the date is in the past or today. Also change it to another fill if the date is within 1 month.ie: date in column C is prior to today, fill red.date is within 1 month, fill yellow.

Answer:Change cell color if date is today or past

Need to clarify, the dates in column C will be in the future, expiration dates. If todays date is within one monthm fill yellow. If todays date equals the date in that column or is in the past, fill red.

3 more replies
Relevance 79.95%

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

I have listed sequentially a column of dates (3/1, 3/2, 3/3 etc.) Adjacent to this column I have listed specific sales goals associated for each day. I need help in getting excel to find today's specific day and display the associated sale goal for that day in a designated cel on top of the page. Any help would be greatly appeciated!

Answer:Need excel to find today's date and display associate data

Try using VLOOKUP and set your lookup_value as TODAY().e.g.=VLOOKUP(TODAY(),$A$1:$B$20,2,0)Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

5 more replies
Relevance 79.13%

Help

I'm mail merging with Word a huge contract document and need to put in the phrase 'this contract is made on the [seventeenth] day of [April] [2010]'. Even in a custom format I'm struggling. When the contracts are printed off they need to be 'today's date' ie the day they are printed.
Thanks
 

More replies
Relevance 79.13%

Well, the problem has nothing to do with Windows 7, but I so got used to this Forum being the main resource of computer wisdom, so here it goes:

I have an old Sony laptop (PCG-VX89P is the model number). It worked very well for a long time (real 8 hours battery time) but eventually it was getting slower and slower, until at some point it simply refused to boot.

I thought the problem was with the hard drive, so I used the Spin-Rite to "repair" the drive, reinstalled Windows (yes, it's XP) and ... it still won't boot. it gets to the welcome screen, then I click on the user icon, it shows Desktop for a while, then the BSOD and it restarts so quick, I can't say what's written on the blue screen at all.

I thought the thing was done for. But, busy as I am, it was gathering dust for some time, until recently I decided to sell it for parts as an alternative to throwing it away. But having forgotten what the real problem was, I decided to boot it up and erase the hard drive again.

Of course the laptop's battery was drained completely, I had to plug it in and the BIOS screen appeared asking me to set the clock. I ignored it, since I did not care to use it, and miraculously everything worked - the machine booted up nicely, worked fine. OK, I thought, I'll change the time to normal, did it in Windows, and then rebooted - and it won't boot!

Next day I recall that this time change was the only thing I did, so I got into BIOS and changed the year to 1992 - the laptop boots... Read more

Answer:Sony laptop time bomb - won't boot with today's date

You could try replacing the CMOS battery.

How to Remove a CMOS Battery From a Sony Vaio Laptop | eHow.com

2 more replies
Relevance 79.13%

Good Day All,

Sorry for my bad English

I am trying to do backup using batch file

this is source path "E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\SBO"
this is target path "F:\July 2012"

source path contains files with yesterday, day before yesterday and 2days before yesterday date backup files (each day backup file size nearly 20GB)
But i want to copy only yesterday files to target path compaing date specified

Please help me. I need a batch file code to do this work.

Any help greatly appreciated

Regards,
Nuthan
 

Answer:Batch file command for comparing files using ""date specified

14 more replies
Relevance 78.31%

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

Help! I am using a Seagate Central 4TB NAS drive attached to my router via Ethernet. It has been working fine so far for all kinds of file activities. But whenever I modify a file in one of its folders, the creation date for the file also updates and is
changed to the same time as the new modified date.
Maybe relevant details:
I can move/copy folders to the drive and they maintain their created dates.
It happens for both a private user share on the NAS and for the Public share on it.
It happens for at least image files and text files.
I am able to edit files across two computers on the network just fine, the create date stays the same.
This happens from a new Windows 10 machine and Vista machine both.
I notice sometimes the date created seems to stay same until I access the file the next time.
I can't update the NAS firmware because of error.

If it could be a permissions problem, I have been unable to change it from:
Everyone: Special Permissions only
nobody (Unix Group\nobody): Special Permissions only
nogroup (Unix Group\nogroup): Special Permissions only
(Those were there automatically, they are not something I manually put there. I get "Access is denied" whenever try to add permissions or change ownership.)

I have Googled many phrases of this problem far and wide and come up with nothing. I really need to save the original create date because that's how I sort them in programs like Windows Photo Gallery or Picasa. Does anyone know what's goin... Read more

More replies
Relevance 77.9%

First the background: We are gradually deploying Office 2007, but not everyone in the agency has it. I have both 2003 and 2007 installed on my system, but I do my work in 2003, and none of our databases have actually been converted to 2007 format (at least, none that I work with). There are occasionally people who use 2007 when viewing databases, but I don't know if any of the people who are working in this particular database are using 2007. The problem is reproducible in 2003 and so I've been trying to fix it here. The query behind the problem report used to work. It has been a problem for several months (it is run monthly, and every month for the past five they've had problems with it) and I've finally gotten to the root of the actual issue.

The purpose of the report is to generate invoice for outstanding loans. The DateNextPayment is a calculated field based on the payment plan for the loan. It is calculated using a function in the query named qryGetSitesDDInvoices1. This is the function that is called (I did not write this function, I'm supporting this db long after the original writer has left):
Code:
Function DateNextPayment(PaymentSchedule As String, DateFirstPayment As Date, Balance As Currency)

On Error GoTo Handle_err

Dim Date1 As Date
Dim Date2 As Date
Dim Date3 As Date
Dim NextQtrDate As Date

'The code adds one month to datenextpayment at start of each month. Or yearly or weekly

... Read more

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

16 more replies
Relevance 77.9%

I got a Refurbished Dell Latitude D600 Laptop from ebay yesterday on Tuesday, September 26th 2017, It had Intel Pentium M (Non-Centrino) and Windows XP Pro SP3, but when i boot it up, it resets to The Default BIOS Date, can someone help me?

Answer:Dell Latitude D600 Current Date Resets to The Default BIOS Date

The coin cell battery on the motherboard that keeps time while the system is powered off is probably dead.  Not too surprising given that the D600 is about 15 years old at this point.  If you open the system up, it should be easy to find, so just note the type of battery, e.g. CR2032, and then buy that type of battery at any grocery/convenience store.  Should only be about $2-3.

2 more replies
Relevance 77.9%

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

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

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

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

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

1 more replies
Relevance 77.9%

Searching for files modified in a specified date range (of the past 3 days) gets a search result list titled "date modified", and with the column heading "Date Modified" but the date listed against a file modified today is wrong. The date displayed matches the file creation date & is within the specified range ... but how do I know what the Search is doing?

Can't trust it... !

Answer:File search (by date range) displays incorrect Mod Date in results

That is very strange. Bump for a possible solution, since I can't think of one off the top of my head.

1 more replies
Relevance 77.9%

The title is self-explanatory. So far, I found a software that is able to change this called 'Attribute Changer' but it only changes the date modified in the folder and, when you go into the actual word application > file > info, the date created and modified are not changed. Any help would be greatly appreciated! Thank you!
 

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

7 more replies
Relevance 77.9%

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

Hello.
I'd like to see Long Date and Long Time in my System Tray instead of Short Date and Short Time. 
But due to some restrictions connected with my work I can not modify Short Date & Short Time to look how I want them to look in System Tray.
So basically I need Windows to show what is set as Long Date & Long Time in System Tray instead of showing Short ones.

Is it possible? Maybe some registry tweaks?

Answer:How to display Long Date in System Tray (without modifying Short Date)?

Hi,
There is no workaround to display the Long Date in taskbar without modifying the Short Date parameter.Ivan-Liu
TechNet Community Support

8 more replies
Relevance 77.9%

hello to everybody

I need batch code to check if date is modified in three files and that date should be compared with current date (%date%).If so,do some job,otherwise quit (exit /b)

I found a bunch of solutions but what troubles me is date format.
On my machine it is dd.mm.yyyy

Thanks in advance.
 

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

10 more replies
Relevance 77.9%

I forgot my new mobile password.Also i remove battery then time setting is now incorrect.I try 5-6 type to set password

Answer:I forgoet my scree lock password?Also i remove battery ow date setting is not current date?

hard reset your phone using following steps :-
1. Turn off your Windows Phone. Use power button to power off the phone.
2. Press and hold Volume down key and connect the charger to phone. You will see a big exclamation mark on the screen.
3. Press these keys one after another in the same sequence. Volume Up, Volume Down, Power, Volume Down.
4. You will see the phone reset and boot normally. You will see wheel gears working on the screen. It will take few minutes.
Your phone will be reset to factory settings and you need to set up the phone again.
Or try to reset phone's setting if it is connected to Wi-Fi or data is enable through your account.

more replies
Relevance 77.49%

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

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

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

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

Answer:Excel 2010: Cell Date Change with Current Date

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

1 more replies
Relevance 77.49%

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

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

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

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

Dim wksCurr As Worksheet
Dim rngTarget As Range

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

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

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

Proc_Exit:

Exit Sub

Proc_Error:

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

Exit Sub

End Sub

3 more replies
Relevance 77.49%

I have a field that reads 2009-12-30-15.42.22.81298 as text. i want to make in be a date of 12/30/2009 15:42:23 and ignore the milliseconds. Is this possible?

Thanks
Ted
 

Answer:Converting complex date text fields into date or numbers

Ted, what software are you talking about?
Are there always 8 values in the date part?
 

3 more replies
Relevance 77.49%

Somehow the date on one of my old Excel files has turned from 1999-10-04 (i.e. October 4, 1999) to 4617-04-11. How can I change all the rest of the incorrect dates back to what they should be? This is the only date that I can confirm. And I have no idea what the rest of all the dates should be on this spreadsheet. TIA.

Answer:Excel date problem - to convert incorrect date to original

I have no idea what the rest of all the dates should be on this spreadsheetThen how do you purpose to change them, when you don't know what year they are supposed to be?Somehow the date on one of my old Excel filesAny Macros running that may have in some way impacted the dates?How is the data stored? As Text or as a Date?MIKEhttp://www.skeptic.com/

5 more replies
Relevance 77.49%

Hi all,I 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 76.67%

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

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

Any suggestion or links would be great.

Thanks,
Andre
 

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

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

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

2 more replies
Relevance 76.67%

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

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

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

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

Answer:Excel 2007 - Start Date and End Date question

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

3 more replies
Relevance 76.67%

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

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

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

9 more replies
Relevance 76.67%

I've just moved "My Documents" contents from one laptop to another
I now find that some of the Word Documents are showing the current date in letters to customers that were created & dated months ago
As these letters are records documents sent out is there a way of preventing them opening with the current date

I've already checked, Wotd - Insert - Date & Time & the Automatic Updates box is unchecked

Thanks for any help

Answer:In Word the Original Date in a letter changes to current date

Is this the file modified date or the file created date? Moving the file will give it a new "modified" date.

1 more replies
Relevance 76.67%

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

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

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

3 more replies
Relevance 76.67%

Hi there

I know how to do add a criteria to a Query. For example in the QBE pane in design view in the criteria row I enter this statement: Between [Start Date] And [End Date]. When I open up the form that is bound to the query, a message box pops up and I enter the required dates and I get the required data that is between the dates that I specify. However, I'm now finding out that this method is now becoming a nuisance.

Is there a way that I can have 2 unbound controls - one for the start date and the other for the end date in a criteria form. This way I input the dates I want for a particular customer and the form with the required data shows up. For example, I have already developed a criteria form for customers. I have an unbound combo box control that has customer names and when I click on a particular customer name, all the data for that customer is displayed in a form. In the row source of the unbound combo box control there is a SELECT .... FROM ... statement. I also have a button next to the unbound combo box control that opens up the form for that particular customer. Now I want to add two more Unbound controls in the criteria form, one for Start Date and another for End Date.

This way I can select a customer from the customer combo Box, select the start start date from the start date combo box and the end date from the second combo box control and get the desired data for that particular customer between the specified dates. I have attempted to do this bu... Read more

Answer:Access - Start Date and End Date in a Criteria form

Mario: What you want is called a query by form (QBF). I don't know how to do them myself, offhand, but here's the MS Technet article:
http://support.microsoft.com/?kbid=235359
 

2 more replies
Relevance 76.67%

So I have this excel spreadsheet and an example of it basically looks like this:

Project Phase Person Capacity Start Date End Date
A Design 1 25% 1/15 3/16
A Model 1 25% 3/17 5/11
A Design 2 25% 1/15 3/16
A Model 2 25% 3/17 5/11

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

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

(Sorry, the text keeps left aligning so person 2 should actually have 25% under Mar, Apr, and May.)

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

Answer:Excel 2007 - Start Date and End date question

16 more replies
Relevance 76.67%

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

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

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

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

rst!dateIntoForce = Me!ActiveXCtlDOForce

I end up with this in my database:

1/6/2003 5:48:43 PM

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

1/6/2003

goes into the database
Thanks
 

Answer:Date Part only from MS Access Date picker control

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

1 more replies
Relevance 76.67%
Answer:ican not set date and time an error is occurewhile date and

Enter the BIOS & change the date/time. If it resets after the system has been shutdown for a while & then restarted, the CMOS battery is probably bad.

2 more replies
Relevance 76.67%

Hello, I have spreadsheet with a number of dates and times ie (11/19/07 8:57 AM) in column A and data going along with each of these dates and times from columns B-CK. I am trying to limit the list to show the information that is for all times after 2:45PM. The problem is I cannot sort by time and the dates attached to all the times span from 2004-2007. Please help!
 

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

7 more replies