I am attempting to trim a TimeStamp or DateStamp field that is stored in a DB2 Table in Microsoft Access. I have tried various trim methods RTrim etc without success.

Please Help.
posted by:
SABRINA
offline SABRINA
Atlanta
0 friends
join to post
  • Dave
    Dave
    offline 2

    Re: Trimming A DateStamp Field in a DB2 Table

    Sun, April 20, 2008 - 7:21 PM
    With datetime fields you don't "trim" you format. You can use format to obtain whatever portion of the date/time you are interested in. There is a format function that you can use format(<value>,<format string>) you can look up for usage. In the case of a form or report, just use the format property of the text box in question.

    HTH,
    Dave
    join to post

Recent topics in "MS Access Database Gurus"

Topic Author Replies Last Post
BeforeUpdate event doesn't update after changing in form taco 0 March 30, 2008
Photos in Form Via Web Browser Control Extalios 1 January 23, 2008
Average across fields Cristi 4 September 13, 2007
Before_Update Event Procedure Reagan 6 August 24, 2007
Lock Text Box in a Form once data Entered Fintan 1 June 4, 2007