Tag Info

New answers tagged

0

Reusing and enhancing a previous answer to shift files dates with a reference file/date (the old GoPro always reset its time to 2009..) ref_file=GOPR3440.MP4 new_time_for_that_file=0327160015 #date's format: 27th March 2015, 16:00 ref_file_timestamp=`stat -f %B -t %s "$ref_file"` new_time_timestamp=`date -j $new_time_for_that_file +%s` ...


0

I've located the issue! - Apparently, by default (which can not be turned off) Excel says "Hey, I recognize that data type, ill convert it, for your convenience" (Gee thanks excel!) You can either format all cells as text CTRL+A => CTRL+1 => Select: Number_tab...Category: Text => OK or you can insert data into a cell with an apostrophe (') before. So the ...


1

I may not understand your example clearly, but it looks like you could just use one of these cell formulas: =IF(ISBLANK(B5),"",TODAY()) =IF(ISBLANK(B5),"",NOW()) =IF(ISBLANK(B5),"",Updating_Date(B5)) If you want to do the check in VBA, here's an option: Function Updating_Date(dependent_cell As Range) If LenB(dependent_cell.Value) > 0 Then ...


0

You can change the default "Short time format" by going to: Region & Language -> Additional Settings -> Time Tab -> Short time Simply set this value to: h:mm:ss tt and you'll have seconds shown on file properties now.


0

From the terminal: $ date +'%^a, %d %^b %Y' SUN, 22 MAR 2015 $ date +'%a, %d %b %Y' Sun, 22 Mar 2015 prepend a null LC_TIME as in LC_TIME= date ... to have it show in English/Default locale Might it be "the desktop" trims off the ^ character from the definition? Is it possible to prepend an escape character, say that you enter \^ for each ^ you wish to ...


1

If your reference date is in cell A1 : =IF(RIGHT(TEXT(A1;"dd-mm-yyyy");1)="y";TEXT(A1;"jj-mm-aaaa");TEXT(A1;"dd-mm-yyyy"))


0

What's your input? If you have any date in A2 this formula will find the last Wednesday of that month =EOMONTH(A2,0)+1-WEEKDAY(EOMONTH(A2,0)+1-4) Format result cell in required date format change the 4 at the end for other days, 1 for Sunday through to 7 for Saturday In Excel 2010 or later you can use WORKDAY.INTL function to get the same result, e.g. ...


2

If month is in B1 and year in B2, try for the last wednesday: =DATE(B2;B1+1;1)-1-MOD(WEEKDAY(DATE(B2;B1+1;1)-1)+3;7) and for the last friday: =DATE(B2;B1+1;1)-1-MOD(WEEKDAY(DATE(B2;B1+1;1)-1)+1;7) Weekday gives you the day number of the week. MODing it with 7 gives the number of days that needs to be subtracted from the last day of the month. To find the ...


1

Here's what worked for me. Format - mmddyyyy_HHMMSS echo %DATE% %TIME% Date format = Thu 03/05/2015 15:48:26.22 echo mm = %date:~4,2% echo dd = %date:~7,2% echo yyyy = %date:~10,4% echo Timestamp = %date:~4,2%%date:~7,2%%date:~10,4%_%time:~0,2%%time:~3,2%%time:~6,2% Timestamp - 03052015_154013



Top 50 recent answers are included