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

How to convert smartforms into Adobe forms.

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

How to convert date format in XI? Help!

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

Cannot insert date into numbers 3.1 using ctl shift d

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

How to upload data into form of Oracle EBS R12 using ATS ver 9.0

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

How to convert bytes[] into File object

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

How to Convert frames into minutes and seconds

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

How to Convert Date (DD.MM.YYYY) to be just DD

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

How to convert arraycollection into HierarchicalData?

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

How to convert date to number

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

How to put data into a array element in the BPEL

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

How to input data into a table with columns?

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

How to Convert Data types here

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

How to populate data into view object

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

How to insert date into a table by selecting form sysdate

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

How to convert date in the dashboard prompt

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

How to convert date format in VC 7.0 to DD.MM.YYYY

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

How to add data into JTable

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

How to convert HTML into XML

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

How to convert beta into imovie

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

Tags:

  1. FcffairBigDataResource
  2. anything
  3. how to upload excel data into forms 11g
  4. YouTube não carrega no lg d300f
  5. software to stop pops safari 5.1.10
  6. inurl: sign.html
  7. troubleshoot software hpwindow7
  8. WS12300111 standard steps sap
  9. E317
  10. package4uu
Copyrights 2019 Fcffair BigData Resource, All rights reserved