Timestamp

[cmack]

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.

[Lee Smith]

Have you tried, GetAsDate ( YourField )?

[cmack]

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, 2008 by Guest

[cmack]

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, 2009 by Guest