exception between two dates / years

  • Resolved alexvds

    (@alexvds)


    7 years, 9 months ago

    Dear sir,

    Is it possible to make an acception between two dates?
    I have the following, but this is’nt working:

    else if (fieldname30==58) && (fieldname5=between(date 01/01/2000, date 30/12/20017))
    return 8;

    I hope that the meaning is clear.
    Can you please advise me?

    Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author codepeople

    (@codepeople)

    7 years, 9 months ago

    Hello,

    Your code includes multiple syntax errors, please, remember that the programming language supported by the browsers is javascript, and the piece of code you are trying to use is not a valid javascript code. Please, modify the condition as follows:

    if(fieldname30 == 58 && FLOOR((new Date('01/01/2000')) / 86400000) <= fieldname5 && fieldname5 <= FLOOR((new Date('12/30/2017')) / 86400000))

    If you need additional help implementing your project, I can offer you a custom coding service from my private website:

    http://cff.dwbooster.com/customization

    Best regards.

    Thread Starter alexvds

    (@alexvds)

    7 years, 9 months ago

    Thanks, this is cool!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘exception between two dates / years’ is closed to new replies.