Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

siebel escript to compare two dates

Posted on 2007-11-14
2
Medium Priority
?
16,073 Views
Last Modified: 2010-10-05
My Requirement is to write a escript to compare the dates.whiich I am getting from the following sources

1st Date : order date from order BC in MM/DD/YYYY format
2nd date : 14 days before date from current date.. DD/MM/YYYY

After capturing the aboce two dates i need to write a escript in siebel to compare the dates to find which date is larger..

I have tried a sample code ..for  the 2nd date mentioned above.

var DateObject = new Date();
      var DateObject1 = new Date(DateObject - 1209600000);
      var datebefore=DateObject1.getMonth()+"/"+DateObject1.getDate() +"/"+DateObject1.getFullYear()+" "+DateObject1.getHours()+":"+DateObject1.getMinutes()+":"+DateObject1.getSeconds();

Can anybody correct  me or share the code for the aboce requirement.

Thanks a lot.


0
Comment
Question by:toharikr
  • 2
2 Comments
 
LVL 1

Accepted Solution

by:
linmm earned 1500 total points
ID: 20291305
Which is the recognized date format on your server?  Assuming that it is the same as the first date (MM/DD/YYYY), you should first modify the second date string to be in the format of the first date string.  You can do this by using the string.replace function to swap the DD and MM characters.

After that, the date strings can be easily compared by using the date.parse static function, which takes a date string, and returns the number of milliseconds to that date since the epoch (midnight GMT 01/01/1970).

Should only be about 2-4 lines of script.  One to modify the date string, and 1-3 to compare the dates, depending on how you write it.  I've attached a snippet that should speak for itself.
	// sDate1, string representation of date in format MM/DD/YYYY
	// sDate2, string representation of date in format DD/MM/YYYY
	
	// assuming the native format on the server is MM/DD/YYYY
	// change the format of sDate2 to match sDate1 by swapping the DD and MM
	// string.replace can change DD/MM/YYYY to MM/DD/YYYY using a regex
	sDate2 = sDate2.replace (/\d{2}\/\d{2}\/\d{4}/, "$2/$1/$3");
	
	// compare the date values by parse each string with escript date.parse
	if (Date.parse (sDate1) > Date.parse (sDate2))
	{
		// the first date is greater
	}
	else if (Date.parse (sDate2) > Date.parse (sDate1))
	{
		// the second date is greater
	}
	else // Date.parse (sDate1) == Date.parse (sDate2)
	{
		// the first and second dates are the same
	}

Open in new window

0
 
LVL 1

Expert Comment

by:linmm
ID: 20291468
Had a little trouble understanding what you need exactly.  If you also need a quick way to get the date 14 days before today, here's a quick snippet for that.  I'm assuming that you do not want to look at times - just the dates.  If you want to be sensitive to the time of the day, leave out the last line which sets the time to midnight.

The only caveat is that since this is done using eScript (server script), it will use the date and time on the server, which may not be the same as the date and time that your order buscomp is returning.  The Order Date on the Order Entry - Orders business component returns a date and time in the time zone of the currently logged in user.

If you use a date object to compare the dates instead of a date string, you would get the number of milliseconds since the epoch using the date.getTime method (dt.getTime ()), instead of the date.parse method (Date.parse (sDate2)).

Hope this helps,
Mike

var dt = new Date (); // get the current date
dt.setTime (dt.getTime - 14 * 24 * 60 * 60 * 1000); // subtract 14 days
 
// dt is now exactly 14 days before the current time
 
dt.setHours (0, 0, 0, 0); // set the time to midnight on that day

Open in new window

0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question