The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
2answers
406 views

Convert Month Number to Month Name

Is there a way to convert month number to name with a script? example: 2013-10-22 will become Oct 22 Thanks. BTW, I don't have the GNU date and my OS is AIX.
1
vote
1answer
182 views

Excel Date Formula with a condition

I have 3 fields in excel as follows: Cell A1=2012 A2=12 A3=15 which contains year, month & date value respectively. And I want to make a date string out of it. I know it's very easy to achieve ...
1
vote
1answer
306 views

How to use the current date as an argument?

I have a batch script which extract SQL data to CSV file: bcp Database.dbo.MyTable out C:\Reports\Output.csv -s ServerName -T -c I need the name of the output file to contain the current date. For ...
1
vote
1answer
414 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 ...
1
vote
2answers
3k 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 ...
1
vote
1answer
387 views

How to keep windows 2003 Daylight Saving values updated

My web app runs on windows 2003 .Net 3.5 I have users from Israel (GMT +2), and Israel switched to Daylight saving time on 26/3/10 so now it's (GMT +3). I use TimeZoneInfo.ConvertTime that doesn’t ...
1
vote
1answer
1k views

How to change time (Advanced Eastern Time) on Slackware 8.1

I have a linux (Slackware) machine and the time/date is like, June 23rd 2003, 10:00am (It's 11 here) and I am not able to set the time to have it correct. I change the timezome to Montreal but the ...
1
vote
0answers
5 views

Run Query in Siebel on Modified due date

I want to run a query for open SRs by Modified due dates. I cannot find that field in normal query. Please help me out.
1
vote
1answer
39 views

Converting date Jan-12 2015 10:51AM to Date format for sharepoint use

I have a date that imports into excel from an external source as Jan-12 2015 10:51AM, but is not a friendly date format for copyinging into sharepoint 2013 datasheet. How do I convert this in excel so ...
1
vote
0answers
15 views

LC_date like option for excel sheet (possible in libre office)

Windows 8.1, office 2013, english interface - danish region. When working in excel I often paste dates from another application. These dates are in the form Januar 2013. When pasting, it seems excel ...
1
vote
1answer
29 views

Make folders' last modified date correspond to last modified date of its child folders/files

I am working with FileZilla to locate the last modified files of my website. I thought the last modified date of a parent folder will correspond to the latest last modified date of its children files ...
1
vote
1answer
20 views

How do I have a Date format show in a Formula that is looking up that cell?

I have a formula: ="('"&A6&"','"&B6&"','"&C6&"','"&D6&"','"&E6&"')," And B6 is a date and formatted as dd/mm/yyyy (have tried all forms though) so the ...
1
vote
1answer
40 views

Create a non standard weekly date range autofill in excel

I am working on a monthly spreadsheet of our daily takings. I need one line for a sunday, monday and tuesday but two lines for wednesday, thursday, friday and saturday. I can't seem to hit the magic ...
1
vote
2answers
101 views

How to set date for a specific program?

after june 2008 the game gears of war is giving error and not running. so when I want to play it, I need to change date about 6 years. so I'm curious is there anyway to set the time for a single ...
1
vote
0answers
168 views

How to find out when an audio disc (CD) has been written/burned?

Is there a way/tool to determine the date and time when an audio disc (CD) has been written/burned? I am aware of How to find out when a disc (DVD) has been written/burned? but the accepted solution ...
1
vote
1answer
3k views

Change All User short date format in Windows 2008R2 using script

I have hundreds of users in Windows 2008 R2. How can i change these user's Regional setting's short date format to DD-MM-YYYY using script ? Thanks
1
vote
4answers
908 views

Mac OSX Numbers - Convert text to datetime

I am using Numbers on a Mac. I have a CSV file which contains numerous dates in the format MM/DD/YYYY. I need to convert these dates into datetime format for insertion into a MySQL table. How do I ...
1
vote
3answers
341 views

Make Excel recognise date in custom format

How can I make Excel recognize a text in the following format as a date and time? I have the following date in on cell: Tuesday, December 3, 2013 1:54:26 PM +01:00 And would like Excel to format the ...
1
vote
1answer
3k views

How can I get the displayed value of a cell in MS Excel ( for text that was converted to dates)?

How can I get the displayed value of a cell in MS Excel ( for text that was converted to dates)? Excel File Origin I have an Excel file that was originally a CSV file. At this time I don't have ...
1
vote
2answers
644 views

Convert Day of the Year in Excel?

How can I convert Day of the Year to a mm/dd format in Excel? Date of the Year: e.g. 1= Jan 1, 177 = June 27. For example, how do I convert "177" to 6/27?
1
vote
0answers
207 views

Change the Default Date setting in Word 2010

I am using Word 2010 and Windows 7. You know how when you start typing a date in Word it will automatically suggest what it thinks you want? Like if I start typing “6/29”, a little grey bubble will ...
1
vote
2answers
2k views

Convert date from Taiwan to Gregorian in Excel

I've got some data from Taiwan in a .csv spreadsheet, but the dates are all in their patriotic calendar like this: 102/06/05 102/06/22 102/07/01 ... I need them in Gregorian format like this: ...
1
vote
2answers
2k views

How to set mergefield to show long date format?

How can I make Word 2012 display German date format in mail merge? { DATE \a "dd.MM.yy" \ * MERGEFIELD } returns 15.02.2012 for today, 15. Februar 2013 however is what I want.
1
vote
0answers
498 views

What format can I use in Excel to display both date and time in system formats

I need to display both date and time in system date and time formats. I know that [$-0xf800] means the system long date format and [$-0xf400] means the system time format, but [$-0xf800][$-0xf400] ...
1
vote
0answers
274 views

Change date in a SQL query to reference a cell in Excel

I have the following code that returns the needed data into excel and manually changing the date will change the returned data; however, I'd like to reference a cell with a formula that will make the ...
1
vote
1answer
318 views

Picasa has re-edited all my photos randomly

I use Picasa to manage my photos. I recently switched from a Windows machine to a Mac, so I used an external hard drive to transfer my photos from the old computer to the new. Everything was fine at ...
1
vote
0answers
3k views

Excel conditional formatting, greater than a year

I am working on a spreadsheet that logs the dates parts were sent out and would like to apply conditional formatting to the dates. I would like if over 3 years ago, if over 2 years ago, if over 1, ...
1
vote
0answers
165 views

ms excel 2010 in windows xp - when open workbook the data is formatted differently than when i saved it

I haven't been able to find an answer to this. I have multiple files that I use regularly in excel that now have cell formats of "date". Every single cell in the entire workbook (all sheets) is ...
1
vote
0answers
181 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 ...
1
vote
3answers
305 views

check of date with functions lookup

i have input date in sheet1 say in A! 15/07/2010 and in another sheet range of dates with interval of six months in a1 01/01/2010 and in b1 30/06/2010 and c1 15 likewise data is there i want to ...
1
vote
2answers
2k views

How to convert dd.mm.yyyy date format to yyyy-mm-dd in Excel 2007?

My customer entered date in dd.mm.yyyy format. As I want insert all the data in mysql database, I want the date in yyyy-mm-dd format. I tried to format using Excel custom date format and built-in ...
0
votes
1answer
85 views

Return day number in year from date in Excel

I am trying to show the date in an adjacent cell as the number of days in the year. Jan 1 would be 1, Feb 1 would be 32, Dec 31 would be 365. Also the reverse, how many days are left in the year. Jan ...
0
votes
1answer
61 views

Convoluted Date Lookup

I found this, which is pretty close, but I don't know VB, so I'm trying to do this with a vanilla formula. First worksheet has a series of tables of unemployment rate: 1 per US state. Each table ...
0
votes
4answers
185 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 ...
0
votes
1answer
72 views

How to use DATEVALUE with diffent locale setting without changing system settings

I have an Excel column that uses US date format, i.e. MM/DD/YYYY, but is a text column. I need to convert it to the date column for which I'd normally use the DATEVALUE() function. However, because my ...
0
votes
3answers
2k views

Better way to replace timestamp by date when reading a squid log

Tonight i was trying to look at my proxie's lines, and I came up with this, which seems all but KISS. How would you do it simply ? awk '{ trunc=sprintf("%.0f", $1) ;$1="" ; system("echo -n `date +%R ...
0
votes
2answers
261 views

Set Linux date with ddmmyy

I need to set the date of a Linux box with a string I get from a program. This string is formatted as ddmmyy. Is it possible to use that directly or do I need to reformat it first? Currently I have ...
0
votes
2answers
47 views

Changing date on Ubuntu without sudo privilages

I am trying to automate a time change on Ubuntu 10.04 with a bash script using the date command. The script works, but it requires sudo privileges, however, the user who will execute the script does ...
0
votes
3answers
148 views

Ask for date on boot (challenge)

Issue An old laptop computer with XP loses date every time it boots. It has no more battery pack so it has to be plugged permanently in to wall. What I already tried Replaced the little button ...
0
votes
3answers
198 views

How to calculate the first occurrence of a given weekday in the next year in Excel?

I need to calculate the first occurrence in the next year of the weekday of the date in cell A1. For instance, if the date in cell A1 happens to fall on a Thursday, calculate the first Thursday of the ...
0
votes
1answer
154 views

DateTime to just Date

In LibreOffice, Calc under Linux, I have a table with DateTime values (eg. 2011-06-15T15:37:56+00:00). How shall I convert these values to just Date values (eg. 2011-06-15)? I suspect it is very ...
0
votes
1answer
308 views

How does `date` calculate time zone offset? [closed]

If I set the time zone environment variable: TZ="Foo/Bar", how does date handle different time zones and display the date accordingly?
0
votes
3answers
6k 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 ...
0
votes
2answers
153 views

CSV opens in OpenOffice but adds slashes?

Trying to open a CSV in open office - but it alters the data. Here is the the CSV in its raw format (opened in Notepad); 10-1001,product name 1, 10-1001-020,product name 2, 10-1001-030,product name ...
0
votes
3answers
46 views

How do I get the fiscal year to start on a specific date each year in Excel?

I used the formula listed here to generate a fiscal year based on the current month. I have an odd requirement where she wants the fiscal year to start on 6/20. For example, any dates ranging from ...
0
votes
1answer
83 views

NTPD not updating time date on CENTOS

I have set up ntpd on CENTOS, I am trying to get it to pull time from a Windows domain contoller if i run the command: ntpdate dc3.mydomaain.local this works fine and updates the host with the ...
0
votes
1answer
144 views

Convert datetime to another datetime format

How do I convert this datetime? [23/Sep/2013:21:18:00 +0200] to 23/Sep/2013 21:18:00
0
votes
1answer
95 views

Tar archive wrong creation date

I have a script to backup some directories: tar cjf /backup-`date +\%m-\%d-\%Y`.tar.bz2 mydir >> /dev/null 2>&1 At the end of the process, a "ls -al" show something like: -rwxr-xr-x 1 ...
0
votes
3answers
8k views

CountIf Formula that counts cells containing any and all dates without having a date range?

I need to simplify a CountIF formula. Instead of having a date range I just need my COUNTIF to count cells cointaining dates disregarding date range period. I have tried for example simplifying it ...
0
votes
1answer
319 views

Batch script or set of commands to extract the fields of date

I am trying to create a batch file to backup my data at regular intervals in Windows using a batch script. I need date parameter and the fields from the displayed format (Month, day and year). ...