Tech Problem Aggregator

Date stamp on photos

Q: Date stamp on photos

Wasn't their a discussion recently here about digitals that would stamp the date right on the picture? Someone is asking me this and I could have sworn a few models were given that did this but I can't find the post.

A: Date stamp on photos

13 more replies
Answer Match 92.82%

My wife's cousin has a Sony FD 73 camera. I don;t know how old it is but it uses a 3.5" floppy disk to record the pictures.
The instruction book I downloaded says the recommended OS is Windows 3.1 Windows 95 or later, so it is sort of an antique I suppose.
He needs to have the date embedded in the pictures I can't find a setting for this in the manual. Is there a way to change settings so he can do this?
Thanks.
 

A:Setting date stamp to display on photos in older camera

10 more replies
Answer Match 68.46%

I have photoshop Elements 1. How can I get the date and time stamped on the photos that I want to print. I know that running the curser over the picture, they show up but I want it on my prints. Is there a way to automaticly do this other than using the text tool.
 

A:Date & Time Stamp

15 more replies
Answer Match 68.46%

How do I date stamp with the Canon EOS 550 D? I can find nothing under all five menu tabs. I can set the date and time but I can't put the date onto recorded images. Thanks in advance.
 

A:Solved: Date stamp

14 more replies
Answer Match 68.46%

When I take a picture with my Android phone, the date and time when the picture was taken is recorded, in the filename as well as in the JPG picture-file itself; all very convenient. To my horror I noticed that my phone reacts in an idiotic way to the GSM connection being lost: the date of the picture is 'reset' to, apparently, the date the device was manufactured. Subsequent pictures apparently start counting from there. This completely messes up the chronology of my pictures: all pics taken with no GSM connection end up with date/times on the same day, years ago.
I completely fail to understand why this is so and would like to know if this behaviour is particular to my device or if others experienced the same thing. Is it a bug or a feature?
I experimented with various methods to set the time: manual, from GSM-network or from GPS. I would have thought that using manual or GPS would remedy things, but it didn't. (Although it had some effect on Daylight Saving Time issues, but that's another story.)
 

More replies
Answer Match 67.62%

Anybody else noticed that after the summer-time change, Win XP has changed the TIME STAMP on all files. I think this only happens on NTFS partitions, but the effect is that all backups held on non-NTFS partitions now appear to be an hour old. This is just STUPID, and can anybody tell me if this is intended, and if so what conceivable reason can there be?

better yet, can we do anything?
 

More replies
Answer Match 67.62%

Hello all. I work around Outlook 2000. My question to you all is I have one account out of like 50 that is receiving e-mails late. Ex. Today 1/19/05 I am getting e-mails stamped 1/1/05 about three weeks after they were sent. I looked at the basic, Delay e-mail but it is happening from more then one person. I also thought about the whole time zone thing but I checked the time zone on the computer and it is set up right. And the funny thing is that it is not happening to all e-mails just the impartment ones.

Any ideas, any help

Thank You
 

A:outlook 2000 Date Stamp

16 more replies
Answer Match 67.62%

i found some disturbing searches in my google toolbar and i need to know if there is a way to find a date and timestamp for these searches. i'm worried that my children are visiting improper sites when i am not around. any help would be greatly appreciated!!!
 

A:date and time stamp for a search

I am not sure about a search time stamp... but if you check the history of the browser, you'll prolly find the websites they visited.

While ur browser window is active... prest Ctrl + H
Then sites that have been visited will show up at the left side of the browser (this all depends on your browser settings)

hope that helps!
 

1 more replies
Answer Match 67.62%

Hi,

A family member took many great pictures while on vacation but used the date stamp mode. I noticed in XP the date stamp does not appear on the icon when set to thumbnail view. However, it does appear in Windows 2000 thumbnails. Somehow the JPG holds more than one layer of info, but I've been unable to find them with Paint Shop Pro 7. The camera is a Sony Mavica CD-2000 and the picture format is jpg. I checked the archives and looked on the Net for information but have come up empty handed. Is there a photography expert that knows how to divide the layers, if that's the case?

Thanks,

Dave
 

A:Removing the date stamp from a photo

9 more replies
Answer Match 67.62%

I understand there is a way to change the " when became a member " on yahoo profiles : i want to look as tho the id i am using is older than the actual date i received it. How can this be done?

A:date stamp, when became a member at yahoo

Where did you hear this??
I seriously doubt that this is feasible. Yahoo (and plenty of websites) add this to be informative, and perhaps to add credibility to a post. Changing this would require hacking the servers...

1 more replies
Answer Match 67.62%

Are there any photo editors that would allow me to enter a date imprint on multiple
pictures(not individually) already in a folder on my computer?
 

A:Photo Editor, Date Stamp

I don't know but look at this thread.

http://forums.techguy.org/digital-photography-imaging/480310-solved-put-date-stamp-original.html
 

2 more replies
Answer Match 66.78%

Here is a weird one.
 
I have Photoshop CS 5 running in win 7.
 
When I save jpgs to a particular folder itn saves the wrong date stamp in 2013 with exact same time and date.
If i save outside this folder it saves out with correct time stamp.
 
Folder is shared on both Dropbox and GoogleDrive as is the location i saved  a test jpg which gives correct time stamp.
 
Any ideas? Its odd as it only this folder and only jpgs ...
 
I opened the file info and it seems to be reading the 'date taken' not the 'date created' info . 
 
I created an image from scratch and saved it out as a jpg- looks like PS is picking up a photo texture on one of the layers data as its date taken. must be still in the data part of the image. 

A:Date stamp wrong when saving files...

Does this only happen in Photoshop?  

5 more replies
Answer Match 66.78%

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

More replies
Answer Match 66.78%

