Select week-ending date

[juster21]

I need to be able to have my application select the current week-ending date from a listbox.
I have seen some things on the net but nothing that really helps.

If anyone can provide help, that would be awesome.

p.s. - the dates are prefilled in the listbox in mm/dd/yyyy format.

[kadghar]

I need to be able to have my application select the current week-ending date from a listbox.
I have seen some things on the net but nothing that really helps.

If anyone can provide help, that would be awesome.

p.s. - the dates are prefilled in the listbox in mm/dd/yyyy format.

I dont understand very well what you need, but it seems that the function WEEKDAY might be of help.

[Reldeed]

I believe what he is looking for is a code that will allow the identification of the last day of the week.

So, if today is wednesday, you want to know what the date will be on Friday. I am currently looking for something that will allow me to take current and next week dates and create a report.

Anyone have an idea of a fast way this can be done? I know I can do it with a number of Case lines but I don't think all that code is necessary.