Financial week and year problem [message #395340] |
Wed, 01 April 2009 03:20  |
mohaninforakle
Messages: 55 Registered: January 2009
|
Member |
|
|
Hai,
I have a query that how to get the week no as per financial year starts & ends,Say for example according to financial year the month starts from Apirl to march so the first month is apirl,then
apirl 1 to 7 days is first week.
My command is
to_char(mydate,'WW') This command is i used now to get a week no from particular date.But how to get the week no as per financial starts & end
Please somebody help me,already i posted this query,please am in hurry now.I waiting for yours reply.
[MERGED by LF]
[Updated on: Fri, 03 April 2009 14:43] by Moderator Report message to a moderator
|
|
|
|
|
financial week problem [message #395687 is a reply to message #395340] |
Thu, 02 April 2009 04:47   |
mohaninforakle
Messages: 55 Registered: January 2009
|
Member |
|
|
hai,
again i have a problem of getting a weekno for a particular date that should be as per financial year starts & ends.In financial year its starts on march and ends on april.My problem is i want to schedule meeting for one year that is 53 weeks.Initially i will give a date that will automatically increased by 7 days and will schedule one year. But my weekhas to be counted for a date as per financial months starts & ends.That is march 1 to 7 is a first week and 7 to 8 is a second week and so on.Please help me somebody how to do that please...
Am waiting for your reply.
|
|
|
|
|