On Click Time Now

[hallidayo]

Hi,

I want a on click event that fires the current time in a particular field in the detail view. This is the code that I am currently using:

Inline Java: {grid.Object}.setValue('D','ACTUALSTART','=TIME()')

Whenever I click the button it displays '=TIME()'. How do I change it so it displays the actual time?

[PhilM]

Re: On Click Time Now

Hi

Off the top of my head and not tested :

=TIME() isn't valid JavaScript.

Try to replace '=TIME()' with something a JavaScript variable primed to the time you want.

Some browsers support

var currTime = new Date().now;

Older ones might prefer

var currTime = new Date().getTime();

So, something along the lines of

currTime = new Date().now
{grid.Object}.setValue('D','ACTUALSTART',currTime);

Hope that helps, or at least gets you closer.

Phil

[GGandhi]

Re: On Click Time Now

for 24 hour clock:

var currentTime = new Date();
var hours = currentTime.getHours();
var minutes = currentTime.getMinutes();
var AMPM = hours>=12 ?'PM': 'AM';
var fullTime = hours+":"+minutes+" "+AMPM;
{grid.Object}.setValue('D','TIME',fullTime);

for 12 hour clock:

var currentTime = new Date();
var hours = currentTime.getHours();
var minutes = currentTime.getMinutes();
var AMPM = hours>=12 ?'PM': 'AM';
hours = hours % 12;
hours = hours ? hours: 12;
var fullTime = hours+":"+minutes+" "+AMPM;
{grid.Object}.setValue('D','TIME',fullTime);

try this code.

[CharlesParker]

Re: On Click Time Now

Any advice for DATE logic ghandhi? I want a calculated field to reflect a 1 month forward value from a known date:

So field1 = (for ex.) 02/05/2014
I want field2 to = 03/05/2014
I can't figure out how this would work from December to January or any calculation including February since its 28 days.
been working on this on my own for 2 days with no luck
This is in a UX btw

[-Jinx-]

Re: On Click Time Now

I "THINK" this would work with Javascript:

var today = new Date();
var dd = today.getDate();

//The following +1 would give you the date today.  I think the +2 will give you next months date 
var mm = today.getMonth()+2;

var yyyy = today.getFullYear();

if(dd<10){dd='0'+dd} if(mm<10){mm='0'+mm} today = mm+'/'+dd+'/'+yyyy;

alert(today);

[CharlesParker]

Re: On Click Time Now

that does indeed work, so I guess I need to switch the var today to be the value in field1 and see what happens. This is a great code snippet!

[CharlesParker]

Re: On Click Time Now

oddly though I cant figure out how to set the var "today"
equal to
{dialog.object}.getvalue(field1) ...you know what I mean
I tried setvalue as well
and an arg but still being a greenhorn I am leaving out something important of course.

[GGandhi]

Re: On Click Time Now

if you create a xbasic function addMonth
and place it on the onChange event of the first date field
with this code the second date will be a month away.
the method {dilog.object}.getValue(name) gives you just a date and all javascript functions on it does not seem to work well.
so here is my xbasic version

dim d1 as d
	dim d2 as d
	d1 = e.dataSubmitted.date
	d2 = addMonths(d1,1)
	e._set.date2.value = d2

it needs a server call, i don't think server will complain, too many calls.

by the way you can do this easily when you submit the data and set it in the database backend, the user need not know about the date unless you have a reason.