Hi Friends, I have 2 fields in my table FROM DATE & TO DATE User can enter any date in these two fields, but at time of commit i want to change the FROM DATE to the first date of the Month user have entered. And for TO DATE i want to change the last date of the month. For Example : User Enters- FROM DATE 12-Mar-2003 TO DATE 27-Jun-2003 I want to change these date to: FROM DATE 01-Mar-2003 TO DATE 30-Jun-2003 How can I write a database function or procedure to control this thing. Please help. Best regards, Imran Baig
It depends on your requirements, but I usually use TRUNC(date, 'D')
to get the first day(Sunday) of the week, because TRUNC(date, 'W')
returns the same day of the week as the first day of the month.
for more info on this.
Dear all, is there any FM to to do the following:- if in the selection screen i give the date as 09.2007 (MM.YYYY) then i want the output as 01.09.2007 to 30.09.2007 If u go to transaction MC.1 in that u will find this as select options. So when i e
Hello Experts, I am facing an issue while designing a query. Requirement is like this. Report will be run on monthly basis.so on execution of report, it should prompt for month/year. now on report there are two columns for which I have to get data on
Hi, i have an application in wich the user puts a date, say today 2010-08-10 and i have to calculate first and last day of that week, in this case 2010-08-09 and 2010-08-15. How can i do this? Many thanks in advance, Nuno Almeidanfalmeida wrote: i ha
Is there any example how to use 'first' and 'last' functions in an sql query ? I have tried to execute a query like this on the scott.emp table : select deptno,min(sal),max(sal),first(sal) from emp group by deptno; but I always get this message: ERRO
lets say we have a name column with values; c1 Antu Anamentu Steven Smith Since A=A and U=U for the first value we need a TRUE and FALSE for the second value SQL. Is this possible to do with REGEXP functions on 10gR2. Thank you.Hi Frank, Just minor c
I'm working in JDeveloper 10.1.3.5.0. I'd like to know if there's a way to ensure that the action links 'First' and 'Last' will appear, in addition to the 'Next' and 'Previous' ones (that is, assuming we're not already at the first or last range posi
Hi All, I need to find last date of month for given year. Example: I used to pass date or year such as 2012 or 01-01-2012(DD-MM-YYYY) SQL query needs to return last date of every month such as 31-01-2012 28-02-2012 31-03-2012 30-04-2012 31-12-2012 fo
i imported contacts to the contacts app and they all say "NoName". i click on one of them and the first and last name fields are empty but the nickname field has the first and last name in it. how can i bulk edit 1120 contacts to change the full
iphone 6+ somehow has switched my name on emails into my nephew's name. We share a first and last name but not a middle name. For example, my name might be John George Doe and his name John James Doe. How did this happen? How do I correct it.So if th
I frequently get Illustrator files in that have individual objects such as paths on individual layers that could be grouped to make the layers more concise. I find that I have to shift click each individual layer to select it to eventually group it.
is it required long caluculation or is there any simple method?hi, try this FM -> 'HR_JP_MONTH_BEGIN_END_DATE' chk this also CALL FUNCTION 'LAST_DAY_OF_MONTHS' EXPORTING DAY_IN = sy-datum IMPORTING LAST_DAY_OF_MONTH = v_lastdate. <--Gives you the la
I just got a new iMac and transferred the contents of my old eMac running on OS 10.3---(latest) using the Mac transfer system. Problem: in the address book most of the cards do not respond to the Preference setting for First or Last name first. Some
In Outlook 2007 when I add a new contact and type in the full name (say John Doe) it puts in the full name field "John Doe" and files it as Doe, John. This is how I have always done it and all of my contacts are setup like that. When I add a con
Any ideas on how to achieve this? http://office.microsoft.com/en-us/excel-help/split-names-by-using-convert-text-t o-columns-HA001149851.aspxIf: A1 = Fistname Lastname For firstname: (First Name) B1 =SUBSTITUTE($A1," " & $C1, "") F
Hi all, I am creating an application where i am using vb script to export the data to excel. In the excel sheet most of the values are entered with double " quotes. so the entry looks like ""http://www.sap.com"". Notice that it is
Sometimes i pick up my blackberry and find that my mailbox is showing emails or texts that i got 6 months ago. i then spend 15 minutes scrolling with my trackball to get to the current day's messages. Since there must be some button which automatica
Could someone please help with the TSQL to achieve the following: Every Employee has 2 records (From & To). Output has to display one record for each employee with From & To as columns. Input Empid Type Date 100 From 5/4/2004 100 To 6/2/2008 101 F
Hi, We are using the Cisco SPA-504G on BroadWorks Release 17.sp3. We are using the feature to lookup the different BroadWorks directories through the 'dir' button on the Cisco phone. For configuration you have three choices for telling the phone whic