I have date format in an excel sheet as 07/03/2014 11:21. I need to check this date with current date and need to find whether it is more than 30 days or not.
I know how to current date into days, but someone please help me to change the date in the excel sheet to days, so that i can check with simple expr function.
Regards,
Arasu
If you have that in Excel already, why not just do it in Excel? Wouldn't that be easier ?
Use this formula:
where B2 is the cell with your date of 07/03/2014 11:21
That'll return TRUE if it's older than 30 days, FALSE if not.
By the way, is that March 7? or Jun 3 ?
:P
If you want it to return a numeric (maybe easier to use in Unix later):
1 = old
0 = not old
hello !
can so help me ? i'm writting a shell srcipt ( UNIX AIX) and I'd like to convert a date as 20041108 in lilian format.
thanks so much (2 Replies)
Hi ,
I have a csv file and column 1 is date in the cursed YYYY-M-D format. Is there any way to convert 1st column to an absolute date say using 1977-1-1 as day 1?
Thanks a lot. (2 Replies)
Hi Guys,
I was working some time ago n was in need to calculate date 30/31 days from today including Feb (Leap yr stuff). Today date is variable depending on day of execution of script. I tried searching but was not able to get exactly what I needed....So at that I time I implemented by my own... (3 Replies)
Hi,
I'm writing an batch file to create report
In the batch file iam passing two arguments:startdate and finishdate
Ex: startdate=07-sep-2009 finishdate=07-sep-2011
I need to have script that takes command line argument as input and gives me out currentdate last year and current date... (2 Replies)
Hi i am writing a cron job.
so for it i need the 60 days old date form current date in variable.
Like today date is 27 jan 2011 then output value will be stote in variable in formet Nov 27.
i am using EST date, and tried lot of solution and see lot of post but it did not helpful for me. so... (3 Replies)
Hi,
I want to subtract 'n' days from the current timestamp in a k shell script. Is there any inbuilt function to do it
or any workaround solution to get the date. And I want the output to be in YYYY:MM:DD HH:MM:SS format. Please help.
Thanks in advance. (4 Replies)
hi friends,
I m trying to write a script which compares to dates.
for this i am converting dates into no using synatx
as below
v2=`date | awk '{print $2,$3,$4}'`
v3=`date +%s -d "$v2"`
this syntax is working in bash shell ,but fails in ksh shell.
please suggest on this. (12 Replies)
Hi,
I have a requirement where I am getting date in string format (20161130). I need to add 20 days(not no. 20) to the above string. The o/p should 20161220.
In case of 20170228, it should show 20170320.
Could you please help me with the command to achieve this.
Note: I am using AIX 7.1... (5 Replies)
Discussion started by: satyaatcgi
5 Replies
LEARN ABOUT DEBIAN
lchage
lchage(8) System Manager's Manual lchage(8)NAME
lchage - Display or change user password policy
SYNOPSIS
lchage [OPTION]... user
DESCRIPTION
Displays or allows changing password policy of user.
OPTIONS -d, --date=days
Set the date of last password change to days after Jan 1 1970.
-E, --expire=days
Set the account expiration date to days after Jan 1 1970. Set days to -1 to disable account expiration.
-i, --interactive
Ask all questions when connecting to the user database, even if default answers are set up in libuser configuration.
-I, --inactive=days
Disable the account after days after password expires (after the user user is required to change the password).
-l, --list
Only list current user's policy and make no changes.
-m, --mindays=days
Require at least days days between password changes. Set days to 0 to disable this checking.
-M, --maxdays=days
Require changing the password after days since last password change. Set days to 99999 to disable this checking.
-W, --warndays=days
Start warning the user days before password expires (before the user is required to change the password).
EXIT STATUS
The exit status is 0 on success, nonzero on error.
libuser Jan 12 2005 lchage(8)