HOW TO CONVERT DATE INTO NUMBERS
Advertisement
October 11
HI,
what the syntax for converting date into No. Ex from the first date of the month till current date how many days are there, this No of days needs to be divided by the net sale of the month.
i have searched in formulas fields but i am not able to find such option...
please help.
Thanking you,
UMAR NAYAB.
Advertisement
Replay
Hi,
Stratos and Sastry
the formula given by you shows the variation for the current month of suppose 30 days
but if the month is of 31 days or 28 days (feb) how will the system will able to generate the report accordingly.
i want to make a report in which it should show the net sales by the current month and current date.
so the system should automated by the number of days in a month.
thanking you..
UMAR NAYAB.
View 6 Replies
November 30
Hi...... How to convert smartforms into Adobe forms. Regards Anbu BHi, You need to use the Function Module CONVERT_OTF. Please check the below code REPORT zsuresh_test. Variable declarations DATA: w_form_name TYPE tdsfname VALUE 'ZSURESH_TEST', w_fmo
View All Replies
October 11
Hi Experts, PIP is the input for XI. The PIP has date as : <DateTimeStamp>20030515T000000.000Z</DateTimeStamp>. How to convert it into MM/DD/YYYY format in XI? Thanks Gopalhi, use two standard functions: <b>substring </b>(to take
View All Replies
November 30
can no longer insert date into numbers 3.1 using control shift dHi Gerald, If you are inserting the current date a lot, and want a simple keyboard combination to do it rather than fiddling with formulas in Numbers, here is an easy way that takes adva
View All Replies
October 11
Hi experts, Could you please guide me how to upload data into form on Oracle EBS R12 using Oracle Application Testing Suite verson 9.(The simpliest way) For example: I need to create user account on Oracle EBS. Normally, I use Dataloader to upload th
View All Replies
November 30
hi how to convert byte array into File object pls.. help me Regards srinurrrr007 wrote: Hi, How to convert bytes[] into multipage File object?? ]There's no such thing as a "multipage File object." You ought to re-read this thread closely, and re
View All Replies
November 30
Hi, does anyone know how to convert frames into time (minutes and seconds). I need the users to view the swf with current time being played and over time. I have 2152 frames in total and I want that to be converted to time. Can anyone help me on this
View All Replies
October 11
Hi experts, I have no idea how to convert Date format (DDMMYYYY) to be just DD. Example: I have date: 31.10.2009 now i just want to show in report as 31. I just known if we just want to show month only, we could use the 0CALMONTH2. but how if i need
View All Replies
November 30
Hi, Anyone can tell that how to convert arraycollection(flat data) into HierarchicalData? Thanks in Advance.i give a example below. it conver flat arraycollection data and display in hierarchical manner in datagrid <?xml version="1.0"?&g
View All Replies
November 30
Hai How to convert the given date into number. Thanks & regards srikkanth.MLook at these posts Please help me in Converting Lilian Format to Date converstion to date and try something like this. SELECT sysdate,sysdate-to_date('15-10-1582','DD-MM-YYYY
View All Replies
October 11
Hi, I have a element in the WSDL which is of type Array. (i.e accepts unlimited data for the same element). How should i put a data into a array in the BPEL. Example: The below Example gives u an idea about wht iam asking:pasting a piece of my requir
View All Replies
October 11
I am trying to input data into a table. My table have 5 columns and an unlimited amount of rows. I created a program in LabView that enters the data into the table but it enters all of the data in one row. I would like to enter the first set of in
View All Replies
November 30
Hi All, My stored proc is as below, create or replace procedure proc_sec_synch ( Begin FOR sec_Update in ( Select SsM_ID , CYCLE_DATE , TARGET_TABLE , COLUMN_NAME , NEW_DATA , COLUMN_TYPE from PM_OWN.test_synch order by target_table Loop *'Update' |
View All Replies
October 11
Hi all, I am quite new with ViewObject. I have one data table which is binding with view object. I want to populate data into view object from my managed bean. how can i achieve this kind of scenario? actually i try to get view object as in the follo
View All Replies
November 30
Hi My Table format is like this SQL>desc log; Name Null? Type EMP_ID VARCHAR2(30) LOGIN DATE LOGOUT DATE now when ever an employee logs in i w'd like to insert date into the table. i put up the following query SQL> insert into log(emp_id,login) 2 va
View All Replies
October 11
can anybody tell me how can i conver the date into month year format in the dashboard prompt originally i am getting data as a date in the dashboard prompt.i want to change that to MON YYYY format. can anybody tell me how can i change the original da
View All Replies
October 11
Hi I am on VC 7.0. My requirment is to show Current date as a default value for a input field. I am using date function now() as default value...and it is displaying the current date 08.07.2009 as Jul 08,2009 But my requirment is to display it
View All Replies
November 30
How can I add data into JTable, for instance ("Mike", "Gooler", 21).How can I add data into JTable, for instance ("Mike", "Gooler", 21).You will have very good results if you segregate out the table model as a seper
View All Replies
November 30
I know I can parse XML into some HTML, but is there any tools or methods existed to parse HTML into XML? I have a not well-formed HTML with a lot data fields, including a lot not closed tags. This HTML is generated by some XML(as I can see), but I ca
View All Replies
November 30
Hey everyone, I'm new to macs and imovie.... Im trying to find out how to convert my old home videos into dvds but the problem is I don't know what adapters to use and how to do it. The home videos are in beta and I don't know how to get them onto my
View All Replies