I'm using XP outlook express and I noticed the other day my incoming emails don't have a date or time under the receive column. Someone please tell me why or how to fix. Thanks.
 

A:No date & time stamp in Outlook express

bump
 

1 more replies
Answer Match 66.78%

Today I was advised by a friend that my date stamp on my email came in a couple hours ahead of what time it actually was. I noticed the same thing on my incoming mail. The thought was my clock was off, but it was fine. When I open the mail the date stamp is correct. I believe I took in an update from Microsoft yesterday that addresses the fact that Daylight Savings Time is coming three weeks earlier this year than XP is expecting. I there any word out there of this being a flaw in the download?
 

More replies
Answer Match 66.78%

Hi there,

Thank you in advance for checking out my query.

I rarely have the opportunity to use VBA so I apologise for my ignorance in advance

In the attached file I am trying to setup a few things ... tried several different codes from other sources, but weren't successful ... so I deleted the codes to avoid confusion (I am already massively confused.. I have been at this for the last 6 days and nights ... and I'm getting stressed out!).

Since there are a few things that I would like my form to do, I realise that if anyone is going to help me out, I will need to just ask for the most urgent items that are essential and have to wait with the other fixes.

There are 4 main fixes that I'd be immensely grateful for are;
The User enters a 4 digit code into a textbox named txt_SAC_No when that has been entered I need the textbox txt_SAC_Address to perform a Vlookup a named range (SiteNameADDRESS) and display the data in the textbox.
The reason for the result to be displayed in the textbox is because some codes are not listed and users will need to enter in the information manually.
I do not want the information that the user manually enters to be added to the named range.
If it is possible to have the next available Security Incident # (which is setup in Column A on the Incident Details spread sheet) when the user opens this form
Setup a Date and separate Time stamp to activate after the user has entered their name into the lbl_INC_Recorded_By textbox -... Read more

A:How to do a Vlookup in Userform, Date & Time Stamp

OK... it was all about size

I have taken all the unnecessary stuff out of the file ... so there is only the bare minimum in there... which should not affect the form or fields etc.

Small win for me today

Please let me know if you need any further clarification or information
Thank you again

Shybutterfly
 

1 more replies
Answer Match 66.78%

I took several pictures with my digital camera and failed to insert the correct date after batteries were charged. the computer now reports the images taken on the wrong date. Is there a way to correct the image file date stamps using the registry or one of the XP power tools?

More replies
Answer Match 66.78%

Is there a way of finding out when a picture that has been sent to me via an attachment on an email was taken?
TY in advance.
Nick.

More replies
Answer Match 66.78%

Canon 2SIS

I've figured out how to set the date on the camera and can put a Date Stamp on images after I download them to a computer. I have to run the camera software to do that and then the file is changed from JPG to an album. Don't want to do that.

Does anyone have idea how to set the camera to put the Date Stamp on the image taken with the camera?
 

A:Solved: Put Date Stamp On Original Images?

10 more replies
Answer Match 66.78%

Using VISTA, why is the time and sometimes the date incorrect on the temp file log. How do you fix it? the laptop clock is correct, the comuter is dell vista laptop, ...whne I did a file recovery I noticed that many files were "accessed" on a hour time delay, say I was on internet at 9pm, it lists it as 12am. I checked many other days and this problem was everywhere. why and how to fix. thanks

A:fix time date stamp on temp files

What/ where is the "temp log file"?

Are you sure that you are looking at "last access" date vs. modified, or other dates?

Please post that log.

jcgriff2

.

2 more replies
Answer Match 66.78%

Hi,

I have a situation where a new user has managed to set all 2000+ emails in their bosses inbox (in Outlook 2003) to Read - the boss is not happy. I have explained until I'm blue in the face that there 'may' be better ways to organise their emails...

Does Outlook record a time / date stamp for WHEN an email was marked as read / unread, and is it possible to filter by this so we can effectively select & set all emails not Read before a certain date back to UNREAD.

And save a trainees job.

OldRedEyes
 

A:Date/Time stamp for Read in outlook

nothing? anyone?
 

1 more replies
Answer Match 66.78%

I have spoke to someone who is dependent on sending customers' emails. It is vital that the email dates are correct. I think the problem started when the clocks went ahead.I have instructed them to do all updates for outlook 2003. I verified that the problem is not related to their email host. The date stramps are correct when they send out email usijng webmail. Her computer is free of viruses and spyware and is maintained very well. She did a detect and repair as well.She has Mcafee as her antivirus scanner and no firewalls that I know of.I spoke to her email server and they have not any such issues regarding their server.Maybe someone out there has dealt with thiis before. My hunch is that maybe by upgrading to outlook 2007, this problem would get resolved. She doesn't want to use outlook express, which has it's own problems and is not supported any more.I am clueless to what would be the next step.

A:Outlook 2003 has wrong date stamp

I made sure the time, dsate and region was correct in the control panel and even in the bios. and it was correct.

9 more replies
Answer Match 66.78%

I am searching for a little freeware utility that will let me insert the date and time into an MS Word, Wordpad, or Notepad document. Does anyone know of a utility like this? Thank you in advance for any reply.
 

A:Need freeware date and time stamp for Word

You don't need any additional software for this.

For Word and Wordpad:
Just select Insert Date and Time. Then select the format you want to use

For Notepad press F5
 

3 more replies
Answer Match 66.78%

In Excel 2007, Is there a way show a date stamp of when data was entered into a cell? So when you hold the cursor over the cell it shows you the date the data was entered?
 

A:Solved: Excel 2007 date stamp

7 more replies
Answer Match 65.94%

I have a program that runs on a XP platform on several computers.
There is one computer that has a weird problem.

