View Complete Post
i need to know if, given a birth date, a person has more than x years. Thats mean, the client must entry a date in a textbox and i need to know if the persona has more than 18 years.
Thx in advance
have two text box on which I give two date input by using rapid
application development datepicker textbox. I have another text box on
which I wanna show the duration of those two text box date.I want to calculate total days of those to date. Can anyone please provide me a solution?
here is my function
Public Shared Function GetData(ByVal strQuery As String) As DataTable Dim dt As New DataTable Dim cmd As New OracleCommand(strQuery, conn) cmd.CommandType = CommandType.Text Try conn.Open() da.SelectCommand = cmd da.Fill(dt) Catch ex As Exception Return dt Finally conn.Close() cmd.Dispose() da.Dispose() End Try Return dt End Function
here im calling above GetData function
Protected Sub ImageButton
I have 2 date columns as follows:
now based on the above 2 dates i need to create an sproc for generating the following table with the given validation
I am migration oracle tables to sql using SSIS. While doing this i am trying to use Derived column transfrom to convert Date format in oracle to sql. But i do not have any clue that how should i use this. In oracle side date is in mm/dd/yy format and in
sql i want that in yy/mm/dd format.
Please give me directions ASAP?
Thanks in advance
I am trying to calculate the number of hours between 2 date/time fields in a list form.
If I do this on a list view level with a calculated column, the column is not available for column summaries. Therefor I intend to use a regular number column and calculate the hours in an InfoPath form. Obviously the formula for calculated fields in list
columns will not work in InfoPath.
Addition: I tried DateField1-DateField2, but the result is NaN...
Is there any function to calculate number of business days in a month for a particular date. my input would be just a single date
I have a column called Conduct Date with 5 different dates for a single ID. for example my table structure is as follows
ID Conduct date
1 2010-01-31 00:00:00
1 2010-03-31 00:00:00
1 2010-09-30 00:00:00
1 2010-12-21 00:00:00
1 2010-10-30 00:00:00
Now i need to find the date difference between last two dates that have the maximum value. For example in the above case the dates to be taken for calculation are
2010-12-21 00:00:00 and 2010-10-30 00:00:00
Please let me know how to achieve this.
Thanks and regards,
I have an Excel file (which has data imported from Oracle 10G Database) one of the fields is a Date Filed which has values like 28-JAN-11 03.25.11.000000000 PM ( Date field is Oracle Time Stamp(6) in Database )
When I am trying to Import the same Excel file from another Oracle 10 G database (for another database/application), I get an error because the data field is not being recognized by Oracle 10G --> Import is being done by ORACLE SQL Developer (Table (field) has TIMESTAMP(6) as the datatype)
How can I import that field ?? For time being I made the TIMESTAMP to VARCHAR2 and its working but I could not convert that to Date field again in C# CODE ( it says not a valid date type).
When I am trying to Import that Excel file from another Oracle 10 G database (for another database/application), I get an error because the data field is not being recognized by Oracle 10G --> Import is being done by ORACLE SQL Developer (Table (field) has TIMESTAMP(6) as the datatype)