Over 1 million tech questions and answers.

Changing the Date format for current DATE Column

Q: Changing the Date format for current DATE Column

Hi,
I want to format the date of Share Point list, I don't want to create Calculate formula column to format the date because. We cant change the existing date in Calculate formula date.
For Example
Existed date : 12/8/2018. here
Calculate date : 12 Aug 2018
We cant edit the calculate date, but we can edit the Existed date.
While displaying the Calculate date it is disabling the Calculate date.
I want to change the date of Existed date and format into calculate date.
"Here I have two question
1. Can we format the Existed date.
2. I know it is not possible to edit the Calculate date. But just asking any possibility is their to edit it."

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Changing the Date format for current DATE Column

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.)

RELEVANCY SCORE 106

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!
 

A:Solved: Using Excel 07 to Send Emails When Date in Column = Today's Date

Read other 16 answers
RELEVANCY SCORE 103.6

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?

A: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.

Read other 2 answers
RELEVANCY SCORE 103.6

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.
 

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

Read other 10 answers
RELEVANCY SCORE 103.2

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.
 

A: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.
 

Read other 1 answers
RELEVANCY SCORE 98.4

I know, there are lots of threads/info out there on the topic, but none (that I've found) have addressed my problem.

I'm simply trying to figure out how to display the time and date on my taskbar, without the day of the week. I don't want my taskbar 3 "levels" high in order to see the date. Why can't I just drag it over so its wider rather than taller? Sorry I'm frustrated, hopefully there is a way to do this, but Windows sure doesn't make it easy.

Thanks for any help you can provide.

Read other answers
RELEVANCY SCORE 98.4

Hi Guys,

Anyone encounter this error problem while changing the date format ?

Error :-

One or more of the characters you typed in this field are invalid.
Try typing different characters

Using administrator right i have no problem changing the date format.
If i use my profile i cannot change even i got the access right same as admin..

what is wrong over here ?

Thanx for the help.
 

A:Error while changing Date Format !!

Could be a corrupt user profile. Try creating a new profile and copy data from the corrupt profile to the new.

Info: http://support.microsoft.com/kb/811151
 

Read other 1 answers
RELEVANCY SCORE 98

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

Read other answers
RELEVANCY SCORE 98

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.  

Read other answers
RELEVANCY SCORE 98

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

Read other answers
RELEVANCY SCORE 98

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!
 

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

Read other 7 answers
RELEVANCY SCORE 97.6

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

A: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

Read other 9 answers
RELEVANCY SCORE 97.6

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

A:Date format using space as date separator rather than forward slash!

Hi Steven,
 
Thanks for the post!
 
When you set the Short date to ddd dd/MM/yyyy, the date by the clock is shown with slash, however, the date in Task Scheduler doesn’t show the slash. This behavior
is by design. When you double click the time and the trigger tab (for example) in task scheduler, the details are shown with slash.
 
When you change the Short date to dd/MM/yy, the date in the Task Scheduler and the clock become the same.
 
For the Excel date problems, I recommend you ask this question in
Office Forum.
 
The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and
other communities who read the forums regularly can either share their knowledge or learn from your interaction with us. 

 
Thanks for your understanding and cooperation!
 
Best Regards,
Miya Yao
 This posting is provided "AS IS" with no warranties, and confers no rights. | Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer
your question. This can be beneficial to other community members reading the thread.

Read other 5 answers
RELEVANCY SCORE 97.2

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

A:Changing the display format for today's date

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

Read other 1 answers
RELEVANCY SCORE 96

Does anyone know how to change the format of the [date] that is put into a footer?

Thanks!
 

A:Solved: Excel - Changing date format in footer

Hi slgraham22,

the only way is via a macro: http://support.microsoft.com/?kbid=213742

lol
Hew
 

Read other 3 answers
RELEVANCY SCORE 96

I have piece of code in C# to change the system date and time format through registry. And the code is working fine in Win 8.1 and other OS version but not in Win 7 version. I try to do it manually into the registry by changing the below values but still
the format is not reflected in the Date and Time.
Also I noticed that when I change the format manually in the Short Time in the "Region And Language" it doesnot change in the Date and Time shown in task bar , but its working fine when I change it for Long Time format manually.
Is it because of any User level permissions required or anything settings to be enabled/disabled to change these values?.

RegistryKey rkey = Registry.CurrentUser.OpenSubKey(@"Control Panel\International", true);
rkey.SetValue("sShortDate", "dd/MM/yyyy");
rkey.SetValue("sShortTime", "HH:mm");
rkey.SetValue("sTimeFormat", "HH:mm");
rkey.Close();

PFB link for screenshots.
https://1drv.ms/f/s!AremMyjuHHWzefsf1iECo_7ihN4

Read other answers
RELEVANCY SCORE 94.4

I live in the United Kingdon and use dates in the short date format dd/mm/yyyy. I have an application that works perfectly with Windows XP and Windows Vista when you change the date format on a machine in the "Regional and Language Options" of the "Control Panel" the dates display properly in the application.The application was developed with Delphi 2009, I believe, in case this makes any difference.When run under Windows 7 all the date fields show up in US format (mm/dd/yyyy) even though all the regional settings, etc. have been set correctly on the machine. Furthermore, running the application in either the Windows XP or Windows Vista emulations does not cure the problem.Is there a known issue about this in Windows 7 or/and does anyone have any ideas?Thank you

A:Date Format Question (reverts to US date format)

Hi,
 
Thank you for your update.
 
Considering the issue is related to application developing, it is still recommended that you contact Delphi support or our MSDN forum for further investigation. This should be more efficient.
 
Thanks again. Nicholas Li - MSFT

Read other 20 answers
RELEVANCY SCORE 94

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
 

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

Read other 6 answers
RELEVANCY SCORE 84.4

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.
 

A: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
 

Read other 1 answers
RELEVANCY SCORE 84.4

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?
 

A:Solved: 2 month later date in next column

Read other 6 answers
RELEVANCY SCORE 84.4

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
 

A: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
 

Read other 1 answers
RELEVANCY SCORE 84.4

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.
 

Read other answers
RELEVANCY SCORE 83.2

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

A:Date Column, Query Criteria only Year

Read other 6 answers
RELEVANCY SCORE 83.2

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

A: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?

Read other 1 answers
RELEVANCY SCORE 82.8

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

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

Thanks in advance
Rusty
 

Read other answers
RELEVANCY SCORE 82.4

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?

A: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.

Read other 3 answers
RELEVANCY SCORE 82.4

Hi All,

I have the following Copy Command which copies files from one location to another

XCOPY D:\Test C:\Test /i

Now i would like to have the files copied from D to C everyday based on the date for today, i googled around and found this one which is working fine

XCOPY D:\Test C:\Test /D:01-19-2015.

The thing here is i want the date to be automated as i would like to schedule a job for this one which would copy the files daily automated .

Can someone please help me with this?

PLease let me know if you have any questions.

Thanks

A:How to get the current date automatically?

Hi sujith

try this
xcopy "D:\Test" "C:\Test %DATE:~7,2% %DATE:~4,2% %DATE:~-4%" /y /i /h /s /e

/s /e - recursive copy, including copying empty directories.
/h - copy system and hidden files.
/y - don't prompt before overwriting existing files.

Read other 6 answers
RELEVANCY SCORE 82.4

I need a small batch file to read and save my current date, then change the date to 1/6/2003, then run a program, when program ends then restore original date.
I managed most of it but cannot store date or restore.
Hope you can help, you should see the errors I get on internet when I forget to change the date back.
terry
 

A:save current date

Read other 8 answers
RELEVANCY SCORE 82.4

I knew it's possible but I did not know how. How can I put a date in the Word97 file so that every time I open the file, the date will change accordingly?
 

A:Current Date Ms Office97

Hi, Kok. Insert-Date and time, select update automatically.

------------------
~dreamboat~
Brainbench MVP for Microsoft Word
Brainbench
 

Read other 2 answers
RELEVANCY SCORE 82.4

Dear all

I have Office 97 SR2 (I know it's old)

Do you know if the excel spreadsheet has a function that will display current date in a cell each time you open the file?
 

A:current date in cell

=NOW() is date & time
=TODAY() is date

from Off2000 but seem to recall Off97 used it also

click on the <i>fx</i> icon or use insert, function
date & time
cruise down the choices, see what you want
 

Read other 3 answers
RELEVANCY SCORE 81.6

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. 

Read other answers
RELEVANCY SCORE 81.6

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]
 

Read other answers
RELEVANCY SCORE 81.2

I have used XL to create a database of events. The first column is dates, and is formatted accordingly. I want to filter the list so that it does not show records having a date earlier than today's date (whatever that may be).

Could some kind person tell me how to achieve this ?
 

Read other answers
RELEVANCY SCORE 81.2

I go to the same site every day, but the URL changes day-to-day with the current date string on the end of the URL. So my question is, when I add this site to my Favorites, is there a way I can customize the URL so that it updates with the current date?

If it's possible, I imagine it would look something like this:

="www.websiteblahblah.com/blah/" & Date.Now()

I highly doubt it, but is there any chance this is possible? Thanks for your help!

A:Dynamic IE Favorites - Use Current Date

No method to achieve that (that I'm aware of).

Does the website have a main page or home page where the URL does not change day-to-day? If yes, bookmark that. you can then navigate to the "dated" page from the home page.

Read other 1 answers
RELEVANCY SCORE 80.8

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

 

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

Read other 6 answers
RELEVANCY SCORE 80.4

Gregarious greetings,

I work as a .NET Developer. I work on a Windows 7 PC that has Virtual PC/Windows XP mode.

My C# code in the Visual Studio 2005 Win app on the Virtual PC successfully bolds dates on a System.Windows.Forms.MonthCalendar control based on certain logic that pertains to the data in the SQL Server 2008 table. On the Virtual PC/Windows XP mode, when today's date (the current date) should be bolded and I run the app and open the MonthlyCalendar control, the current day 13 (for 13-SEP-2011) is shaded dark blue with the 13 in white font and when I click to a different date the dark blue shading disappears and the 13 becomes bolded in black like the other bolded dates for the month of September 2011. All is fine in the Windows XP mode.

When I install the installation file for this Windows application on the Windows 7, I run the app and open the MonthCalendar control. The 13 (for today, 13-SEP-2011) has a light blue shading and the 13 has blue font that does not look bolded like the other black bolded dates in this month. When I click to another date in this month, the 13 is not bolded like the other dark black bolded dates in this month.

I do not care at all about the Win 7/XP differences in the shading of the current date and the differences of the color of the rectangle around the current date.

I do care though that in Windows 7 the current date is not bolded when it should be.

I can provide the C# code if desired but it would seem that my C# cod... Read more

A:Current date on Windows MonthCalendar not bolding in Win 7 OS

In case this information will be helpful to anybody in the future, I finally determined the cause of the current date not bolding in Windows 7. I discovered the line of code that prevents the current date from bolding in Windows 7 even though the line of code does not prevent the current date from bolding in Virtual PC/Windows XP mode.

In the real Windows application, I searched for any code that might be the culprit and then tested in a lil? test application project. I used Visual Studio 2005 for my test application just as the real application was created in Visual Studio 2005. My review of the real app's code and my testing determined that when I comment out the following line of code in the real Windows app , the current date is bolded in Windows 7 whereas if I have this line of code the current date is not bolded in the System.Windows.Forms.MonthCalendar control in Windows 7:

this.calDate.MaxDate = System.DateTime.Today;



The name of the MonthCalendar control in this Windows app is calDate

Here is code from a lil? test app that shows how this line of code is the culprit. If you run the lil? test app with this line of code "this.monthCalendar1.MaxDate = System.DateTime.Today;" and then run the test app without this line of code on Windows 7, you will see that having this line of code prevents the current date from bolding on Windows 7. There is nothing in this Visual Studio 2005 project except a form and the MonthCalendar control on the form... Read more

Read other 1 answers
RELEVANCY SCORE 80.4

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

A:How to sort by date added to current folder

File Explorer Columns - Add or Remove in Windows 8

Read other 5 answers
RELEVANCY SCORE 80.4

Is there a function that would allow me to display the current time and date in this format:

YYYY-MM-DD 13:24:00? I'm tired = Now() and =GetDate() but they dont seem to work. Thank you!
 

A:Formatting Current Time/Date as YYYY-MM-DD 13:24:00

Read other 7 answers
RELEVANCY SCORE 80.4

Hello I´ve created a module in Access 2007 with renames a folder c:\finish\MyFolder to c:\finish\Renamed

I would like to change my code so the folder is renamed to the current date (DD-MM-YYYY)

How can I do this?!? here´s my code:
Code:
Sub ShowFileAccessInfo()
Dim fs, f, s
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.Getfolder("C:\finish\MyFolder")

f.Name = "Renamed"
s = s & "New Name: " & f.Name & vbCrLf
s = s & "Created: " & f.DateCreated & vbCrLf
s = s & "Last Accessed: " & f.DateLastAccessed & vbCrLf
s = s & "Last Modified: " & f.DateLastModified

MsgBox s, 0, "File Access Info"

ShowFileAccessInfo_Exit:
End Sub
Tnx,
Wouter
 

A:Solved: Rename folder to current date

Hi there,

Change

Code:
f.Name = "Renamed"
To

Code:
f.Name = Format(VBA.Date(), "DD-MM-YYYY")

 

Read other 2 answers
RELEVANCY SCORE 80.4

I am trying to create job status sheet, and I want the current date to show whenever a cell or row is added.

For example, If I put a job number in B2, I want the date(year, month, day) to show in cell A2 automatically. The IF formula is only formula I can think to use.
 

A:Solved: Using the IF formula to show current date

Just put the formula =Now() in the target cell. And each time the worksheet will be recalculated the formula will be updated, so no need in and if function.
 

Read other 2 answers
RELEVANCY SCORE 80.4

Would like to use a "Spread Element", but not sure how to program it to give current date and time.













Solved!

View Solution.

A:Need to add a "Current Date and Time" stamp on Imposition sh...

Found the solution. Added this code: «#JobName»to the Spread Element.Indd that is assigned in the imposition.I also had added a current date; under Type/Text Variables I added month/day/year, andI added the sheet counter from the Data Fields/Counters/Sheet Counter. Works great. Saved as a master to automatically assign these three  itemsto each sheet of any imposition without having to add varable columns to the database. Hope this is helpful to others.

Read other 3 answers
RELEVANCY SCORE 80.4

Please can anyone tell me how I can place the current date in a report generated by Works 7.0 database programme?
 

A:Works 7.0 Database report current date

"&d" or "&n" (no quotes) in the Header or Footer. Prefix with "&l" or "&r" if you don't want it centred.

HTH,
Andy
 

Read other 2 answers
RELEVANCY SCORE 80.4

I am trying to design a query where only records with the current date are printed. When I put &lt;Now() in the criteria of the query for some reason records with today’s date and less than today’s date are printed When I put &gt;Now() only records greater than are printed, when I put =Now() I get nothing. I would appreciate any input thanks.
 

A:ACCESS - Query base on current date

=NOW() means RIGHT NOW, not TODAY, which is what you want.

=today()

=now() is 10:29 EST on 10/3/2001 (at least right now it does, LOL)

=today() is 10/3/2001
 

Read other 3 answers
RELEVANCY SCORE 80.4

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

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

Read other 8 answers
RELEVANCY SCORE 79.6

Hi

I am using following batch file for cleaning the desktop and also for taking backup of desktop:

@echo off

set curr_date=%DATE:~10,4%-%DATE:~4,2%-%DATE:~7,2%

mkdir "%USERPROFILE%\My Documents\backup\%curr_date%_backup"

xcopy "%USERPROFILE%\Desktop" "%USERPROFILE%\My Documents\backup\%curr_date%_backup" /D/S/H/V/C/F/K/Y

for /d /r "%USERPROFILE%\Desktop" %%x in (*) do rd /s /q "%%x"
for /r "%USERPROFILE%\Desktop" %%x in (*) do del /f "%%x"

copy "%USERPROFILE%\My Documents\backup\%curr_date%_backup\*.lnk" "%USERPROFILE%\Desktop\"

del /q "%USERPROFILE%\My Documents\backup\%curr_date%_backup\*.lnk"

In the first line I am creating a folder with current date, e.g. curr_date_backup. Second, copying the contents of Desktop to the newly created folder. Third, deleting directories from the desktop. Forth, deleting files from the desktop. fifth, Copy back all the shortcuts to the desktop. sixth, deleting all the shortcuts from Current date folder.

This batch file is working perfectly in Windows XP. It works in win 7 also but the problem is that the name of the current date folder created by first command is "Desktop". when I use command prompt to check the name, the name is correct. I checked the properties of the folder the correct is there also. But in windows the name doesn't match with the expected one.

I need help. Kindly tell me what's going on? why window 7... Read more

A:How to create a current date folder using batch file?

Works for me, at least the first two commands work as advertised.

test.bat
set curr_date=%DATE:~10,4%-%DATE:~4,2%-%DATE:~7,2%
echo %curr_date%"

mkdir "%USERPROFILE%\My Documents\backup\%curr_date%_backup"
dir "%USERPROFILE%\My Documents\backup"






Quote:
C:\Users\xxxxxxx>set curr_date=2011-11-21

C:\Users\xxxxxxx>echo 2011-11-21"
2011-11-21"

C:\Users\xxxxxxx>mkdir "C:\Users\xxxxxxx\My Documents\backup\2011-11-21_backup"

C:\Users\xxxxxxx>dir "C:\Users\xxxxxxx\My Documents\backup"
Volume in drive C is D370_C
Volume Serial Number is C89E-70E8

Directory of C:\Users\xxxxxxx\My Documents\backup

11/21/2011 01:30 PM <DIR> .
11/21/2011 01:30 PM <DIR> ..
11/21/2011 01:30 PM <DIR> 2011-11-21_backup
0 File(s) 0 bytes
3 Dir(s) 28,082,577,408 bytes free

Read other 8 answers