The program shows the time and date of the computer, which is the actual time and date.
The program can create bitmap images and text images.
When I click on the export button, the program will save the BMP and TXT files to the Harddrive with a total different date/time stamp.
The program wil export the BMP and TXT files with not only a filename, but also a date/time stamp (the correct one).
It will be exactly one hour and one day earlier.

This is not correct, because the computer has the current date and time, but Windows labels the files with a wrong date/time stamp.

If I open Windows Explorer, I can see the files listed as:

filename200908201250.BMP Bitmap Image 12KB No 302KB 97% 8/19/2009 11:50 PM

It will not impact the problem if I change the BIOS and Windows time.

Did anyone have this effect ever before and can it be a virus ?
The problem is, once in a while, I will loose BMPs and I cannot find them anymore.
 

A:Time/Date Stamp in XP shows 1 day and 1 hour difference

The problem is not the time difference itself.
The big question is, how is it possible that the program takes the time from Windows, displays it correctly in the program, saves the files with the correct time and date, but shows in Windows Epxlorer to be created on a total different moment ?
The exact same program is installed on many more computers and they don't have this problem.
I have replaced the program, Windows, HDD and the computer motherboard without success.
Could it be a virus causing this ?
 

1 more replies
Answer Match 65.94%

Hello,

I have a JVC Everio GZ-HD10U camcorder that I am recording videos to MicroSD card. Upon transfering the video on my computer via sd card, I am unable to make the date/time stamp show up on the video. I have attempted using Windows Live Movie Make and Pinnacle software (Avid Studio) and have had no luck.

I am running Windows 7 64 bit with 4gb of memory. Has anybody figured out how to get the date/time stamp to show up on the computer?

Thanks in advance for your assistance.
 

A:Solved: Date/Time Stamp from Camcorder to Computer

7 more replies
Answer Match 65.94%

Ok, here is what I have.

An Access Database that will allow for "Trouble Tickets" to be issued.

The way I have it set up now is a Status. This tells if the Ticket is Open or Resolved.

What I also have is a "Closed Date" Field, what I am trying to do is set it up so that if the Status is changed to Resolved, it will put the "=NOW()" in the Closed Date field.

Any suggestions. Everything seems to work fine, with the exception of this.

Thanx in advance.
 

A:Solved: Access - Closed Date/Time Stamp

13 more replies
Answer Match 65.94%

I've got the date/time stamp ON in the menu, but a date/time stamp does not appear for a video recorded. Is it only for pictures? I have the extended user guide, but it hasn't helped.

Thanks.
 

More replies
Answer Match 65.94%

10 - 20% of incoming emails get a WRONG Received date stamp in the navigation pane. On 15 Dec 2012 some emails got '25/01/2000', on 16 Dec 2012 some were stamped 26/01/2000 and a few hours later in the day '27/01/2000'. The emails originate from different senders including one from management software in this computer. That software sent me 5 emails at much the same time, four of which were stamped correctly but one '27/01/2000'.

Most emails are date/time stamped correctly but those stamped wrongly end up right at the bottom of the chronological list in the Navigation pane because of the old date. They are easily unnoticed.

The 'sent' date/time stamp in the email header always seems correct.

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Professional, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i7 CPU Q 740 @ 1.73GHz, Intel64 Family 6 Model 30 Stepping 5
Processor Count: 8
RAM: 4023 Mb
Graphics Card: ATI Mobility Radeon HD 540v, 512 Mb
Hard Drives: C: Total - 359228 MB, Free - 213201 MB; E: Total - 15359 MB, Free - 3001 MB; F: Total - 2035 MB, Free - 1261 MB; I: Total - 953867 MB, Free - 215174 MB; S: Total - 99998 MB, Free - 94349 MB;
Motherboard: Hewlett-Packard, 1471
Antivirus: Microsoft Security Essentials, Updated and Enabled
 

A:Outlook 2010 Navigation Pane Date Stamp

check time & date on your computer
 

2 more replies
Answer Match 65.94%

Having a problem transferring the date and time stamp from Cannon ZR90 to DVD. Video and sound transfer perfect. I turn on the data code on the camera, still no transfer. I have tried several software programs such a ULEAD, Pinnacle and others. My computer is a Dell Inspiron 8100 and I am using a Firewire. Help.
 

A:Solved: Date and Time Stamp from Cannon zr90 to DVD

8 more replies
Answer Match 65.94%

So I'm pulling in a date in the format (MM/DD/YYYY HH:MM:SS AM/PM) Is there a way that when I use a make table query, it only returns the Hour in the format of a number in the field instead of the date stamp?

So:

submit_date
8/20/2008 10:59:27 AM
8/20/2008 11:00:10 AM
8/20/2008 11:01:27 AM

Would be in the new table as

10
11
11
Is this possible?
 

A:Solved: Date Stamp to Hour Conversion -- Access

10 more replies
Answer Match 65.94%

I never seem to know where to place the IFs. I yoinked the 2nd part of this code from somewhere, then added it to my existing code. It doesn't work, of course.

Code:
Option Explicit

Private Sub Workbook_Open()
'When workbook is open, if the date is blank, enter it
If Range("qadate").Value = "" Then Range("qadate").Value = Date + Time

'If the workbook is the "template", do nothing
If ActiveWorkbook.Name = "QA-Hosp" Then

Exit Sub

'If the workbook is NOT the template anymore, username & time/date stamp it

' Stores who and when on Record Sheet, column A
Sheets("Record").Select

If Range("A65536").End(xlUp).Row = 1 And Range("A65536").End(xlUp).Value = "" Then
Range("A65536").End(xlUp).Value = Environ("Username") & " " & Now
Exit Sub
End If

Range("A65536").End(xlUp).Offset(1, 0).Value = Environ("Username") & " " & Now
End If
End Sub

I very much appreciate any help!
 

