Convert date to int

[mgonzalez...@gmail.com]

Hello
Could someone help me convert the result of a sum of two dates to integer?

Thaks.
Marcos Glez

[Pankaj Kumar]

Hi Marcos,

As per the screenshot you attached, you are able to sum two date to integer. Could you explain more where you are getting the problem.

Also the sum you are getting ie "2830464000" is the sum of the total time in seconds (not milliseconds) of two date that are in the array column. 

Thanks & Regards,

Pankaj Kumar

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/58d222c0-1dc6-41a8-9ee0-47bea8298a4a%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[mgonzalez...@gmail.com]

Hi pkumar

The screens show the result of the addition of dates is "2830464000" but I need to display the result "1" day and not the number in seconds "2830464000"

Thanks

[mgonzalez...@gmail.com]

On Wednesday, November 5, 2014 6:01:47 PM UTC-6, mgonzalez...@gmail.com wrote:

Thaks It's works perfectly

Regards
Marcos!!!

[Fabien Tabary]

Hi,

The numeric output of our date widget is a timestamp (the Timestamp is the number of seconds elapsed since the 1st January 1970). If you want to compare two dates and get back the number of days, you just have to do a simply calculation:

I have two dates, end_date and start_date. In order to get a positive number, I subtract the start_date to the end_date. Finally I divide the final number per 24 (for the nb of hours in a day), per 60 (same thing for the minutes) and per 60 (same thing for the seconds).

Best regards / Cordialement

--

Fabien Tabary

PreSales Consultant

Contact: fta...@runmyprocess.com

Tel: +33(0) 175 775 178

Website: Fujitsu RunMyProcess

     

Fujitsu RunMyProcess user? Please add a review on GoogleApps Marketplace

Afin de contribuer au respect de l'environnement, merci de n'imprimer ce message qu'en cas de nécessité.
Be environmentally friendly: do not print this email unless it is entirely necessary.

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/327cc49b-a1e6-4c18-9d7a-4971cde70d3b%40runmyprocess.com.