wappler 6.6.2 php docker
i have a query that i want to add 2 hours to current time as we are in spain, server in uk.
i have this screenshot
this is the same without adding 2 hours
and here a screenshot of results, 1 was inserted with the dataadd and one wihtout
times are the same, short of a minute
any ideas? or another wappler bug?
thanks
Hi.
Date functions have worked fine for us.
Maybe something broke in v6 for you.
Try add a new "set value" step, and set the value as {{NOW}}. Then add another step with value as the dateAdd function binding.
Run the SA and see what is returned to debug where the issue might be.
hi, i updated to 6.7 to see if it fixed it, nope.
I have done the set value as NOW + 2 hours, and used the set value as the data for the insert query, see screenshot. results the same, still just get time without the 2 hours added, the odd thing though is this is my local machine, local database, the time when i added note on my computer is 12.12, but the note date inserted using Date+2 is 10.12
What do you see in the server action response for set value steps?
not sure how to look/quite what you mean, not sure how to turn on any debugger etc. i can inspect in browser will that show something?
It's all explained here:
yeah i have that on and i use inspector, but i dont see how that will show me the sc debug, i get no errors, everything works, my form submits, the sc runs, the data is entered, but the time is wrong by 2 hours depsite my set value etc etc, not sure how to show what sc is doing in the inspector? thanks
In the Network > XHR you will see your server action ... click response and check the results returned by the two set value steps.
Note that you need to enable Output for them to see their values.
thanks, i found the bug. the page had not saved to use the correct api, so was using an outdated version, i have some weird bug that sometimes things wont save, i have to edit undo, close, reopen, redo and sometimes it will save, i need to try to record that as something at times prevents page saves, but thats something else so this one is sorted thanks