A:Solved: Workbook_Open Username & Time/Date Stamp

Looks like you need to move the End If to the line after the Exit Sub. Otherwise it is effectively exiting before running any further code in any case.

I would also consider changing your code so you are not selecting the Records sheet:
Sheets("Record").select
I would declare Records sheet as a variable instead:
Dim Record as worksheet
set Record = sheets("Record")
You can then change these references:
Range("A65536")

for
Record.[a65636]
 

3 more replies
Answer Match 65.94%

Hello,

I have a new computer with Windows 7 on it - and I want to copy the files from my old computer to my new one. I'm looking at copying about 300 GB worth of data.

When I copy all files and insert them onto my new desktop, I notice that all of the date/time stamps are changed to today's date.

Is there a way to preserve the date/time stamp for each file, so that it keeps the original one?

Thanks!

A:Preserving date and time stamp on all files copied?

If you right click the folder, then select properties It should show:

Created: (This will be the date you copied it over)

Modified ( aslong as it hasn't been modified on the new machine, IT should read the date it WAS last modified?

Accessed: It should show when the folder was last accessed (opened)

In regards to "perserving the date/Time Stamp. I'm not sure this is possible.
You can always try checking the Modified Time/date ( mentioned above ) then add the date to the file/folder name. SO you always have a refferance.

3 more replies
Answer Match 65.94%

When I create a file in Windows 7 and save it I get the current date and time stamp but when I edit the program at a later time and date and save again it doesn't change the date and time stamp it stays the same as the original file! I feel like a moron but how can I change this?

A:Change date and time stamp on file save...

Hi Dave,

Presuming you have made changes to the file that require saving, the date and time should indeed change. See the image below : do you have the Date Modified, or Date Created option showing?

3 more replies
Answer Match 65.94%

platform: skype, desktop program, not the win8 metro app

ok..buddy of mine, her skype for some reason seems to think its december 8th of all things, we've confirmed the computer's date/time settings are correct...any ideas? I'm quite confused here.

A:skype displaying incorrect date/time stamp

I don't use skype (desktop or metro) but it appears this thread addresses how to change the date/time in a Windows desktop client environment:

date time set - Skype Community

2 more replies
Answer Match 65.52%

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft® Windows Vista™ Home Basic, Service Pack 2, 32 bit
Processor: Pentium(R) Dual-Core CPU T4200 @ 2.00GHz, x64 Family 6 Model 23 Stepping 10
Processor Count: 2
RAM: 3002 Mb
Graphics Card: Mobile Intel(R) 4 Series Express Chipset Family, 1308 Mb
Hard Drives: C: Total - 152624 MB, Free - 101762 MB;
Motherboard: Wistron, 3612
Antivirus: Symantec Endpoint Protection, Updated and Enabled

I had my laptop hard drive replaced and part of the agreement included the installation of MS Office Professional. When I went to pick-up the laptop I asked for the MS Office product Key Codes for my records and registration. The store owner said he had already registered the software and it was set to go, just bring it back if I ever needed to reinstall for any reason. I was suspicious as a legal installation would include this information.

When I got the laptop home and started it up, I checked to see the licensing information on MS Office Professional and it was registered to IUWare (University of Indiana), I have reported this to their ITC Support and other security and policy departments. Long story short I am in process of filing a FBI claim against this vendor and a VISA dispute as well. I want to know how I can access the time/date stamp on the initial installation of MS Office Professional on my hard drive and all changes made since that initial installation. The first night I had run time errrors and took the lap... Read more

A:Root Record of Software time/date stamp of installation/changes

If you go Control Panel > Progarms and Features, you can see the date of installation of all software. If the date column isn't showing, right click on the column headers and checkmark "Installed On'.
 

2 more replies
Answer Match 65.52%

Hello!

I joined this forum for just this one problem...

My line of work requires that I take before and after photos of everything I do or photos to support the bidding of work to be done. The resolution is required to be 640x480 and the compression set to normal. Most of the time I am taking 100+ photos per job site. Sometimes completing 3-4 job sites per day. Past cameras I have used (Nikon CoolPix) allow the Date/Time Stamp to be a part of the image which is also required by my line of work.

I have been frustratingly searching for the instructions on how to get the Date/Time Stamp to be a part of the image when it is taken for the Olympus Stylus Tough 8000.

I understand that this information is recorded with the image and that I could use a program of some sort to add the Date/Time Stamp myself but due to the volume of images a software solution would no be viable.

Is there anyone that has used or can help find the instructions for enabling a Date/Time Stamp for this particular camera?

Any help is greatly appreciated!

Thank You.
 

A:Olympus Stylus Tough 8000 Date/Time Stamp

8 more replies
Answer Match 65.52%

This just started.

If I create a new folder in Outlook and move emails there, the date/time stamp of these emails change to the date/time I created the folder.

Doesn't happen when I move them to existing folders though, only new folders.

To see if it's specific to my Outlook, I connected to another on a terminal session and the same problem occurs.

Help!!!
 

More replies
Answer Match 65.52%

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

 

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

9 more replies
Answer Match 64.68%

I have this problem. When I save an email with the option "save as" from windows mail IT will print the current date without maintaining the mail by default, but if you drag the email with the mouse and loose it in a folder now. I'm trying to fix this with this, but, did not work:
1) the .eml files change to the present date when they are indexed by the search indexer; this is, a few seconds after creation. Thus, backup/restore/sync will not work properly, but indexing.
2) if you delete that mentioned registry key, then the indexing of .eml files no longer works, i.e. you cannot find them in a full-text search. However, backup works now.
3) it is unknown whether the other solution, proposed by alecamiga, to link .eml to thunderbird and write lock the files, does the same or works better.

thaks

More replies
Answer Match 64.68%

