The date tag has no wiki summary.
0
votes
1answer
39 views
Show the date on pictures
I have pictures, each with a date-taken tag.
How do I "stamp" that date onto the picture? (For example editing the picture, putting the date onto the actual picture, not just an overlay...)
1
vote
1answer
20 views
How to tell when RedHat was last updated
I have a RHEL 5 server and I want to know the last date in which it was updated.
Is this technically feasible? If yes, how?
0
votes
1answer
53 views
Creating a column of working days in LibreOffice Calc
In LibreOffice Calc, I would like to create a column of working days, for example:
[...]
2012-01-30 [Monday]
2012-01-27
2012-01-26
2012-01-25
2012-01-24
2012-01-23 [Monday]
2012-01-20
2012-01-19
...
1
vote
1answer
48 views
Why is event-log time different from taskbar time?
Today is the first time in several months that I've opened up Administrative tools to view the event log.
Imagine my consternation when I saw events in the log with a time-stamp of 11/09/2012. The ...
12
votes
2answers
172 views
Is it possible to determine when a NTFS partition was created?
We have a client where it would be very useful to determine WHEN a drive was a initialized or an NTFS partition created. Is there a timestamp value somewhere? If anyone could shed any advice it ...
3
votes
3answers
88 views
How to get the dates of the current monday, wednesday and friday of the current week in excel?
I'd just like a simple formula to return the date for the current Monday, Wednesday and Friday based on the current date.
So, I would like to see it like:
Cell A1 I'd like (Today is Monday ...
2
votes
1answer
50 views
Excel conditional formatting to highlight entire row if one date is not equal to another date in that row
I'm trying to use conditional formatting to highlight an entire row if the date in column D is greater than the date in column B. I can't seem to make it work. Is it a problem because it's a date ...
0
votes
1answer
40 views
Windows 7: How to display both date and time in tray *without* using large icons or increasing the height of taskbar? [closed]
Possible Duplicate:
Windows 7 - display date using small icons
As we approach the year 2012, there has to be a way to show the date and time in Windows 7 without doing any of the following:
...
0
votes
3answers
80 views
Linux date command is 4 minutes slow
I installed Centos onto my server and I noticed that when I compared the date command's output to time.gov (same timezones, of course), the output was 4 minutes behind. This also affects my ...
2
votes
1answer
92 views
What excel formula can I use to calculate the 2nd Monday of a given month?
What excel formula can I use to calculate the second Monday of a given month?
You can assume I have a cell containing the first day of the month to work with.
In the interests of other users, can ...
0
votes
1answer
117 views
How to convert decimal years into a date (format dd-mmm-yyyy or similar) in either Excel or SPSS?
I've found a fair number of formulas online which let me convert birthdate into decimal age in years but I can't find something that converts, for instance, 1.0 into 04-Nov-2011.
Any help would be ...
0
votes
0answers
91 views
Why does exiftool make the current date and time shift?
When I try to shift the date and time using exiftool on both OS X and Windows I get the same outcome: the current date and time changed instead of adding 2m 18d 11hr 14m 0s.
exe file and command run ...
4
votes
1answer
34 views
Word mixing up dates (1923 becomes 2023)
Using windows 7 I find that MS-Word is reffering to the system settings to interpret data.
In one of the apps I use, a date is exported with a 2 digit year, even though the setting in that application ...
0
votes
2answers
148 views
How to change the date of Linux to UTC/GMT +1?
I need to change the date of my system. I'm running a Linux CentOS 5.6
# date +%Z
UTC
# date
Thu Oct 6 11:42:45 UTC 2011
How to change the hour to be UTC/GMT +1?
Best Regards,
0
votes
2answers
264 views
Ubuntu clock is wrong and I can't change it (running as VirtualBox Guest under OSX)
I have a strange problem with my Ubuntu Natty virtual machine running under VirtualBox on OSX.
One day last week, my clock on the top bar in Gnome stopped displaying the correct time (I'm not running ...
3
votes
1answer
73 views
How do I parse a nonstandard date format in Excel?
I have a column of date-like string values in the format yyyy-mm-dd, such as 2011-Sep-13. I need to convert these to Excel date serial numbers so that I can use them in formulas.
DATEVALUE isn't ...
1
vote
2answers
83 views
Excel macro date parser cannot handle single-digit days
From previous questions on this and other sites I was given a function that can parse for and find dates in text strings or cells. Here's the function:
Function GetDate(strInput As String) As Date
...
2
votes
4answers
136 views
How to cd to a newly created dir?
cd "$(mkdir -v "$(date -R)"|sed s+.`(.*)'.*)"
This is meant to create a dir named $(date -R). I could simply cd $(date -R), but the culprit is the date could change since the previous command was ...
2
votes
2answers
83 views
Convert “Mon Aug 01 09:08:25 CDT 2011” to a usable date/time using Excel
I have a giant spreadsheet with computer names and the date stamp that they last reported into our PGP server that I need to convert to a usable date/time, so I can sort the column by the time the ...
3
votes
4answers
529 views
How to get the Date in a batch file in a predictable format?
In a batch file I need to extract a month, day, year from the date command. So I used the following, which essentially parses the Date command to extract its sub strings into a variable:
set ...
5
votes
1answer
35 views
How to search in windows according to access date
I have found only according to "date modified" and not "access date"
I haven't found any ways of sorting this correctly. Maybe I should use third party software?
0
votes
0answers
77 views
Microsoft Outlook appending date and time to subject text
I receive emails every day with pdf attachments. The command limits the size of user email box.
Subject: North Island Work Orders.
Need to move email quickly without having re-edit the subject ...
0
votes
5answers
358 views
How to set current time on Linux?
Why is the output of the following commands different?
root@vmi2115:/var# hwclock
Sun 26 Jun 2011 01:21:38 PM CEST -0.273230 seconds
root@vmi2495:/var# date
Sun Jun 26 15:21:39 CEST 2011
...
0
votes
1answer
131 views
Getting the week number based on date with different first day of the week in gawk
How to get the week number in linux using gawk with different first day of the week? the date command can give me the week number with +%V but it is based on Monday (1-53) or +%U (based on Sunday, ...
1
vote
0answers
107 views
Reference a date field, auto-calculation in Word-2007
I'm using a Word 2007 template for a weekly activity report.
It looks like this:
I'd like to be able to just specify one date, say the first date of the week, and the others would adjust ...
1
vote
1answer
109 views
find on command line reports back illegal time value
I want to run the following command:
find . -mtime -60s
When I do I get this output instead:
CLIENT% echo `date +%s`-1308741881 | bc
5152
CLIENT% find . -mtime -`echo `date +%s`-1308741881 | bc`s
...
2
votes
4answers
269 views
Store the output of date and watch command to a file
I am a newbie to linux and I am trying to watch a command and try to log it into a file. I tried
watch -t -n 10 "(date '+TIME:%H:%M:%S'
; ps aux | grep "pattern" | wc -l)" >>
logfile
and am ...
3
votes
2answers
147 views
How to make an application detect if system time has changed in Linux
I need to write a small application which needs to detect if the system time is changed by an another application/user and perform some action as soon as it is detected (maybe log the data that time ...
0
votes
1answer
94 views
Can I set a unique date/time for a single user in Ubuntu?
Is there a way to give different users unique system date/times in Ubuntu?
For example, if I wanted the date to always be June 22nd for user Bob (because that's his birthday) but still have the ...
1
vote
2answers
130 views
How do I list files modified on or before particular date?
Using linux commands , is there way to list files which are created an hour (or particular date) before ?.
4
votes
2answers
38 views
Formatting Dates
I have the following formula:
=D56&" "&"("&D57&" Days"&")"
D56 has a date within the cell. I want to format the date like 5/5/2011 but I'm not sure how to do it.
1
vote
3answers
184 views
0
votes
0answers
84 views
Auto-update field for number of days elapsed since specified date in Word
I have a Word document that needs an auto-updating field to display the number of days that have elapsed since a specified date.
Is there a field code (or even VB Script) that would do this?
I've ...
1
vote
0answers
112 views
Auto include save date in filename?
Can I set an option to automatically include the save date in an MSWord filename?
1
vote
1answer
219 views
Put date into backup .tar.gz filename
I'd like to run a simple tar command to backup my website directory. It will run through cron, but I want to be able to put the time at which the backup was made as the filename. I don't really mind ...
1
vote
3answers
131 views
How can I convert non-standard date data in Excel?
For some silly reason the data I've been provided has dates in the following format: mmddyyyy but if the date is something beginning with zero (e.g. 03132010) then it shows up without the leading ...
0
votes
4answers
122 views
Unix script: use of date and use of for
MinuteNow=date +%M;
for ((i=2;i<=57;i+=5))
do
if [ "$MinuteNow" == "$i" ]; then
*************
fi
done
The problem is for 2 and 7, the date commande output is 02 ...
2
votes
1answer
178 views
why do some emails have impossible (past) dates?
I just got a spam email dated 1970/1/1. I laughed, but then thought about it a bit more. I get these from time to time - always spam - and assumed they did this to stand out in your inbox.
But I'm ...
1
vote
1answer
1k views
Sharepoint Gantt chart - default view to always show 'today'?
I have a gantt chart which always defaults to the start of the first bar (earliest point in time)
This is very annoying in our dashboard as I can't see where we are on this i.e. it should be dynamic ...
0
votes
2answers
44 views
Any website/software where I can add some text rows on daily basis
I have few notes or text like few remembering lines on daily or weekly basis.
I want to write it. but i should be able to see at any backdate /monthly or yearly.
The date-time should also be stored ...
1
vote
1answer
54 views
Stop Microsoft Excel 2007 from formatting anything?
How can I stop Excel 2007 from modifying any character, I don't want to modify the date in any way, I don't want to modify misspells, nothing.
I just want to see the exact text I'm writing.
1
vote
0answers
81 views
VirtualBox guest not recognizing daylight savings transition
I want to test an app's behaviour during transitions in and out of daylight savings time. I therefore want to be able to set the date and time of a VirtualBox VM, (preferably from the Control Panel ...
2
votes
3answers
1k views
Bash: how to convert from day of year and year to a date YYYYMMDD?
I'm looking to go from day of year (1-366) and year (e.g. 2011) to a date in the format YYYYMMDD?
0
votes
2answers
242 views
Converting date format in formulas in Excel
I have a column of dates in the following format ddd mmm dd hh m:s "EST" yyyy. In another cell in another sheet, I wish to have the dates in the format dd/m/y. How can I do this?
I already tried the ...
1
vote
3answers
753 views
Difference in command line date format between XP & Windows 7
The DATE command in XP gives the date in the format ddd dd/mm/yyyy e.g. Sun 12/12/2010.
In Windows 7, it only gives dd/mm/yy I.e. 12/12/2010.
Both have the same regional settings.
Can Windows 7 be ...
1
vote
2answers
328 views
How to get date value in commandline
I need to do a command that takes yesterday date and builds it into a file path like this:
copy "Something 2010-12-06\*.zip" "d:\Copy\"
where 2010-12-6 is yesterday's date in format yyyy-mm-dd.
...
2
votes
1answer
483 views
Adding Weeks to Current Date in Excel 2007
How can a given number of weeks be added to the current date in Excel 2007? For example, if I need to add 12 weeks to the current date, 12/6/2010, how can that be done?
1
vote
1answer
93 views
Inaccurate dates displayed in Excel (dates being calcuated from 1904 instead of 1900)
I have an excel spreadsheet containing a column of dates.
When data is copied from other spreadsheets into this spreadsheet the dates change and become inaccurate.
Changing the format of the ...
1
vote
1answer
688 views
DOS Command Lines Move files to folders named with previous month
I am trying to create a task in the Task Scheduler that will automatically move some pdf files into another folder that is based on the date in the pdf files which is for the previous month. The ...
1
vote
1answer
421 views
Converting a five digit number to date format in excel?
In these spread sheets I have an entire column of values that are supposed to be dates, such as.
200701 = 1/1/2007
200702 = 2/1/2007
200905 = 5/1/2009
And so on and so forth.
These will all be in ...
