Results 1 to 2 of 2

Thread: just a little more help please...

  1. #1
    Marc Coleman Guest

    just a little more help please...


    Thanks Mark for the earlier reply... I went to the example you sited and have tried placing semi-colon in just about every place at the end but except of course the correct one! Could you please use my example below and add another ficticious field named inception with the same parameters of dcanceldate??

    Thanks

    FDF = "(;!/+|)dcanceldate!!!" &_
    " | Pick a Date Range/" &_
    &#34;>=DATE() AND <=Date()+1 | Next 1 day /&#34; &_
    &#34;>=DATE() AND <=Date()+2 | Next 2 days /&#34; &_
    &#34;>=DATE() AND <=Date()+3 | Next 3 days /&#34; &_
    &#34;>=DATE() AND <=Date()+4 | Next 4 days /&#34; &_
    &#34;>=DATE() AND <=Date()+5 | Next 5 days /&#34; &_
    &#34;<=DATE() AND >=Date()-7 | Last 7 days /&#34; &_
    &#34;<=DATE() AND >=Date()-30 | Last 30 days /&#34; &_
    &#34;<>NULL | All Cancelled /&#34; &_
    &#34;!!!9&#34;

  2. #2
    Mark Guest

    just a little more help please... (reply)

    Marc,
    Easy ...

    FDF = &#34;(;!/+|)&#34; &_
    &#34;dcanceldate!!!Pick a Date Range/&#34; &_
    &#34;<=DATE() AND >=Date()-7 | Last 7 days /&#34; &_
    &#34;<=DATE() AND >=Date()-30 | Last 30 days /&#34; &_
    &#34;<>NULL | All Cancelled /!!!!9;&#34;
    &#34;dshipdate!!!Pick a Date Range/&#34; &_
    &#34;<=DATE() AND >=Date()-7 | Last 7 days /&#34; &_
    &#34;<=DATE() AND >=Date()-30 | Last 30 days /&#34; &_
    &#34;<>NULL | All Cancelled /!!!!9;&#34;




    ------------
    Marc Coleman at 12/14/00 11:10:21 AM


    Thanks Mark for the earlier reply... I went to the example you sited and have tried placing semi-colon in just about every place at the end but except of course the correct one! Could you please use my example below and add another ficticious field named inception with the same parameters of dcanceldate??

    Thanks

    FDF = &#34;(;!/+|)dcanceldate!!!&#34; &_
    &#34; | Pick a Date Range/&#34; &_
    &#34;>=DATE() AND <=Date()+1 | Next 1 day /&#34; &_
    &#34;>=DATE() AND <=Date()+2 | Next 2 days /&#34; &_
    &#34;>=DATE() AND <=Date()+3 | Next 3 days /&#34; &_
    &#34;>=DATE() AND <=Date()+4 | Next 4 days /&#34; &_
    &#34;>=DATE() AND <=Date()+5 | Next 5 days /&#34; &_
    &#34;<=DATE() AND >=Date()-7 | Last 7 days /&#34; &_
    &#34;<=DATE() AND >=Date()-30 | Last 30 days /&#34; &_
    &#34;<>NULL | All Cancelled /&#34; &_
    &#34;!!!9&#34;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •