Show/Hide Expression using dates

[Davidk]

Re: Show/Hide Expression using dates

Ivan, I see exactly the same behaviour you're seeing. Basically, it's because adding 5 to a date object in a show/hide expression doesn't really mean too much. 5 what? Seconds, Minutes, Days, etc.

You're best to hand this off to a javascript function and then you can do some date object manipulation. Attached is a working UX. The show/hide expression is...

testDates(date1,date2)

The javascript function is...

function testDates(date1,date2){

	date1.setDate(date1.getDate() + 5);
	
	if(date1 < date2){
		return true;
	}	

}

The show/hide expression is just looking for a "true" result.

In the code, setDate() and getDate() work with the "day" of the date object. So... we're setting a new day value for date1... which is the current day + 5. In this context... we know we're working with a "day" value and so adding 5 makes sense and adds 5 days.

[GGandhi]

Re: Show/Hide Expression using dates

?date()
= {10/13/2015}

?date() + 5
= {10/18/2015}

this is from interactive window, it seems to work adding numbers to the date field.

[GGandhi]

Re: Show/Hide Expression using dates

http://screencast.com/t/DiQbnKyFFOr
here is new screencast with javascript comparison.
since client side is done in browser I wrote the javascript function to evaluate the difference.
you could also use david's method of setDate to the date value and compare.

[Davidk]

Re: Show/Hide Expression using dates

?date()
= {10/13/2015}

?date() + 5
= {10/18/2015}

this is from interactive window, it seems to work adding numbers to the date field.

You are working with XBasic at the server level. Alpha has allowed you to do this.

At the client-side we are not working with XBasic... we are working with javascript date objects... and adding 5 to a javascript date object gives you this...

"Thu Jan 01 2015 00:00:00 GMT-0500 (Eastern Standard Time)5"

You can't imply that adding a number to a date object in XBasic at the server level has anything to do with the client-side. The 2 are completely different.

[GGandhi]

Re: Show/Hide Expression using dates

okay see the next screencast in post #18, that is done via javascript.

[GGandhi]

Re: Show/Hide Expression using dates

and adding 5 to a javascript date object gives you this...
"Thu Jan 01 2015 00:00:00 GMT-0500 (Eastern Standard Time)5"

i understand that
but
take a look at the first screencast why it is working?
i think it is because date1 is a field alpha works with that and adds 5 days to it, not a date object. to avoid any issue i have provided that javascript function to properly check 5 days later.
i am not comfortable with getDate and setDate method for adding dates.

[Gustavo1478]

Re: Show/Hide Expression using dates

Thank you all for the great input.

Thanks David, the explanation about "adding 5 what" in post #16 makes sense.

Thanks gandhi, I adapted your solution to my ux and it seems to be working just as I wanted.