Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: Concatenating problem with date


    I need to pass a date, login and password to a webservice. The date will always be the current date but must be in the format ddmmyyyy.

    I have the following

    Dim strCurrentDate

    strCurrentDate = format(now,'ddmmyyyy')

    which gives me the correct value.

    However when I try and concatenate it with the login and password, it gives me the literal value i.e strCurrentDate

    I have something similar to the following:
    datatosend = "strLogin=" &'test_user' "strPassword=" &"password" & strCurrentDate

    I may have got the syntax wrong here. I do not have the program installed on this machine.

    What I get returned is
    strLogin=test_user &strPassword=password&strCurrentDate <----- I do not get the date data returned.

    I hope I have explained the problem well, to receive some answers.

    Kind Regards

  2. #2
    Join Date
    Oct 2003

    Thumbs up

    Try this
    datatosend = "strLogin=" &'test_user' "strPassword=" &"password" & val(strCurrentDate)
    Last edited by Madhivanan; 11-10-04 at 01:29.

Posting Permissions

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