Is it possible to format a Date/Time field to separate Date and Time Fields on Import

[jpvonhemel]

I can run the format function wherever I use my Date/Time field, but I can see a benefit in splitting it to date and time fields on import. Is the possible?

Thanks



Jerold

[kd2017]

You can just split them in a query easy enough. But why would you store them separately?

[orange]

Jerold,

As KD asked, can you give us a little more info re the Business involved and why there is a requirement for separate Date and Time.

[jpvonhemel]

I split them out in reports and thought it was easier to deal with them one time time on import vs using format() everywhere I need a date. Sounds like it is not possible to split them out on import.

Thanks,

Jerold

[JSR]

Not on import. But you can run an update query after import to populate two fields, date only and time only.

[CJ_London]

depends how you are importing - if you are linking to a source file and using a query to append to your table, you can do it in the query. However I agree with others, what is the benefit? You can still display the separate components in a report. By splitting you are doubling up on the fields required, made indexing (if used) larger and more complex, potentially made criteria and sorting more difficult to implement