How to subtract dates to calculate nights

[kev1n]

1000 * 60 * 60 *24 * 365.25 / 12

is the same as

2000 [ which is 24/12*1000 ] * 3600 * 365.25

[kev1n]

===USER==========

globeadmin

===PDO MESSAGE===

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE 1' at line 2

===SQL===========

SELECT
WHERE 1

===BACK TRACE====

/volume1/web/ISEA/nuform.php - line 350 (nuRunQuery)

/volume1/web/ISEA/nuform.php - line 331 (nuBrowseTotals)

/volume1/web/ISEA/nuapi.php - line 42 (nuGetFormObject)

Can it have a consequence?

Update nuBuilder (or just replace nuform.php https://github.com/steven-copley/nubuil ... nuform.php) and the error will be gone.

[joecocs]

Thank you for the answers,
I continue to optimize my management interface.

A question concerning the date format in the 'browse forms', I cannot change the format.

do you have an idea

[kev1n]

What date format are you trying to set?

[joecocs]

dd/mm/yyyy

[kev1n]

It's better to ask just one question per topic. Now your question is not related to the original topic "How to subtract dates to calculate nights".
It allows other people with a similar problem to find the answer more easily.

[faroinsua]

YESSSSSSSSSS !

Thank's

How do we make this symbol (")

on the other hand the result is not saved in the fields ???

Great, thank your very much It works, it calculates the nights.....so nice.
I still have the same problem than joecocs, that the calculated value is not saved, it just saves a zero. I also tried to download and substitute the nuform.php file, it didn´t help.
Should the calculated nights-field be a nunumber? Or only number, and which format should the column in mysql have, INT (3) ?
Thank you. Best regards.

[kev1n]

The important thing is to call change() after setting a value.

Code: Select all

$('#your_field').val("xxx").change();

INT (3) should work and also nuNumber / Number.

[faroinsua]

Sorry, where do I insert that $('#your_field').val("xxx").change(); code?

[kev1n]

Sorry, where do I insert that $('#your_field').val("xxx").change(); code?

Just read through this topic, starting here:
https://forums.nubuilder.cloud/viewtopic. ... 251#p20421