Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

sum funtion based on sytem dates

 
arjun rampal
Ranch Hand
Posts: 125
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi I have a column "TOTAL" which is adding numbers in it rows.I am using SUM Function for that.
Problem-I dont want the sum of all rows .I want sum of only last 5 days before system date.
for example if today is 29 october as per my computer.I want summantion of 23+25+26+27+28+29(24 not included as it is sunday).

it would be greate if solution would be specific

is that possible if yes how?
present query SUM(TOTAL)

REGARDS
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Just filter on your criteria in the where clause.


Mark
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic