MapTip: how to add a datetime value

[Anonymous]

This is my current statement:
'Outage: ' + REASON + '\nCompletion Date: ' + CompletionDate

where CompletionDate has the date and time. What do I need to add to the statement to get it to work in the maptip? will it even work in MapGuide? Thanks

Shaun

[Anonymous]

I think you have to convert the CompletionDate
value to a string. If your database is Access, check out the Format() function
(e.g. Format([fieldname],"dddd"", ""mmm d yyyy")). This will return a string
with the date in the format you want. The example returns "Thursday, July 4
1996" from the date 7/4/1996.

I hope this helps

--Bill

--
William G Voigt    (415)
485-3366 voice
GIS Analyst   (415) 485-3334 fax
Dept Public
Works   111 Morphew St
City of San
Rafael      San Rafael, CA 94901

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"Farrell" <
href="mailto:sf5d@virginia.edu">sf5d@virginia.edu> wrote in message
href="news:f1a45de.-1@WebX.maYIadrTaRb">news:f1a45de.-1@WebX.maYIadrTaRb...

This
is my current statement:
'Outage: ' + REASON + '\nCompletion Date: ' +
CompletionDate

where CompletionDate has the date and time. What do I need to add to the
statement to get it to work in the maptip? will it even work in MapGuide?
Thanks

Shaun