This topic is locked
[SOLVED]

 DateTime field edit?

12/1/2018 6:11:56 PM
PHPRunner General questions
A
AlphaBase author

How do you edit a date-time field? I see how you can display it, but the edit options are only date OR time it seems?

lefty 12/1/2018



How do you edit a date-time field? I see how you can display it, but the edit options are only date OR time it seems?


Edit as Date and then in AutoUpdate in edit field enter strftime("%Y-%m-%d %H:%M:%S") or click the box next to autoupdate ... , above see quick template select date/time for Now Time/Date. If not use date picker and use different settings for pages edit as readonly to keep value from add page . Then View as Datetime . If you want date seperate add a time field next to date field. Make sure depending on database type , you setup Date field correctly to display date and time.
Any other date time handling see this link

A
AlphaBase author 12/2/2018

Thanks for your response. Someone I know pointed out to me you just check the box - see image.