Technical Tip
Search
Share This
Who's online
Online users
Tag Cloud
Quick Poll
- 6 comments
- 4410
- Older polls
User login
Adding a Future Date to an UserApp Date Field
650
Problem
A Forum reader recently asked:
"I have question about how to add a future date to a date field. With IE it gives me the correct date for the datepicker field, but when the date value has been saved to eDirectory, it is shown like "Sun Oct 22 07:11:36 EET 1911". And with Firefox it shows an incorrect value in datepicker field - "11/27/-1753" - which cannot be saved in MM/DD/YYYY format."
And here are the responses from Rudy Duym and John DaSilva ...
Solution
Rudy Duym
You could try the following script inside a workflow form event. This will add 3 days to the current date, and it should work on all browsers :
var s = new Date().getTime();
s = s + 3 * 1000 * 24 * 60 * 60; // add 3 days to today and show that
form.setValues("hireddate", form.dateToString(new Date(s), true));
John DaSilva
To add 10 years, to the current date, try:
expirationdate.setFullYear(expirationdate.getFullYear()+10); form.setValues(targetfield2, form.dateToString(expirationdate));
In Designer, in the Expression builder, there are tooltips for most of the functions. Let the mouse button hover over the Functions/Methods and you will see a note that getYear and setYear are not recommended, because of Y2K. Man, it has been a while since I had to think about that :)
Related Articles
User Comments
GregorianCalendar can help
Submitted by rkalfane on 5 March 2008 - 10:25am.
Hello!
To manipulate dates like adding, substracting, rolling I would strongly suggest to use the standard GregorianCalendar Java class.
Have a look at the Java documentation here: http://java.sun.com/j2se/1.4.2/docs/api/java/util/GregorianCalendar.html.
I used that to add months to user end dates to automatically disable target accounts / delete accounts / send notififications.
For instance, I used the following either in the DAL, workflows or rules (sorry I don't remember if it is working in all three areas or only for rules):
function addMonths(aDateMillis,aInt)
{
var oCalendar = new GregorianCalendar();
oCalendar.setTimeInMillis(aDateMillis*1000);
oCalendar.add(oCalendar.MONTH,aInt);
return (oCalendar.getTimeInMillis()/1000);
}
I am sure you can find a lot of examples searching on Google Code... Used with the SimpleDateFormat class, you can display dates using the format you want...
Cheers,
Reza
1