1)I have a date field,now i have to map this date with a difference of 7 days between each week.
i want to map dates like this.
How can i do that thank you
2)Also i have falls data with fall date,and how do i calculate no of falls in each week.
What defines the date you choose - every sunday?
You may be able to use something like
datetrunc('week',[your date field])
You would use this as the date field in both of your questions.