OpenDate wrong

  • This topic has 2 replies, 2 voices, and was last updated 7 years ago by avatarAVT.
Viewing 3 posts - 1 through 3 (of 3 total)
  • #41012
    AVT

    I get a wrong result with OpenDate which should return YYYYMMDD format. Any ideas? Thanks.

    Separate values are correct. OpenDate returns 20,2M, picture attached.

     

     

    #41584

    The result of #ODate# is good, in fact it has been plotted in a simplified rounded number format. I don’t think there is other possibility to draw it in its real format. But you could try this instead:

    I don’t know if this solution is working, could you confirm?

    1 user thanked author for this post.
    avatar AVT
    #41587
    AVT

    Confirmed.

    That’s what my alternate was: Use the separate ones and forget about using OpenDate because it is simply not returning the value as documented (which makes it impossible to work/calculate with it).

    Thanks Nicolas!

Viewing 3 posts - 1 through 3 (of 3 total)

Create your free account now and post your request to benefit from the help of the community
Register or Login