Time from Seconds

[CharlesParker]

Re: Time from Seconds

without testing it - would that just create a NEW Date based on the current datetime? Or does new Date(t1) simply format/convert an existing record as Date?
Also what would happen if there is no value? do i need to write an if statement to run t1 if the startdatetime is <> ' ' ?
seems like I would only create var t1 if there is a value already - right?

I think I am getting it, just cannot test right now.

[GGandhi]

Re: Time from Seconds

new Date()
Will create current date time in readable format
new Date(string or seconds) will create based on that value
Read JavaScript date reference you will see

[GGandhi]

Re: Time from Seconds

If date is empty you supply what is correct one instead

[CharlesParker]

Re: Time from Seconds

Ok so I am posting my code as per your instructions with an additional line .toformat
which should for all intents and purposes do exactly what you're saying. In effect I am setting teh existing date from the getValue to a date format.
In theory this SHOULD work, and I see what your getting at.

The problem is that, I am still getting a NAN...and it is the start time doing it. If I click button one, the calculation runs as expected.
here is my code with what I thought was your suggestion...

d1 = new Date();
d1 = d1.toFormat('MM/dd/yyyy 0h:0m:0s am');
{grid.Object}.setValue('D','HOURS_STOP',d1);
stime = {grid.Object}.getValue('D','HOURS_START');
etim = {grid.Object}.getValue('D','HOURS_STOP');
payr = {grid.Object}.getValue('D','PAYRATE');
stimenew = new Date(stime);
stimenew = stimenew.toFormat('MM/dd/yyyy 0h:0m:0s am');
nt1 = new Date(stimenew);
nt2 = new Date(etim);
timdif = nt2.getTime() - nt1.getTime();
secs = timdif/1000;
mins = secs/60;

//gandhi addition to your code
var h = Math.floor(secs/3600);
if (h < 10) {
h = "0"+h;
}
var m = Math.floor((secs%3600)/60);
if (m < 10 ) {
m = "0"+m;
}
var s = secs%60;
if (s < 10 ) {
s = "0" + s;
}
var cpm = payr/60;
var totalc = cpm*mins;
var rounded = "$"+totalc.toFixed(2);


elapsedtime = h + ":" + m + ":" + s;
{grid.Object}.setValue('D','minutes',m);
{grid.Object}.setValue('D','seconds',secs);
{grid.Object}.setValue('D','HOURS_TOTAL',elapsedtime);
{grid.Object}.setValue('D','GROSSPAY',rounded);

[CharlesParker]

Re: Time from Seconds

You know 2 years of working with alpha and I can't add and subtract time even with guidance - jeez sometimes it's just painful!
shouldn't nt1 and nt2
have already rendered this to your suggestion?

[CharlesParker]

Re: Time from Seconds

Looking at what is getting saved to the database I see this for the start time.
2016-02-11 22:27:03
This is whats displayed in my component in alpha
02/11/2016 10:27:03 00 pm

Also I notice that if I copy the value in the field of an existing record and then paste it directly back in I just get: 02/11/201


This is different than what is displayed...will that matter?

[CharlesParker]

Re: Time from Seconds

After extensive testing, I found that this code works as expected:

d1 = new Date();
d1 = d1.toFormat('MM/dd/yyyy 0h:0m:0s am');
{grid.Object}.setValue('D','HOURS_STOP',d1);

stime = {grid.Object}.getValue('D','HOURS_START');
etim = {grid.Object}.getValue('D','HOURS_STOP');
payr = {grid.Object}.getValue('D','PAYRATE');
newstime = new Date(stime);
newstime= newstime.toFormat('MM/dd/yyyy 0h:0m:0s am');
nt1 = new Date(newstime);
nt2 = new Date(etim);
timdif = nt2.getTime() - nt1.getTime();
secs = timdif/1000;
mins = secs/60;

//gandhi addition to your code
var h = Math.floor(secs/3600);
if (h < 10) {
h = "0"+h;
}
var m = Math.floor((secs%3600)/60);
if (m < 10 ) {
m = "0"+m;
}
var s = secs%60;
if (s < 10 ) {
s = "0" + s;
}
var cpm = payr/60;
var totalc = cpm*mins;
var rounded = "$"+totalc.toFixed(2);


elapsedtime = h + ":" + m + ":" + s;
{grid.Object}.setValue('D','minutes',m);
{grid.Object}.setValue('D','seconds',secs);
{grid.Object}.setValue('D','HOURS_TOTAL',elapsedtime);
{grid.Object}.setValue('D','GROSSPAY',rounded);

The problem stemmed from the "display format" as it seems that if you pick
time("{grid.clientSideDateFormat} 0h:0m am",<value>)
then it all works as expected, otherwise you will see the seconds appear in the endtime field which as it turns out are different than the starttime that is stored.
If I chose nothing OR
time("{grid.clientSideDateFormat} 0h:0m 0s am",<value>) then it fails - this sucks because you would think I were calculating the seconds - and in fact we are...also not choosing a display format results in a fail too!

Anyways, the final result is this works and gghandi your code suggestions helped me - ---- but I needed to define the "displayed format" for each field as stated.
To me this makes no sense as a "displayed format" to me means it's actually something else - you're just seeing it displayed how you want it...as it turns out it is important in another way...one I do not understand but managed to get it working!