We have entered the =NOW() function for date and time to automatically pull current date and time to our form. this doesn't appear to update every time the form is opened. Is this option to auto-populate date and time available?
simply use now() as opposed to =now()
I can't seem to get now() to work. It just shows "now()" in the field rather than the current time. I tried to publish it thinking it would work once I view it on my device but it was the same. I tried it using both date and time types. I also tried to use time() but that didn't work either. Am I missing something or doing something wrong?
I am experiencing similar issues with date, time and datetime.
For date, use today() as the default function.
For time, it should be now(), but as of today I am confirming it does not work .
Finally, I am unsure of time calculations and any success you have had subtracting time starts from time ends to calculate length of time.
Also, have you checked what is stored in the start and end metadata types?
Retrieving data ...