Hi all, Just looking for advice on dates:

The goal is to limit records to those where the AROBL.DATEINVC is between a Start Date (%PROSTART) and and end date (%PROEND) stored in an Excel spreadsheet.

All dates stored as YYYYMMDD right now.

Route 1 - based on p.6 of IMAN User Guide

Call these in VBScript Dimensions?

Dim PROSTART 

PROSTART = CDate(%PROSTART)

Dim PROEND

PROEND = CDate(%PROEND)

Dim DATEINVC 

DATEINVC = CDate(AROBL.DATEINVC)

If DATEINVC >= PROSTART And DATEINVC <= PROEND 

Dim DATEINVC

Route 2 : Create a Lookup and within that, try to filter using SQL:

WHERE Clause: AROBL.INVDATE BETWEEN ' "%PROSTART" and "%PROEND" '

Of course Route 2 is not using the CDate function.

Based on this post it seems like I will have to do that:

https://www.realisable.co.uk/sage-300/setting-posting-date-and-document-date-on-ar-invoice-creation/

Route 3: Filter results within a filter transform instead of within the Lookup definition?