I have an excel file that I import into my database It contains a timestamp as one of the fields. I only need the date portion of timestamp and not the time.

I would like to run a script or maybe just make it it a calculation field to remove the time portion.

Here is how it is formatted:

9/12/2007 12:17:12 PM

I only need the date.

I know there is probably a simple way to get rid of time but calculations and I seem to disagree alot.

Thanks for any help.

Have you tried, GetAsDate ( YourField )?

Okay I feel like an idiot that was beyond easy. For whatever reason I did not think it would work with that.

Thanks so much for your time.

Edited February 29, 200817 yr by Guest

The timestamp in my data base has changed format in the original import file. Now the

GetAsDate ( Timestamp )

no longer works.

The format is now

2009-01-21 12:11:04

[color:red]Disregard this post it is a problem with the import.

I am not sure how to fix this so it gives me the date again.

Any help would be greatly appreciated!!

Edited April 15, 200916 yr by Guest