The date tag has no wiki summary.
0
votes
1answer
28 views
Calculate age in days/months/years in OpenOffice
In need to find the age in days - months - years in OpenOffice.
There is DATEDIF() in Microsoft Excel. You can use it to find the difference in days/months/years between two dates.
Age Calculation
...
0
votes
0answers
30 views
Linux stuck one hour ahead (CentOS)
I use CentOS, and for some reason, one of the servers I bought (amongst a network of other servers I do not own) is off by one hour. The time is one hour ahead no matter what time zone I set it to.
...
1
vote
2answers
57 views
Set relative time using command line
Using something similar to the date command, is it possible to set the date and time relative to 'now'?
So instead of something like date +%T -s "10:13:13" something like date -s +1h or something ...
2
votes
1answer
86 views
How to set-up date for cron weekly backup?
I'm writing a command for cron to do automatic backups for my flashdrive.
I use tar ... -N <some date> to make the backup.
The issue is how to write the command which gives me the right date.
...
1
vote
1answer
122 views
What was scientifically shown to support productivity when structural organizing/accessing file and folders? [closed]
My Personal Information Management problem
I have gathered terabytes of data but it has became a habit to store files and folders to the same folder, that folder could be kind of seen as a Inbox ...
1
vote
1answer
156 views
How do I enter dates in ISO 8601 date format (YYYY-MM-DD) in Excel (and have Excel recognize that format as a date value)?
I tried to enter this date in ISO 8601 format (YYYY-MM-DD) in Excel 2010: 2012-04-08, but Excel automatically converts the date format to 4/8/2012.
I tried scrolling through the different types of ...
1
vote
0answers
44 views
UTF/unix time conversion in access
I am fairly good with access/excel/etc. However I am running into a brick wall with a database I query regularly for information. It has date/time fields that are tracked in unix time format (number ...
0
votes
3answers
97 views
How to stop Excel Treating US dates as UK dates?
I'm in the UK, I've got a problem where I've got a list of dates supplied in US format. Excel seems to treat the ones that are valid in both formats as UK dates, (e.g. 03/01/2012 becomes 3rd of ...
2
votes
1answer
96 views
Split time in arbitrary periods, EXCEL
I have a list with date and quantity of items used
IE:
2009.03.18 -1
2009.06.05 -2
2009.06.22 -1
2009.06.29 -2
2009.07.14 -1
2009.07.14 -1
2009.07.14 -2
2009.07.20 -2
2009.07.30 -1
...
1
vote
2answers
48 views
How to override date format in regional and language options?
In Windows-XP, It's not possible to display the date format in DD/MM/YYYY, because it wasn't available in the regional and language options.The following image'll illustrate my problem.
So i'm ...
2
votes
2answers
132 views
Excel auto Gantt chart
I have a spreadsheet with 4 columns. Teachers, Class Taught, Class Start (date), Class End (date). I need to plot this in excel somehow to show what days of the month are booked by each teacher.
I1 ...
0
votes
1answer
44 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
53 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
202 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
91 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
239 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
140 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
267 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
118 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
105 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
148 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
229 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
114 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
36 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
639 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
798 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
130 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
133 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
153 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
106 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
1k 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
61 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
136 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
1k 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
191 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
160 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
143 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
...
3
votes
4answers
659 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
271 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
110 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
176 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 ?.
5
votes
2answers
47 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
340 views
2
votes
0answers
128 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
390 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
175 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
140 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
262 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
2k 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
45 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 ...
