Date Calculation.

[Dspguards]

Hi Guys,
I think this should be a simply question but never the less has me stumped.
I have two fields. "Ws_provided" is a date field and "EXP" also a date field.
I need a way of calculating the EXP field as being "Ws_provided" + 21 days.
I thought a calculated field expression of ws_provided +21 would work but I just get the date with 21 after it. eg 12/12/201421

Any help would be great.
Roland

[lvasic]

Re: Date Calculation.

Is the calculation in JavaScript or Xbasic?

[Davidk]

Re: Date Calculation.

This must be javascript because in XBasic this works...

dim mydate as d
dim mynewdate as d
mydate = {04/05/2014}
mynewdate = mydate + 1
?mynewdate
= {04/06/2014}

There is an XBasic function named add_bus_days() as well.

We know it's Javascript because the Calculated field expression is Client-side and so Javascript.

For Javascript... (iow... why do I have to deal with dates again!!! Why are dates so horrible to work with!!!)

This will give you complete control over the date.

var myDate = new Date({dialog.Object}.getValue('myDate'));
myDate.setDate(myDate.getDate()+21); 

var curr_day = ('0' + myDate.getDate()).slice(-2);
var curr_month = ('0' + (myDate.getMonth()+1)).slice(-2); //Months are zero based
var curr_year = myDate.getFullYear();

var newDate = curr_month + '/' + curr_day + '/' + curr_year;

{dialog.Object}.setValue('myNewDate', newDate);

Go and get the date you want to work with
Add your number of days to it
Now get the day, month, year of your new date so that you can "output" it correctly
Remember that month is zero based (yikes)
Remember that the day never contains the leading zero (yikes again)
Now put it together in the format you want and write it out.

You can use this in the Calculated field expression by putting the js code into a function and putting the function name into the Calculated field expression. There's help in the property for doing this. You can pass data to the function or just continue to use getValue.

The other option is to use something like moment.js at momentjs.com

It's brilliant. It's what should be build into Javascript.

[NormanRMouton]

Re: Date Calculation.

David

I tried your javascript code cannot make it work.

Kind Regards

Norman

[TheSmitchell]

Re: Date Calculation.

This must be javascript because in XBasic this works...

dim mydate as d
dim mynewdate as d
mydate = {04/05/2014}
mynewdate = mydate + 1
?mynewdate
= {04/06/2014}

There is an XBasic function named add_bus_days() as well.

We know it's Javascript because the Calculated field expression is Client-side and so Javascript.

For Javascript... (iow... why do I have to deal with dates again!!! Why are dates so horrible to work with!!!)

This will give you complete control over the date.

var myDate = new Date({dialog.Object}.getValue('myDate'));
myDate.setDate(myDate.getDate()+21); 

var curr_day = ('0' + myDate.getDate()).slice(-2);
var curr_month = ('0' + (myDate.getMonth()+1)).slice(-2); //Months are zero based
var curr_year = myDate.getFullYear();

var newDate = curr_month + '/' + curr_day + '/' + curr_year;

{dialog.Object}.setValue('myNewDate', newDate);

Go and get the date you want to work with
Add your number of days to it
Now get the day, month, year of your new date so that you can "output" it correctly
Remember that month is zero based (yikes)
Remember that the day never contains the leading zero (yikes again)
Now put it together in the format you want and write it out.

You can use this in the Calculated field expression by putting the js code into a function and putting the function name into the Calculated field expression. There's help in the property for doing this. You can pass data to the function or just continue to use getValue.

The other option is to use something like moment.js at momentjs.com

It's brilliant. It's what should be build into Javascript.

You can avoid manual parsing with the toFormat() method Alpha added to the Date object:

var myDate = new Date({dialog.Object}.getValue('myDate'));
myDate.setDate(myDate.getDate()+21); 

var newDate = myDate.toFormat("MM/dd/yyyy");

{dialog.Object}.setValue('myNewDate', newDate);

David

I tried your javascript code cannot make it work.

Kind Regards

Norman

What was your code? Can you copy it here? Where did you place it?

[TheSmitchell]

Re: Date Calculation.

If you're using the calculated field expression property, here's an example:

I created a function, calcDate, as follows:

var calcDate = function (d) {
	if (typeof(d) !== 'string') {
		d.setDate(d.getDate()+21);
		return d.toFormat("MM/dd/yyyy");
	} else {
		return "";
	}
}

In my field that will be calculated (myNewDate), I put this in the calculated field definition:

calcDate(myDate)

myDate is a textbox with the type "Date". It will be passed to the calcDate function in my calculated field definition as a date object. If myDate has no value, the value passed to the calcDate function will be a string --- this is why I have the typeof check in my if statement for calcDate.

The attached example was built using the pre-release, so I've included screenshots in the zip below.

calcDate.zip

[NormanRMouton]

Re: Date Calculation.

Sarah

Thank you very much. Got it worked.

Alpha Five forum is tops