Removing leading characters from word field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter Wilde - 03 May 2004 10:54 GMT

I'm creating a mail merge using data extracted from a
DBISAM database. One field in the database is a TimeStamp
which returns the date and time as follows '30/12/2003
9:30:00 AM' In my mail merge letter I need to include the
time only and would like to strip the date from the
beginning of the field. Microsoft SQL Query does not
allow me to use the substring command. Is there a solution

Reply to this Message

macropod - 03 May 2004 11:50 GMT

Hi Peter,

You can control this in Word by adding a date & time picture switch to your
mergefield. To do this, select the field and press Shift-F9. Your field
should look something like:
{MERGEFIELD TimeStamp}
Edit the field, by adding: \@ "hh:mm:ss" after the source data name, so that
the field looks like:
{MERGEFIELD TimeStamp \@ "hh:mm:ss"}

Alternatively, if TimeStamp can exceed 24 hours, change the picture switch
to \@ "HH:mm:ss"

Cheers

> I'm creating a mail merge using data extracted from a
> DBISAM database. One field in the database is a TimeStamp
[quoted text clipped - 3 lines]
> beginning of the field. Microsoft SQL Query does not
> allow me to use the substring command. Is there a solution

Reply to this Message

Peter Wilde - 04 May 2004 12:01 GMT

Dear Macropod,

You're a genius! I spent 2 hours trying to solve this
problem and you've given me the answer in 30 sec. Thanks.

Peter Wilde

>-----Original Message-----
>Hi Peter,
[quoted text clipped - 26 lines]
>
>.

Reply to this Message