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 CENTOS

dm_date

DM_DATE(1)						User Contributed Perl Documentation						DM_DATE(1)

NAME

       dm_date - print out the system date and time

SYNOPSIS

       This performs the same operation as the unix 'date' command, but using the Date::Manip module.

	  dm_date [OPTION]... [+FORMAT]

DESCRIPTION

       This displays information about the current system time, or some other time. Options are:

       -h, --help
	   Print online help.

       -d STRING, --date=STRING
	   Display time described by STRING. STRING can be any string which can be parsed by Date::Manip.  Please refer to the Date::Manip::Date
	   documentation for details.

       -f DATEFILE, --file=DATEFILE
	   This reads each line in DATEFILE, and extracts a date from it and prints out the information.

	   Blank lines and lines starting with a pound (#) are ignored. Lines not containing a valid date are also ignored.

       -r FILE, --reference=FILE
	   Displays the last modification time of FILE.

       -R, --rfc-2822
	   Displayc the date and time in RFC 2822 format.

	   Example: Mon, 07 Aug 2006 12:34:56 -0600

       -u, --utc, --universal
	   Converts the date to UT (GMT) and prints out the information.

       Only one of -d, -f, or -r should be included. If more than one is included, the first one from the list (-d, -f, -r) is used and any other
       is ignored.

       The format string starts with a plus (+) and contains any of the format directives described in Date::Manip::Date.

KNOWN BUGS

       None known.

BUGS AND QUESTIONS

       Please refer to the Date::Manip::Problems documentation for information on submitting bug reports or questions to the author.

SEE ALSO

       Date::Manip::Date

LICENSE

       This script is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

AUTHOR

       Sullivan Beck (sbeck@cpan.org)

perl v5.16.3							    2014-06-09								DM_DATE(1)
All times are GMT -4. The time now is 06:43 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy