IO am just trying to figure out a simple date calculation. I have a admin preference called XeroStartDate. When I upload records, I want the upload script to first check the Invoice date does not predate the XeroStartDate field. Any ideas?
kht wrote:the Invoice date does not predate the XeroStartDate field.
the Invoice date does not predate the XeroStartDate field.
Invoice::theDate >= Preferences::XeroStartDate
would have to be true.
(Or, if you prefer, Preferences::XeroStartDate < Invoice::theDate)
It kind of depends on where you're uploading from. To my knowledge, there's no way to validate data on an import, however you could validate it afterwards.
Set a created_at field with the option to auto populate with a timestamp on creation. Before the import step, set a variable $time = Get(CurrentTimeStamp). Then after the import step do a find for created_at > $time and Invoice::Date < AdminPreference::XeroStartDate then Delete Found Set.
What that will do is search through all the records you just uploaded and find ones that have a Date before XeroStartDate, and delete them.
Alternatively, you could look into how field validations work with Imports. I'm not sure if the import will stop when an entry fails validation, though. For instance, you may be able to set a validation by calculation on the Date field, where Invoice::Date >= AdminPreference::XeroStartDate
Thanks. I was clearly not thinking straight. I was thinking about using a Get(current date) but this is not relevant. All working.
Retrieving data ...