Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
i would like to create a set analysis of count of a field "refid" for when the date field "REQDATEORDER" is smaller than today +7 days in the fufure.
If today is the 1st of May the set analyisis should give all records with the "REQDATEORDER" before the 8th of May.
Thanks in advance for your help.
Lawrence
May be like this
{<REQDATEORDER = {"$(='<=' & Date(Today() + 7, 'DateFieldFormatHere'))"}>}
May be like this
{<REQDATEORDER = {"$(='<=' & Date(Today() + 7, 'DateFieldFormatHere'))"}>}
Woao that was fast, thank you very much Sunny.
Hi again,
is there any good way to understand the syntax of the script? I really can not understand the logic behind it.
Thanks,
Lawrence
best place to start would be here
and then go here for advanced stuff