mday サンプル1
入力データ
| 顧客 | 来店日 | 生年月日 |
|---|---|---|
| customer1 | 19900115 | 19641222 |
| customer1 | 19900131 | 19641222 |
| customer1 | 19900521 | 19641222 |
| customer1 | 19900611 | 19641222 |
| customer2 | 19900122 | 19720103 |
| customer2 | 19900521 | 19720103 |
| customer2 | 19900801 | 19720103 |
| customer3 | 19910303 | 19720103 |
| customer4 | * | * |
| customer4 | 19900131 | * |
| customer4 | 19900610 | 19900618 |
| customer4 | 19900611 | 19900608 |
処理コマンド
mday field1=2 field2=3
結果データ
| 顧客 | 来店日 | 生年月日 | 日数 |
|---|---|---|---|
| customer1 | 19900115 | 19641222 | 9155 |
| customer1 | 19900131 | 19641222 | 9171 |
| customer1 | 19900521 | 19641222 | 9281 |
| customer1 | 19900611 | 19641222 | 9302 |
| customer2 | 19900122 | 19720103 | 6594 |
| customer2 | 19900521 | 19720103 | 6713 |
| customer2 | 19900801 | 19720103 | 6785 |
| customer3 | 19910303 | 19720103 | 6999 |
| customer4 | * | * | * |
| customer4 | 19900131 | * | * |
| customer4 | 19900610 | 19900618 | -8 |
| customer4 | 19900611 | 19900608 | 3 |