I apologize for posting to the "general" forum here - even though my issue concerns gmail, it may have something to do with file handling in Windows 7, so I'm shooting for the broader audience in this forum.

How do I save an attached file from my gmail account, such that the date and time stamp, once saved to my local computer, remains the same as that of the original file?

That's how I just always assumed it was being done, and yet with gmail, the files are saved to my local computer with their save date/time, not the date/time of the actual file.

This is just wrong! If I send a file to 15 people, I want each recipient to have a saved file with the same date/time - not 15 different times based on when they saved them.

What am I missing, to force gmail/Windows to preserve the original file date and time stamp?

BTW, I posted this question to a gmail user forum, and the only answer I got so far is unhelpful, and likely wrong, gobbledygook.

A:Saving gmail file attachments without changing their date/time stamp?

Hi,
I doubt that can happen
At best there might be a universal Date Created or Date Taken on all of the files.
The camera it's self would enter that info "if" the time and date were correctly set on the device.

3 more replies
Answer Match 64.68%

Somehow some time back I set Word 2010 to show a date on every saved page that I have. The date shows up on the bottom of the page on the left side. It also shows on a saved document for an envelope that I made. I want to delete that particular date stamp but when I open the envelope, I cannot figure out how to delete it on this item.
Any suggestions would be appreciated.
 

A:Solved: Word 2010 Want to Delete a Date Stamp on one Saved Item .

11 more replies
Answer Match 64.68%

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?

6 more replies
Answer Match 59.64%

Has anybody else experienced this problem?

I open Event Viewer - "Admin View" to see what Errors/Warnings are there and in the column - Date and Time only the date is showing. Same goes for all the other views.
The "Time" element seems to have completely disappeared.

Any idea where its gone........... and more importantly, how to get it back?

Thanks

A:Time stamp missing from Date and Time column - Event Viewer

Problem solved - but - I don't know why.

Solution:- I changed the Date/Time format from UK to US, opened Event Viewer and it was as it should be. Date & Time showing.
I then changed format back to UK, opened Event Viewer and , as above, the Time was back up.

If anybody knows what had happened I would be most interested.

My thanks to Bill............. from another site for helping me out with this one.

1 more replies
Answer Match 59.64%

I've tried to send a delayed email using the "Do Not Deliver Before" function. Hoping the email would be date/time stamped when I wanted the recipient to receive the email. For example, sent the email on a Tuesday and scheduled the email to be delivered the next day (Wednesday) at 10am. The function did delay sending the email, but the date/time stamp was when I originally hit sent on Tuesday. What is the purpose of this feature if the date/time stamp will not indicate the date/time I wanted the recipient to receive the email?

When using this function, is there a way for the exchange to track the date/time stamp of the email when it actually leaves the Outbox instead of when you click send? I understand the exchange keeps track of the date/time stamp of when an email is sent, but why couldn't the exchange keep track of when the email leaves the outbox when using this function? Is there any exchange setup that will make this function work the way it is supposed to? Thank you
 

More replies
Answer Match 56.28%

Why do Videos I take with my Canon Digital camera not have a DATE TAKEN section like a photo?

How are you supposed to organize and know the date it was taken then?

More replies
Answer Match 55.44%

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

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

A:Sort downloaded photos by date taken

Hi tamirhoresh

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

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

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

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

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

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

1 more replies
Answer Match 54.18%

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

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

A:MS Picture manager mixing up photos date order

Welcome to the TSG forum.

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

3 more replies
Answer Match 54.18%

My digital camera, like most, allows you to choose a setting to have the date appear on a picture when they are printed. When I view my photos on the computer there may be several that are too dark so using Paint Shop Pro I enhance them adjusting the contract so the picture will be lighter. The only problem is, when I print the picture that date the picture was taken does not appear but instead the date the picture was enhanced (or modified) is printed. So, if I take a picture on July 13, 2009 and enhance it on my computer on July 22, 2009 and then print it...the July 22, 2009 date appears on the picture. Is there any way around this other than importing the picture into Infanview and inserting the correct date onto the picture?
 

A:Original Date Doesn't Print on Enhanced Photos

If you right click on a photo and get properties, is the Created date the same as the Modified date after you make your edits and save? If so,....HMMMM, but if they are correct then whatever you are using to print with that puts the date on is reading the modified date instead of the created date. I'm using PSPX2 and from what I can see it maintains the created, modified and accessed date correctly after its been edited.
 

2 more replies
Answer Match 53.76%

I have the PowerShot A1100 IS with the ZoomBrowser EX system. I can see my uploaded photos all before September 26. Since that time I have transferred photos over six times, but I cannot find them. Now, when I take say 5 photos, and proceed to transfer - no problems. I can also see the photos that I took after 9/26/10. If I click on one of the photos, I am kicked out of the system.

When I search for my photos by date, the ones before 9/26/10 are readily available. I have looked everywhere for my photos so I can edit, email, order on line, etc. but I cannot even see them unless I take some more photos to transfer to ZoomBrowser Ex. Of course, I cannot find my original disk.

Can anyone help me? I have tried a variety of search methods. I am still learning. I have Windows XP.

Thank you!
Kariann
 

A:ZoomBrowser EX doesn't show recently uploaded photos by date.

6 more replies
Answer Match 42.42%

I have Vista Home Premium with Microsoft Photo Gallery on my Dell Inspriron 1721 laptop. I?m using a machine to transfer slides to a SD card then uploading them to Photo Gallery. Photos transfer Ok except the order of the photo gets scrambled somehow during upload. In other words, the photos on the SD card are in chronologically order but after uploading, when I view them in Photo Galley, the order is all mixed up. I know you can manual move them around but it?s hard to be sure of the original order and it is very time consuming when you have hundreds of photos. I would appreciate any suggestions on how to fix them. FYI I would call myself a novice user of Photo Gallery.

