Andrew2009
Well Known Member
Below is my existing table I/O select. There's a Date field (DWK) also and I want to get records ONLY within a date range, for example in January, from 1/1/2017 to 1/31/2017. Can I do a Date range in the Table select I/O? If not, what other solutions can I do please?, right now the only solution I can think of is to loop through the list of returned records and check for the DWK field. But there could be a lot of records returned.
F06116.Select [Index 1: Address Num, Date Work, +B]
| VA rpt_szDS_BillingDetailJob_MCU [MCU] = TK Business Unit [MCU]
| BC Category Code - G/L2 (F5548112.0) [R002] = TK Subsidiary [SUB]
Thanks
F06116.Select [Index 1: Address Num, Date Work, +B]
| VA rpt_szDS_BillingDetailJob_MCU [MCU] = TK Business Unit [MCU]
| BC Category Code - G/L2 (F5548112.0) [R002] = TK Subsidiary [SUB]
Thanks