Skip to main content

Lookup of a Date/Time field shows only Date (need time as well)

  • December 10, 2017
  • 2 replies
  • 12 views

Hi all - first post, be nice to the noob please!

I have created a date/time field in one table and want to use a lookup to display it in another table. I created the lookup just fine, but the resulting field shows only the date. I need it to display the time from the looked up record as well.

What did I miss?

Thanks!

This topic has been closed for replies.

2 replies

Forum|alt.badge.img+5
  • Inspiring
  • December 10, 2017

Check the formatting of your field: Right-click on the field, select ‘Customize field type,’ select ‘Formatting.’ Make sure ‘Include a time field’ is toggled on. :slightly_smiling_face:


  • Author
  • New Participant
  • December 10, 2017

Huh - that seems to have been the setting by default, so I flipped the toggle off and then back on, now it’s good.

Thanks!