Loading ...
Sorry, an error occurred while loading the content.

Re: Comparing Dates Help

Expand Messages
  • libbazet
    Flo, Thanks for the help. This will work out perfectly. I didn t need the date to be in any certain format. I just needed it run the comparison, so that I
    Message 1 of 3 , Jan 20, 2007
    • 0 Attachment
      Flo,

      Thanks for the help. This will work out perfectly. I didn't need the
      date to be in any certain format. I just needed it run the
      comparison, so that I could eliminate users who should no longer have
      access.

      Elizabeth

      --- In ntb-clips@yahoogroups.com, "jonas_ramus" <flo.gehrke@...> wrote:
      >
      > Elizabeth,
      >
      > I managed to make your clip work on two conditions:
      >
      > 1. Change the date format to yyyy/mm/dd (regarding your data).
      > 2. Change ^$GetDate(m/d/yyyy)$ to ^$GetDate(yyyy/mm/dd)$.
      >
      > I would propose to arrange your data in a table like...
      >
      > 2007.01.03|HY9999|HENRY
      > 2007.05.06|HY9998|HENRY
      > 2006.12.21|HY9997|HENRY
      > end of table (needed for counter)
      >
      > Now you can call up fields...
      >
      > ^!SetDelimiter "|"
      > ^!Jump 1
      > :Loop
      > ^!Set %Date%=^$GetField(^$GetRow$;1)$
      > ^!If ^%Date% < ^$GetDate(yyyy/mm/dd)$ Next Else Skip
      > ^!Info Expired: ^$GetLine$ !
      > ^!Jump +1
      > ^!If ^$GetRow$ = ^$GetLineCount$ End Else Loop
      > :End
      > ^!Info Finished!
      >
      > Regards
      > Flo
      >
    Your message has been successfully submitted and would be delivered to recipients shortly.