MS Access Date DataType

Results 1 to 2 of 2

Thread: MS Access Date DataType

  1. #1
    Join Date
    Dec 1969

    Default MS Access Date DataType

    hihi, is it possible to concatenate to date field together? I have two date field in my table, start_date and end_date, how is it possible that I can combine this two fields and display something like:<BR><BR>start_date - end_date<BR><BR>I use "Select start_Date + &#039; - &#039; + end_Date from tbl"<BR>but it doesn&#039;t work, please help....

  2. #2
    Join Date
    Dec 1969

    Default cstr(StartDate) & " " & cstr(EndDate)

    should do it. cstr is the general allpurpose translation from whatever to string.<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts