Options

Comparing Date and String

kampretkampret Member Posts: 38
guys, do u know how do i compare a Date variable with a String variable.
thanks

Comments

  • Options
    DenSterDenSter Member Posts: 8,304
    Could you please tell us exactly what you want to do? Maybe it is a language issue, but I do not understand what you need.
  • Options
    krikikriki Member, Moderator Posts: 9,090
    Convert the string to a date variable (with EVALUATE). Then you can compare 2 dates.
    I hope I understood your question correctly.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • Options
    Timo_LässerTimo_Lässer Member Posts: 481
    IF FORMAT(myDateVar) = myTextVar THEN
      DoAnythingUsefull;
    
    or
    IF EVALUATE(myDummyDateVar,myTextVar) THEN
      IF myDateVar = myDummyDateVar THEN
        DoAnythingUsefull;
    
    Timo Lässer
    Microsoft Dynamics NAV Developer since 1997
    MSDynamics.de - German Microsoft Dynamics Community - member of [clip]
Sign In or Register to comment.