• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 240
  • Last Modified:

Maximum Date

Hi Expert,

I have a file like this

Date,sales volume
12/31/2004,1
1/4/2005,2
1/5/2005,3
1/7/2005,5
1/6/2005,6

How can I find out the max date and sales volume for that date?

Thanks
0
justinY
Asked:
justinY
2 Solutions
 
Infinity08Commented:
You can read in each of the records (date and sales volume) into a data structure (vector for example), sort it (descending order possibly) on date, and then you can easily retrieve the most recent sales volume.
0
 
romanmCommented:
turn each date into a number, with the formula: X = dd + (31 * mm) + (31 * 12 * yyyy);
where the date is dd/mm/yyyy, this converts the date into a number of days (rough estimate) since 0/0/0000.
call this function date_num( date )

now start be defining three variables,
int max_date = 0
int volume = 0
string s_max_date = "0/0/0000";

for each line you read,
extract, date and sale_volume
if max_date < date_num(date) then
   max_date = date_num(date)
   s_max_date = date
   volume = sale_volume
go to next line

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now