Date Range Calculations
I need to find out what calculations to use to for getting this week range.
We currently have the Range Start Field with a date and a Range End Field with a date, as well as the Date Range Option Drop Down List to select if you would like This Week, Last Week, Next Week, This Month, Last Month, Next Month to show order records?
I'm currently using a script for each Date Range to set fields for the Range Start and Range End Date but not sure what calculation to use to get "This Week", "Last Week", "Next Week", "This Month", "Last Month", "Next Month".
Please let me know what the best calculation option, i'm sure you would need to use the Get( CurrentDate ).
Thanks for your help.