Ask Your Question

Can I eliminate the Time component of the Date/Time field in Base? [closed]

asked 2013-10-02 15:00:07 +0100

iraheartdr gravatar image

I require two date-related fields in my database: date a test was done and patient's date of birth. However, there is a time field as well. How do I eliminate this?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-10 10:15:36.525705

1 Answer

Sort by » oldest newest most voted

answered 2013-10-03 00:08:58 +0100

JohnD gravatar image

Not sure that I fully understand your query, but there are three possible selections for the Field Type in the embedded HSQL database - Date, Time and Date/Time (timestamp).

For just a date select the Date type and then in the format example select the "..." box to set the format you desire.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-10-02 15:00:07 +0100

Seen: 98 times

Last updated: Oct 03 '13