A:Uploading photos from a SD memory card into Photo Gallery scrambles order of photos

Will the Photo Gallery sort by name? You could prefix the photo names with numerical sequence. A utility like
Introduction - Bulk Rename Utility will do it easily. It's free.

Edit: if that looks too busy, the multi-renamer in FreeCommander is a bit simpler to use. [c] before the name prepends a number starting at what you select and incrementing by what you choose. Just press F2 when in the folder.

2 more replies
Answer Match 42%

My sister has photos of me in my bridesmaid dress that she took with her camera. I saved them on my computer.
I am going out of town to see our family, and cannot take the computer, but want to show the pictures. I will have my camera.

I tried transferring the photos to my camera's memory card by changing their file names to the same type of name as the photos that were taken with my camera. They are displayed as DSCN0610, so I renamed the photos as DSCN0700 and so on. Then I put my memory card in the driver, (G drive) opened up the drive, opened the folder where the pictures from my camera were, and dragged the newly renamed photos into that folder.

I put the memory card back in my camera and hit the display button, and the message I am getting for the spots where those files are is "File contains no image data."

What did I do wrong? What do I do?

Information - My camera is a Nikon Coolpix.
 

A:Can I transfer photos from my saved photos on my computer onto my digital camera?

11 more replies
Answer Match 42%

