Maliki Hassani
asked on
Crystal date Range Modification for 2 weeks
Experts,
How can I modify my query to lpull data for the last two weeks, instead of only 1 week. Needs to still be from Monday - Sunday intervals.
Here is what I have that is for the LAST week.
{Command.UDF_CONVERT_UNIX_ DATETIME(M X.DATE_CRE ATED,'US/E ASTERN')} in CDate(dateadd("d",1,minimu m(LastFull Week))) to CDate(dateadd("d",1,maximu m(LastFull Week)))
How can I modify my query to lpull data for the last two weeks, instead of only 1 week. Needs to still be from Monday - Sunday intervals.
Here is what I have that is for the LAST week.
{Command.UDF_CONVERT_UNIX_
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Very Nice, thanks!
ASKER
{Command.UDF_CONVERT_UNIX_