Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: I need formula to determine "last week" Post Reply Post New Topic
Author Message
Alex
Newbie
Newbie


Joined: 28 Jan 2008
Location: Canada
Online Status: Offline
Posts: 22
Quote Alex Replybullet Topic: I need formula to determine "last week"
    Posted: 10 Mar 2008 at 10:21am

Formula should be flexible to allow custom start (date and time) and end (date and time), so I can define my week for eg. mon-sun, or sun-sat etc...

Question #2 is there way to make report to drill down to level 3 on start? I would like to have parameter which allows to switch view from "summary view" (level zero) to "detailed view" (level 3)?

Thanks all who try to help.

IP IP Logged
Alex
Newbie
Newbie


Joined: 28 Jan 2008
Location: Canada
Online Status: Offline
Posts: 22
Quote Alex Replybullet Posted: 11 Mar 2008 at 9:58am
I found solution for "last week formule", here it is in case someone else need it:
totext(currentdate-dayofweek(currentdate)-5, "MMM dd, yyyy") + " to " +
totext(currentdate-dayofweek(currentdate)+1, "MMM dd, yyyy")
 
If someone could look up into my question #2 that would be much appriciated.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.