Hello
I have 1000 photos in a folder (and subfolders) and I have a list of 300 photos I want to extract (or copy) to another folder
I tried to use the windows search file method (by using a comma (example: I tried to search for 100439,100536,100713,100795,100857,101008,101176,101184,101613,101842,102141,102221,102267,102301,102512,102579,102588,102695,103195,103209,103241,103328,103408,103470,103640,103942,104132,104248,104280,104337,104477,104485,104981,105066,105112,105465,105511,105589,105635,105791,105910,105937,106054,106100,106178,106183,106216,106364,106380,106410,) but it will only find up to 34 files
Do you know of a program or a way to do this?

Any help will be very much appreciated
Aron
 

A:Find Multiple Photos, extrat photos listed in databese

Hello,
AcDsee 7 will do as you ask,
http://www.acdsystems.com/english/products/acdsee/feature2?

 

3 more replies
Answer Match 41.58%
Q: Stamp

I want to create a sort of stamp to go on the bottom of documents, similar to the attatched file. I've done this using drawing and text boxes, but I want to know if there is a way of creating this box, so I can fill in the details in the box easily, as it's going to be used quite a lot. I don't want to be repeating this every time, and I want the box to be the same size every time.

Rob
 

A:Stamp

7 more replies
Answer Match 41.58%

Microsoft Photos app gets updated ? save still photos from videos and more

Microsoft has released a new update to the Windows 10 Photos app, and the new version appears to have started rolling out to some users. The app has been bumped to version 16.412.13342.0 and brings some new features along with the usual bug fixes, please find the detailed changelog below:

 ◾Save still photos from videos and living images
◾Slow-motion videos taken with a Windows phone can now be edited on your PC
◾When importing photos to a PC, quickly clear and select all
◾View your OneDrive storage usage in Settings
◾Adjust the lighting in photos taken with a Windows phone using rich HDR
◾New OneDrive pictures appear more quickly in Collection
◾Items now stay selected until you cancel or take action on them
◾Bug fixes

Read more at Source
Microsoft Photos app gets updated - save still photos from videos and more

More replies
Answer Match 41.58%

Wondering if it's a problem with the new version of Firefox (32.0.1). Since I've had the new version when I upload photos to an antique website, I see the broken image icon. In Facebook, the photos just never show up. I also can't attach photos to emails, they just don't upload. I haven't changed any plug-ins and I don't have any extensions. This doesn't happen in IE. Any advice or suggestions?
 

A:Can't see uploaded photos or attach photos in emails with new Firefox

Just a thought: suggest starting Firefox in Safe Mode to see if it's caused by an extension.
 
https://support.mozilla.org/ta/questions/1020272
 
Hope this helps.

2 more replies
Answer Match 41.58%

I have a laptop running Vista which came with some Google Gadgets. Initially the Photos gadget was working fine. As I decided to get my new computer organized (a mildly OCD thing to do ) I rearranged the folders that my photos were kept in. I noticed that NONE of my photos were appearing in the sidebar any longer so I clicked the link to 'add photos' and remapped to the My Pictures folder. This didn't help so I remapped to a deeper folder in order to get it closer to the photos. This didn't work so I remapped it down to a specific folder that doesn't have any folders in it. It only contains photos. Lo and behold... It didn't work. So... I searched the internet and found one question like mine with no answer following it. Needless to say, what looks like it should be a fairly straight forward adjustment has not been so. Please, what button am I not pushing to fix this?...
 

More replies
Answer Match 41.58%

Hi,
I have some problems with my iPod and I don't know if it started after I installed something or not, but this is what's wrong:
- The camera of my iPod starts and then crashes, OR sometimes if I start it it can take one picture and then the black screen with the white turning thing (which you also get when you turn off the iPod) and then it returns to the home screen
- The images app also doesn't start up. If I tap it, it opens but before the text ''camera roll'' and that stuff is loaded, it crashes.
- When my iPod is cabled (i know thats not a word) to my pc, a windows window appears for importing the photos on the ipod to the computer with windows. when I click import, the blue screen appears on my pc and luckily it can start up again. it happens every time. now that's not a very big problem.
- in itunes when i connect my ipod, a bar with some different colors appears, right? to show how much space apps, photo's, books, music and stuff you are using on your ipod. the problem is that there are no photos and i swear i had like 1 gig of photos on my ipod. i hope theyre not gone.

i couldn't find the email support on apple's website so i ask you.
how do i solve these things?

More replies
Answer Match 41.16%

See attachment.

This mail came with the time, 8:34 AM, on it. Exactly what does this time signify (emphasis on "exactly").

Is this time obtained from the sender's computer at the time it was sent (in which case it could be incorrect if the time on the computer is incorrect)?

Is the time obtained from the sender's SMTP server at the time it was received by the SMTP server? And, if so, is it adjusted to the sender's time zone if the SMTP server is in a different time zone from the sender's computer?
 

A:Exactly what does this time stamp mean?

8 more replies
Answer Match 41.16%

Has anybody been able to figure out Microsoft's time/date stamping. Many times I have looked at the properties of a file and the modified date is before the creation date. Another thing that I can't figure out is why the access time is the immediate time, I mean the now time, I know I am accessing it right now, I want to know the last time it was accessed. Is there anywhere else in window that does this better than just right clicking on a file and going to properties or did Microsoft fail horribly.

thanx
 

More replies
Answer Match 40.74%

On a new install of 7 I have dual monitors and the built-in photos screensaver is displaying photos in the middle of the field which usually means that the photo is shown in the secondary monitor but if it is too big for the secondary monitor it is partially split on both monitors. Is this a bug in the built-in screensaver or do I have it set up wrong? If it is a bug in photos screensaver is there a thrid party screensaver that does a better job at using photos as a screensaver? I have a 21" builtin monitor that is my primary display. It has a screen resolution of 1920x1080 and a 19" with a 1440x900 resolution set as a secondary display. While I am at it is there a thrid party program that will allow setting different backgrounds on each display?

More replies
Answer Match 40.74%

since 4 days photos which are camera rolled are deleted after some time they are not shown in one drive why it happens, is it any settings related to that

More replies
Answer Match 40.74%

I am having problems with my Surface Pro not pulling all my pics from facebook. It keeps saying something went wrong try again later. I have disconnected my Facebook account and started all over but it didn't help. Just noticed this today so I don't know when it started.

A:Photos app facebook photos sync - something went wrong

Hi, Im having the exact same issue with my Surface Pro. It looks like it synced cover photos from most albums, not all then gave up. Just the error message "something went wrong". I spent 2 hours working with MS Tech Support today, to no avail. Just tuning in hoping to find a solution. Have you had any luck getting yours to sync?

10 more replies
Answer Match 40.74%

I have a free upgrade from win7 to win 10. There is an icon on the desktop for photos. When I open it there are strange photos coming from somewhere and I can't delete them. How do I delete them and stop them from loading?

More replies
Answer Match 40.74%

Currently in my photos app, the photos are sorted 1,10,11 and so on. Is there a way to sort them 1,2,3 and so on?

More replies
Answer Match 40.74%

Hi

My sister recently got engaged, I took loads of photos of the big night, stuck them on the PC and cleared the memory card. Upon actually looking at them, they are all corrupted - they appear to have mixed with other pictures.

The thumbnails are fine but obivously this is a different part of the file.

A lot of the software I have come across is designed to recoved lost files rather than repair corrupt images - can someone please help!?!

I have uploaded an example here: http:[email protected]/3997977288/
 

A:Important photos are corrupt/mixed with other photos

6 more replies
Answer Match 40.74%

Rotating arrows never stop in the photos app.
Camera is using a continuous 30% of my battery usage, but says nothing is being used in the background (all is being used whilst being "managed by windows"), whatever that means.

More replies
Answer Match 40.74%

I have accidently imported my photos from my phone to the hp photo section on my notebook. I didn't want them to be on the computer but i wanted them on my external harddrive. I have been into the folder and highlighted all photos, copied them but when i try to paste them it wont allow me to paste them anywhere but in the photo's gallery where they already are. Any ideas how to remove them from the computer and put them onto my external hardrive?

More replies
Answer Match 40.74%

I used to have an @function which recorded time so that it did not update. Any ideas? I've tried @timevalue(@time) but it still updates. There is a way to freeze it but I can't remember how I did it!.
 

More replies
Answer Match 40.74%

Hello, I would be grateful if someone could assist me please. I have Photoshop CS and when I use the Clone Stamp tool, I notice that a black cross hair appears when I try to correct a portion of an image and the correction is taken from the cross hair location rather than from the brush location. This occurs when I try to 'paint' in an area.

Norbury
 

A:Clone Stamp Tool

Thats the way it works----It will clone one area to another area.----------------thus the name Clone tool.
 

3 more replies
Answer Match 40.74%

windows xp was working fine and it just froze so i restarted it
and it went to the disk checking and it came up with
invalid timestamps and it scrolled through a list fast i could not catch most of it and then went to the windows xp click your user name login screen

and the mouse moves until i click on the place to put my password and it freezes . . i've tried going back and restarting using safe mode, and even restore previous settings but it doesn't work

is my files screwed or is there any way of salvaging it?

i know this is kinda vauge and i could try to get more information if it is needed. some of the work i have on my computer is very valuable.

More replies
Answer Match 40.74%

Since there are two actual times that are unique for each single piece of email, time sent and time received, and they can not possibly be the same.

Is the time that an email leaves your PC, . . which is the time born on the email record in the sent file, . . the same time it bears when received by the recipient ?

A:Time Stamp on Email ?

Depends on a lot of things. First and foremost the way the sender and recipient mail servers are set up. Do they use UTC time or do they use local time? If you have that information then you can calculate time differences.

Other factors play into it such as when you send does your mail server have a malware scan queue so there is a delay? Is the mail sever set up to send in bulk at specific intervals. Like wise on the receiving end.

As I said many things can come into play when you hit the send button and dispatch your email to the ether.

4 more replies
Answer Match 40.74%

When the user receives a voicemail on the land line, they are sent an email via a voicemail-to-email tool. The email has a copy of the voicemail, duration, phone number, etc. The time stamp within the email is correct. However, the time stamp that Microsoft puts in the message is incorrect. It is off by approximately one hour. Both the time and date settings and Outlook settings appear to be correct though. The time stamp that I am referring to is below the Respond Group within the Message tab. It is directly above contacts name and the subject of the email. In Outlook options, there is only one time zone selected, which is: UTC-5:00 Eastern Time US & Canada. The data and time settings for the computer are correct too. When I forward the original email as an attachment and subsequently open it on a different workstation, it has the incorrect time displayed too.

I have rebooted the workstation, performed a repair to Office, and opened the affected emails on another workstation (same problem). Any ideas how to resolve this problem?

A:Time Stamp Incorrect

Have a look at this MS website, which mentions Daylight Saving Time as being a possible cause.

https://support.microsoft.com/en-au/kb/2466942

1 more replies
Answer Match 40.74%

Hello all:I'm using Adobe Acrobat Pro 8.0, and have been trying to create a 'custom' stamp. The source of the stamp(s) are in the plug-in folder in the Acrobat directory, marked as 'pointers'. I am following the help section's directions word for word and I'm getting no results. After selecting the new stamp I am prompted to select one of the three default categories, or create one of my own. I've tried both, but when I save everything and all is said and done, I go to the stamp toolbar and my 'custom' stamp is nowhere to be seen. The custom category isn't showing up except in the 'manage stamps' dialog box.So after fiddling with it a bit more, I can create a new custom stamp, assign it in a new category, then close out the dialog box. When I next click on the stamp button (not its drop-down menu) my custom pointer shows up and is available to use. The problem is that my custom category is not listed among the others. Essentially I'm only able to use just one custom stamp, but the instructions clearly indicate that I can have a custom categories with multiple custom stamps.So I'm pulling my hair out over this issue. Is anyone out there familiar with using Acrobat stamps? (I really hope I'm making sense in this post LOL)Any help is very much appreciated. Don't hesitate to ask for more info should you need it.

More replies
Answer Match 40.74%

Hello everyone,
I have a question about unlock the fields on the stamp. I actually know how to do it, but doing it manually take a lot of time, if some one know how to do it, or how to add stamp without locking fields to document I will be so appreciated. Thank you.
 

More replies
Answer Match 40.74%

We've converted most of our pc's from XP to Vista 32 bit but have an issue when viewing shared pdf files from our FTP server. On every existing xp machine the date created time is correct. On every Vista machine the (date created / modified) time is off by 6 hours. I've checked my time zones and they are correct. Any ideas?

More replies
Answer Match 40.74%

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
Answer Match 40.74%

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

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

16 more replies
Answer Match 40.74%

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
Answer Match 40.74%

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?

A: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
Answer Match 40.74%

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

7 more replies
Answer Match 40.74%

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

10 more replies
Answer Match 40.74%

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

16 more replies
Answer Match 40.74%

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

A: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
Answer Match 40.32%

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
 

A: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
Answer Match 40.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

A: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
Answer Match 40.32%

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.
 

1 more replies
Answer Match 40.32%

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

9 more replies
Answer Match 40.32%

Receive an email at 5:24 PM (outlook express verifies time on my computer)

(from the header)
Received: from fep3.cogeco.net (smtp2.cogeco.ca [216.221.81.29])
Received: from 236MM (d221-84-244.commercial.cgocable.net [216.221.84.244])
by fep3.cogeco.net (Postfix) with ESMTP id ED17545F
for <[email protected]>; Fri, 13 Apr 2007 17:24:27 -0400 (EDT)

My clock is correct, senders clock is correct ... I go to forward the message at 5:24.
See below the time sent: 1 hour ahead (6:24)

Where is this time coming from, headers and clocks are all OK ... I'm stumped,
and it appears to be causing a spooling backlog on certain mail servers.

Any suggestions or thoughts, as to why this is happening?

----- Original Message -----
From: Sender
To: 'Me'
Sent: Friday, April 13, 2007 6:24 PM
Subject: RE: mail test
 

A:Email Time Stamp Problem

1. Check to see if you are in the correct time zone; not only if your clock says the right time. (same area as you would go to change the time)
2. Check through the settings of Outlook Express to see if there is a place you can change the time zone.
 

3 more replies
Answer Match 40.32%

I have a system image created today at 9:58am according to Windows Explorer. When I boot the Repair Disk and select that image, it shows the time as 6:59am --3 hrs earlier.

I checked my BIOS and it shows the correct time.

Anyone have any idea why this difference?

Thank you.

A:System Image Time Stamp

When you used the boot (rescue) disk, were you prompted to enter your timezone at one point after Windows booted up?

I suspect this may simply be a matter of setting the correct timezone when the disc-based Windows prompts you for it.

2 more replies
Answer Match 40.32%

I have a new surveillance system at a home I bought to flip and I have been having all sorts of problems understanding its setup. I have called Samsung's tech support many times for various problems and their universal solution for every problem is to reset the unit to factory defaults before working on any problem. I've been through that so many times that my frustration with their tech support has now turned to anger. The re-setup of all my users and other customizations after their lame tech support costs me hours of work afterward.

So, here's my problem: I want to use the DVR's synchronization with an internet time server; but I can't find the correct settings. When the DVR's console displays the correct time, the time stamp on alert e-mails is several hours off. If I adjust the GMT, so that e-mail alerts have the correct time stamp, the time displayed on the DVR's displayed time is several hours off.

I'm in the CDT zone (USA) and I use a futurequest.net mail server ( [email protected] )

Can anyone help me with this?
 

A:Having Trouble with GMT, E-mail Time Stamp, etc.

16 more replies