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

Re: [Clip] yesterday clip

Expand Messages
  • kitpath
    ... with ... Clever again. Thanks hrs! -pat
    Message 1 of 3 , Nov 8, 2004
    • 0 Attachment
      --- In ntb-clips@yahoogroups.com, hsavage <hsavage@p...> wrote:
      > kitPATh wrote:
      > > Is there another way to insert yesterday's date? Maybe padded
      with
      > the zero when less than 10? pat(riv)
      > >
      > >
      > > H="yesterday"
      > > yesterday
      > > ^!set %yd%=^$getdate(dd)$
      > > ^[yyy-mm-^]^$Calc(^%yd%-1)$
      >
      > Pat,
      >
      > Try this, inserts a leading zero on single digit days.
      >
      > hrs
      >
      >
      > H="yesterday"
      > ^[yyyy-mm-^]^$StrCopyRight("0^$Calc(^[dd^]-1)$";2)$

      Clever again. Thanks hrs!

      -pat
    Your message has been successfully submitted and would be delivered to recipients shortly.