Forum Discussion

RobinCC's avatar
RobinCC
Qrew Cadet
7 years ago

URL button to update a Date/Time field always shows the time as 12:00 AM

I have a URL button that when pressed takes the value in Time/Date Field #1 and inserts the value into Time/Date Field #2, however, the time portion of Field #2 always shows as 12:00 AM and not the ti...
APIs and custom code
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Try URL encoding the date time field

URLRoot() & "db/" & [_DBID_LOGS] & "?a=API_EditRecord"& "&rid="& [Max Record ID# Current User]
& "&_fid_7=" & URLEncode([Max Date Modified Current User] )
& "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_TASKS] & "?a=q&qid=20