Operations between dates

QuestionsOperations between dates
Eduardo asked 6 years ago

Hi, is it possible to get the difference between two dates? For example: i have two fields "plazo" and "fecha de pago", i need to show in another field the number of days between this two dates. is there a way to do that?

Thanks in advance.

3 Answers
Abu Ghufran answered 6 years ago

You can use on_data_display event, to process this calculation on php side.
Please refer demo:

You can also use JS event, Refer faqs: http://phpgrid.org/faqs
How to populate other column, based on previous columns?

Eduardo answered 6 years ago

Hi, Abu. Thanks for the help.
I bought premium version last year, but now i'm out of license time. So i don't have the latest build to see demosappearencecalc-column.php . Can i get latest build or i have to buy a new licese?

Abu Ghufran answered 6 years ago

I've emailed you the demo code.
You might need to update the path and dbconfig.

Your Answer

6 + 14 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.

How useful was this discussion?

Click on a star to rate it!

Average rating / 5. Vote count:

We are sorry that this post was not useful for you!

Let us improve this post!