I have looked in the Advanced Training Series and here in this discussions but can't find an answer. I'm thinking it should not be so hard...
In my custom table I made a calculation field that I want to show; How many orders have been made the last 30 days.
In order table I have a date field that show the date the order is made.
I have tried the Let function and the Case function with no good result.
I'm thinking of getting the last 30 days as a variable and use it some how. I'm stuck! Please help me get loose from this swamp.