AnsweredAssumed Answered

找尋最近的記錄

Question asked by clomama :D on Oct 12, 2016
Latest reply on Nov 15, 2016 by jixoxoxo

Hi,

 

我有一個table儲存客戶購物記錄如下:

 

Client IDDate_PurchaseQtyProduct
57/9/201640Eraser
95/7/201630Ruler
21/9/201660Pencil
97/9/201620Eraser
57/9/201650Ruler
715/9/2016100Sharpener
815/9/201680Pencil
531/8/2016100Shorthand book

 

今天是13/10/2016, 我要寫一個script, 用Date_Purchase這column自動找尋最近期的購物記錄, 即15/9/2016 export to an excel file。我準備這樣寫script:

 

a. Go to layout

b. Enter Find Mode

c. Set Field

d. Perform Find

e. Export Records

 

請問我應該用found set(b-d)定係 constrain found set去找最近期的購物記錄? 不論c或constrain found set都好, criteria怎樣寫? 因為最近期的購物日期是常變的。

 

麻煩哂!

Outcomes