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


#1

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!


#2

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. :slight_smile:


#3

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!