SORRY, IT APPEARS TO BE WORKING NOW IF I CAN GET THE RIGHT TIME ZONE. (Red in the face)
PHPRunner 5.3 Microsoft Access database.
I have a field in my table called DateTime.
On the edit screen I right click the field, select properties, and set the 'veiw as' tab properties to DateTime.
On the 'Edit as' tab, there is NO datetime option, only Date or Time so I tried both.
I set the properties default value to now() because I want to store both the Date and Time.
I can only figure out how to get the date or the time but not both. If I set the 'edit as' to Date, it always sets the time to 12:00 and if I set it to time, it does not return the date.
I am using Microsoft access for this project. It is strange that you can display both but you can not set it to get both, only date or time. At least that's my experience.
I hope someone can give me a simple solution or at least detailed instructions because I am not an advanced user yet. I found one answer on a prior version of PHPRunner that said to edit a file in 'program files/phprunner/source/include/function.php'. I thought great! but that function appears not to be in version 5.3 and I think it was supposed to be fixed in this version?
Just a mention but I think it would be really helpful if when answering questions, advanced users consider that us beginners will be having the same problems as your advanced users and give detailed answers. That way we can simply apply the solutions already given.
That said, I do appreciate that you are willing to help us. I would search for days for the answers otherwise.
Thank you great masters of the PHPrunner. Some day I'll grow up to be like you.