Splitting Field

M

MAHAAS

In a query, can I split the data in one field into two? For example, I have
a timeDate field (format m/d/yyyy h:nn) and I would like to extract just the
time.
 
M

MGFoster

MAHAAS said:
In a query, can I split the data in one field into two? For example, I have
a timeDate field (format m/d/yyyy h:nn) and I would like to extract just the
time.
Click to expand...

Yes. Use TimeValue() function to get just the time.
 
Top