Solved

siebel escript to compare two dates

Posted on 2007-11-14
2
14,368 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 500 total points
Comment Utility
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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I guess that all of us know that caching the data usually increase the performance, but I worried if all of us are aware about the risk that caching the data provides and how to minimize this.  That’s the reason why I decided to write this short art…
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

763 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now