Sorry, an error occurred while loading the content.
Browse Groups

• 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)\$
Message 1 of 3 , Nov 8, 2004
View Source
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)\$
• ... the zero when less than 10? pat(riv) ... Pat, Try this, inserts a leading zero on single digit days. hrs H= yesterday
Message 2 of 3 , Nov 8, 2004
View Source
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)\$
• ... with ... Clever again. Thanks hrs! -pat
Message 3 of 3 , Nov 8, 2004
View Source
--- 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.
• Changes have not been saved
Press OK to abandon changes or Cancel to continue editing
• Your browser is not supported
Kindly note that Groups does not support 7.0 or earlier versions of Internet Explorer. We recommend upgrading to the latest Internet Explorer, Google Chrome, or Firefox. If you are using IE 9 or later, make sure you turn off Compatibility View.