23 Topics

Member Avatar for
Member Avatar for nish123

jst a small Query..!! . . How to convert string to Date format.. So tht i can get result from database..!!! $date = "mm/dd/yy"; i want in yy-mm-dd format...!!! which function is used for it.!! . . waiting for positive reply..!!

Member Avatar for Aswad_1
1
8K
Member Avatar for Ritesh_4

Hello I have a web form, whereby I want to allow users to only input dates in the format DD/MM/YYYY. I've tried with the following code to show an error message if the date is not valid, however if I add something like 5/5/5, it still passes is as a …

0
106
Member Avatar for moodyR

Write a class Date which consists of: Member variables: day, month, and year Member function DaysSinceFirstJan1() which returns the total number of days since 01-Jan-0001. Now write a main function which asks the user to enter 5 dates (day, month, year) which are stored in an array of objects of …

Member Avatar for ddanbe
0
223
Member Avatar for saraazee

Can any one tell me the php code to retrieve data from database by month and year. it should be displayed all details of the table according to the selected month and date. i need php code and the database.

Member Avatar for diafol
0
251
Member Avatar for deceptikon

## Disclaimer ## Full disclosure, this is a problem I've recently encountered at work. I couldn't find a reasonable solution and ended up recommending a logistics approach rather than a full code approach to solve it. The code performs a subset of required functionality to give users more options, but …

Member Avatar for ddanbe
1
577
Member Avatar for patk570

I have 2 input fields that when a user inputs the date in say mm-dd-yyyy format, i would like to have it automatically change to yyyy-mm-dd (ISO 8601 Date Format) the input fields are very simple: <div class="form-group"> <label for="purchase_date">Purchase Date <font size="-3">(Year-MM-DD) format</font></label> <input type="text" name="purchase_date" class="form-control" placeholder="Purchase Date"> …

0
136
Member Avatar for airhalynn101

I have this line of code which gets the activation date of an agent and computes the difference between date.now to get the date difference: Dim dt As New DataTable dt = ExecQuery("select agtid,Activation from tblagentinfo") If dt.Rows.Count > 0 Then Dim activation As String For i As Integer = …

Member Avatar for airhalynn101
0
6K
Member Avatar for TheFearful

I am new to Java and am experimenting with the language. I am looking a way to convert a user-inputted date and convert it to the MSexcel format. So 1998/07/05 is 35981. Any clue on how to do this? This is what I have so far import java.util.*; import java.text.*; …

Member Avatar for TheFearful
0
221
Member Avatar for Priti_P

I have formatted a string date into date format by using <script type="text/javascript"> var st = "26-04-2013"; var pattern = /(\d{2})\-(\d{2})-(\d{4})/; var dt = new Date(st.replace(pattern,'$3-$2-$1')); alert(dt); </script> and it's output is `Fri Apr 26 2013 05:30:00 GMT+0530 (IST)` but I want out put as `2013-04-26` how can i do …

Member Avatar for Priti_P
0
240
Member Avatar for Alonso_1

Hey there. I'm trying to retrieve a date from an SQL table. The original formate of the date is as follows: 0000-00-00 00:00:00 I want to try and change the format into: Month Date, Year e.g. May 17, 2014 <?php $page_title = 'View the current users'; include('header.inc'); require_once('mysql_connect.php'); try{ $query …

Member Avatar for Alonso_1
0
209
Member Avatar for Phillip_1

I am trying to add a Mysql Report to Reporting Server. I can call the stored proc and all the info appart from the date will show. So i was wondering if there was a way to do convert the date in mysql

0
79
Member Avatar for Phillip_1

I am currently trying to link a mysql Stored Procedure to a Microsoft SQL Reporting Server. It is coming up with a Syntax error. I believe this is down to the Date_from and Date_to Parameters. The query is below any help would be appreciated DELIMITER $$ USE `mydb`$$ DROP PROCEDURE …

0
104
Member Avatar for Triple_7

How do you display the week ending date (Sunday) in VB10? When a form loads, I want to display the upcoming Sunday date in a label. In VB6 I used the following code and it worked fine. Private Sub Form_Load() ' Set Default "Week Ending" Date lblWkEndDate.Caption = (Date + …

Member Avatar for cgeier
0
153
Member Avatar for chaitu11

how to find number of days(days ago)different between today and database date .. eg: difference between 04/09/2014 and 06/08/2014 =(no of days ago)

Member Avatar for diafol
0
318
Member Avatar for chocolatte.lavista_1

how to display last login date? for an example, we log in to the system on 11 april 2014. then, log out. when we log in back the system on other day, for an example 26 april 2014, it will display back where the last date that we were log …

Member Avatar for GliderPilot
0
224
Member Avatar for chris.immanuel

Hi Guys, I need help with inserting date from HTML <input type="date"/> into oracle DB It seems that i need to make some kind of adjustment with oracle date. please help me...

0
89
Member Avatar for mark103

Hi all, I need your help with my PHP, I'm working on the date and time format especially the year, month, day date, hours, minutes and seconds. I have got a little problem with the day date. Most of the day date are correct, but some of them are not …

Member Avatar for diafol
0
281
Member Avatar for centenond

Im a little confuse with this particular function 'date()' Its a serverside time or it takes the time of the client computer? See its shows a time that in anymeans is my current time but still when i change my pc time it also change

Member Avatar for PsychicTide
0
233
Member Avatar for krunal1986

Hello, I need to display last released version date in my application. I am displaying last build/compiled date as version date with below code. DateTime buildDate = new FileInfo(Assembly.GetExecutingAssembly().Location).LastWriteTime; lbldate.Text = buildDate.Date.ToString("dd/MM/yyyy"); but if I update the live server with latest code other than today, then it is displaying the …

Member Avatar for pritaeas
0
296
Member Avatar for Nollyvenon

I have a query which i am trying to get the last date and when i do, the purchdate and LastPayDate is the same for all the data. the query is below: SELECT DISTINCT customer.custid,customer.compname,customer.balance AS balance,customer.phone,acctofficer.acctfullname AS acctoff, preAgg1.LastPayDate,customer.depot, MAX(mastorders.lastsuppdate) AS purchdate, MAX(mastorders.id) FROM customer,mastorders,acctofficer, (SELECT DISTINCT T.custid, Max(T.timestamp) …

Member Avatar for Fernando_4
0
264
Member Avatar for Zulu79

This is my code, and thoughs on this error: Conversion from string "MM/yyyy" to type 'Date' is not validerror: Public Function AddNextMonthDue(ByRef OldNMD As String, ByRef MonthsToAdd As String) As String Dim dOldNMD As Date Dim dNewNMD As Date Dim sOldNMD As String If Len(OldNMD) = 4 Then ' MMDD …

Member Avatar for Reverend Jim
0
247
Member Avatar for hiiiiii@

hi im doing a project on online booking ..if the user enter the date i need to check weather the date and time is available to book.

0
78
Member Avatar for jonow

Hi, I was wondering how you keep a navigation menu up-to-date on a 200 page website. When I first started using HTML I used an iframe which it is a [I]terrible[/I] idea. Now i am using PHP (im using include). But i am guessing this is also very inefficient. SO …

Member Avatar for codejoust
0
137

The End.