I am currently trying to determine if a particular field's date falls within the previous week, and if it does I want the whole record to be shown in the Transform pin. I am new to data3sixty, so I am not sure what the command should be after the if else statement.
I have attached my code below.
## import data package
## assign date variables
today = datetime.date.today()
six_day = datetime.timedelta(days = 6)
week = today - six_day
## Statement to extract recent job movements
if fields.JOBCODE_ENDDATE < week and fields.JOBCODE_ENDDATE > today:
Please sign in to leave a comment.