asked on

siebel escript to compare two dates

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.

ASKER CERTIFIED SOLUTION

linmm

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

linmm

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