Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2010
    Posts
    41

    Unanswered: detedif function

    i have a form which a date - i want to calculate the number of months from that date (a future date) up until the current date...

    so i have 12/06/2010 in a certain field on my form, i have created another textbox control which i want to tell me how many months from that date to now - so it should say 2 months...

    i have tried this

    =DATEDIF([FutureDate],[Now],"m")

    but it doesnt work....

    does the stuff in the square brackets mean label name? so i just enter the label name in there?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    daetdiff can take any valid expressions as parameters, that measn variables, control.values or columns usually the [] is used to encapsualte a column where a space has been usied in the na\me of the column

    mind you I'm not surprised it didn't work, the help manual and autosense should have helped you
    what you are lookign for is something similar to
    avariable = datediff("m",adatevalue,anotherdatevalue)
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Mar 2010
    Posts
    41
    Thanks heakdem - ive managed to get it to work with your help...cheers!

Posting Permissions

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