Question about Oracle Database Enterprise Named User Plus

1 Answer

Need to write an IF statement for date ranges and show the week

I have a group of dates and I want to show what week of the year they fall into...

EX: 08/02/08 through 08/08/08 are in week 36 and 08/09/08 through 08/15/08 are week 37

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 45 Answers

Use weeknum on the start and end dates to know which weeks they fall

=weeknum(cell reference)

Posted on Nov 19, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

Need to have a certain cell say OFF when it is a certain day


Use the test function.
Formula in cell A1 would be =text(a2,"dddd").
This would pick up the date from cell A2 and return the day of the week in cell A1.

Jun 06, 2010 | Microsoft Excel for PC

1 Answer

Can some one show me to up date my urovox box ex 1000 sl and howe i get soft ware


Get firmware from here

http://www.4shared.com/file/93932114/aa4fff3f/UFL_EX1000SL_24-02-09_DarX.html

Full tutorial here, also shows connections you need for PC

http://forums.afterdawn.com/t.cfm/f-59/eurovox_firmware_flashing_guide-674371/

Sep 11, 2009 | SonicWALL Software and Firmware Updates...

2 Answers

Sigmatel s9 manual


MY SIGMATEL CHINES CELL PHONE MO. NO.S9 IS NOT CONNECT MY PC BY USE. I WANT TO DOWNLOAD SOME SONGS AND VIDEOS.

Dec 11, 2008 | Handmark Software MobileLists (950142) for...

1 Answer

Need to Add Dates in Excel


Here is one way I just tried:

Say the date purchased is in A1.

You want the Est Life in A2.

In A2 type: =A1+(3*365)
That will add 3 years.

For 5 years: =A1+(5*365)

Try it out!

Note: You will need to format the cells to Custom>mm/dd/yyyy

Nov 21, 2008 | Microsoft Excel for PC

2 Answers

Min and Max Date range filter


Check out: Tools -> Data -> Filter -> Auto Filter.
You may want to look at the help function to get a better idea of how powerful this feature is.

Let me know if this helps.

May 08, 2008 | Microsoft Excel for PC

1 Answer

Formula for Date


Make that column fixed and give the variable date and value 26/Month of year/year

That is the logic Can you do that

Fixya?

Mar 21, 2008 | Microsoft Excel for PC

1 Answer

Creating Running Sum with Grouping Query


Looks like your GROUP BY subclause says to group by Force_no but also the yyyy and m datepart values for Subs_Dt as separate items. [Also since you are returning "Force_no AS FN", you need to refer to it as 'FN' and not 'Force_no' in the other subclauses of the statement. Same is true for your partial-date references as well in the SELECT subclause] So the query will return the grouping not by Force_no (should be FN) and some partial date but instead by Force_no (shoukd be FN), the year, and then the month.

The fix would be to group by a concatenation of the year and month and to change the references to the fields to be what you renamed them as in your SELECT subclause using "...AS...", for example:

SELECT GIS_Subs.Force_No AS FN, DatePart("yyyy",GIS_Subs!Subs_Dt) AS AYear, DatePart("m",GIS_Subs!Subs_Dt) AS AMonth, DSum("Subs_Amt","GIS_Subs","DatePart('m', [Subs_Dt])<=" & [AMonth] & " And DatePart('yyyy', [Subs_Dt])<=" & [AYear] & "") AS RunTot
FROM GIS_Subs
GROUP BY FN, AYear & "-" & AMonth
ORDER BY AYear, AMonth;

So now you have only 2 GROUP BY parameters instead of three and the grouped results won't be done by FN, then year, then month, but by FN and year-month. [As for the "-" in GROUP BY subclause, you can use any character you want as the separator; I just picked "-" since it is so typical.]

The DSum function in the SELECT subclause may also need some rework; also, possibly you will need to return [Subs_Dt] in the clause as well so DSum() has it to work with. Also check to be sure that reference to [Subs_Dt] is being recognized OK without using the "table!field" form of reference. I dunno if you need it given I don't know your whole table-field definition and so can't say if there would be a naming conflict someplace.

If you are still having trouble, try starting over and building this query piece by piece, one field, one condition, one subclause, at a time until you get to where it breaks for you. That'll be the "threshold of failure" you are looking for that should point you further in the right direction.

I hope this works for you. Let me know how it goes!

Feb 23, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

How do i get a customers old unpaid invoice to show up automaticaly on his new invoice?


Under Creat Statements, change your "Statement Period" dates to include last months invoices for the rent. Once you have don that, and picked your customer to send the invoice to, then click on preview. This should show you the statement and should have the right charges on it if they were invoiced.

If this helps, please rate me. Thanks, Patty

Dec 19, 2007 | Business & Productivity Software

Not finding what you are looking for?
Oracle Database Enterprise Named User Plus Logo

Related Topics:

263 people viewed this question

Ask a Question

Usually answered in minutes!

Top Oracle Business & Productivity Software Experts

robertmoore1

Level 2 Expert

179 Answers

Fred Block
Fred Block

Level 2 Expert

289 Answers

cwradio73

Level 3 Expert

899 Answers

Are you an Oracle Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...