Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Date Validation not working
Top Forums UNIX for Dummies Questions & Answers Date Validation not working Post 302904201 by senthil.ak on Monday 2nd of June 2014 07:29:52 PM
Old 06-02-2014
Date Validation not working
Hi Experts,

I have a date validation script in that i will validate the date for a given format and search in the logs for that date. The script logic is very simple like below.


Code:
Validate_Date()
{
is_valid=1
while [ $is_valid -ne 0 ]
do
 date_format=$(date "+$1")
 echo -e "Please enter the $2 date like - \033[0;32m$date_format\033[0;37m"
 read MY_DATE
 tmp=$(date "+$1" -d "$MY_DATE" 2>&1)
 if [ "${tmp:6:7}" == "invalid" ]; then
  is_valid=1
  echo -e "Invalid date $tmp"
 else
  MY_DATE=$tmp
  is_valid=0
 fi
done
}


This is working fine for almost all date format expect the below one

Code:
%d/%m/%Y

Whenever I pass some inputs which is valid its throwing error

Code:
$Validate_Date "%d/%m/%Y"
Please enter the  date like - 02/06/2014
25/05/2014
Invalid date date: invalid date `25/05/2014'
Please enter the  date like - 02/06/2014

The reason is server is always taking MMDDYYYY indeed of DDMMYYYY.

Code:
$date -d "30/06/2014" "+%d/%m/%Y"
date: invalid date `30/06/2014'
$date -d "25/05/2014" "+%d/%m/%Y"
date: invalid date `25/05/2014'


How to resolve this.

Thanks
Senthil
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Date Validation again

I want a sample Date validation script using if loops. The script should first compare "year".If the year is lesser than the current year,It should go for "month" checking. I have the script that splits the date into year,month and date.I want only the checking part. My if loop checking is not... (4 Replies)
Discussion started by: dave_nithis
4 Replies

2. Shell Programming and Scripting

Date Validation:

Hi I have below file with 3 rd column as date ....i want to make 3 column to mm/dd/yyyy . in the below file 2 row date is like 1/23/1994 so i want to append '0' to month i,e. 01/23/1994 and in the 3 row date is like 6/4/1994 ---so i want this to 06/04/1994 Source:... (1 Reply)
Discussion started by: satyam_sat
1 Replies

3. Shell Programming and Scripting

Basic date validation help

Hi, I've made a very basic date validation script, but the syntax of the until condtion is wrong, could someone have a quick look and correct it please?:) Thanks for any help. echo -n "Please enter your date of birth (dd-mm-yyyy): " read dob day=${dob:0:2} month=${dob:3:2} year=${dob:6:4}... (1 Reply)
Discussion started by: mustaine85
1 Replies

4. Shell Programming and Scripting

Date Validation

the user have to input the date format in mmddmmhhyyyy (month,date,minutes,hour,year) i want a shell script to check whether the user has properly input in the above said manner. kindly advice (2 Replies)
Discussion started by: vkca
2 Replies

5. Shell Programming and Scripting

Date Validation in unix

I have a script which is take date as parameter sh abc.sh <2010-02-01> #!/sh/bin my_date=$1 #Here i want to two diffrent dates ## 3 Days before ##date14query=$mydate - 4 (it will be 2010-01-28) ##date24query=$mydate +4 (it will be 2010-01-05) #Please Help (3 Replies)
Discussion started by: pritish.sas
3 Replies

6. Shell Programming and Scripting

Date validation

Hi, I have a script which runs on specific sunday. If that script runs on the sunday i want to execute another script on following wednesday. I have a log for that server. My wednesday scripts needs to check the sunday run log timestamp and if it matches it should run. Please help. Thanks,... (1 Reply)
Discussion started by: Krrishv
1 Replies

7. UNIX for Dummies Questions & Answers

Unix date validation

Dears, I am working on a batch that processes file with name containing date prefix eg., 20101222_file.dat. The logic is to process files in order. Eg., 20101225 must be processed only after 20101222. Ok first glance it looked simple, it use a variable to check this date value as number and... (2 Replies)
Discussion started by: naraink
2 Replies

8. Shell Programming and Scripting

Date validation

File contains below data,how to validate the date using awk command or any command. date formate is fixed as "YYYYMMDD" test1|20120405 test2|20121405 output should be: test1|20120405 Thanks (2 Replies)
Discussion started by: bmk
2 Replies

9. Programming

Date validation in mysql

Hi All, We need to create the custom function to pass the parameter is date.if it is valid return 1 else 0 return should be 1 select is_date('2012-09-17'); return should be 0 select is_date('2012-79-17'); Thanks (2 Replies)
Discussion started by: bmk
2 Replies

10. What is on Your Mind?

Date validation

Hi folks, I new to shell script . I want to know how to validate a String as valid date example: 20150712 ---> valid date 20160524-->valid 201605T12-->invalid date 12341234--->invalid date we need to valid string( yyyymmdd) to date in SunOS 5.10 please give some idea to validate... (9 Replies)
Discussion started by: srinadhreddy27
9 Replies

LEARN ABOUT DEBIAN

netsds::util::datetime

NetSDS::Util::DateTime(3pm)				User Contributed Perl Documentation			       NetSDS::Util::DateTime(3pm)

NAME

       NetSDS::Util::DateTime - common date/time processing routines

SYNOPSIS

	       use NetSDS::Util::DateTime;

	       print "Current date: " . date_now();

DESCRIPTION

       This package provides set of routines for date and time processing.

EXPORTED FUNCTIONS

       date_now_array([TIME])
	   Returns array of date items for given date.	If source date is not set current date used.

       date_now([TIME])
	   Return [given] date as string.

	       2001-12-23 14:39:53

       date_now_iso8601([TIME])
	   Return date as ISO 8601 string.

	       20011223T14:39:53Z

	   <http://en.wikipedia.org/wiki/ISO_8601> http://www.w3.org/TR/NOTE-datetime <http://www.w3.org/TR/NOTE-datetime>

       date_strip(DATE)
	   Trim miliseconds from date.

       date_date(DATE)
	   Trim time part from date.

       date_time(DATE)
	   Trim date part from date.

       time_from_string($string)
	   Return parsed date/time structure.

       date_from_string($string)
	   Return date from string representation.

       date_inc([INCREMENT, [TIME]])
	   Return date incremented with given number of seconds.

       date_inc_string([INCREMENT, [TIME]])
	   Return string representation of date incremented with given number of seconds.

EXAMPLES

       None yet

BUGS

       Unknown yet

SEE ALSO

       Date::Parse, Date::Format

TODO

       Import stuff from Wono project

AUTHOR

       Valentyn Solomko <val@pere.org.ua>

       Michael Bochkaryov <misha@rattler.kiev.ua>

perl v5.12.4							    2011-08-27					       NetSDS::Util::DateTime(3pm)
All times are GMT -4. The time now is 02:43 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy