o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

problems with Date function -

If I do this in ASP
response.write Date
I get the date returned.
If i do this
response.write Date-1
I get the date 1 day before.
If I do thedate=date+3, this works but if I hard code a date or in my case I'm using request.form to send a date from a database to another asp page to create a discount table.
I get the date I send in the forrmat 06/16/02 but when I try to add or subtract an integer value I get nothing back.

ex. thedate=02/15/02
or thedate="#"&02/15/02&"#"
thedate=thedate-1 will return nothing.
I've tried all kinds of formatting to no avail.
Why will it work as date+2 but not as thedate+2?

 

problems with Date function -
If I do this in ASP response.write Date I get the date returned. If i do this response.write Date-1 I get the date 1 day before. If I do thedate=date+3, this works but if I hard code a date or in my case I'm using request.form to send a date from a database to another asp page to

Access Date() function works on his machine but not mine -
Hi Folks Im getting a "unknown function 'date' in validation expression or default value" when using a date() function in a field. My mate who created the database has no problems on his nt workstation or his win 2k laptop. Im getting this error when I try to create a new

A few VB Issues (Debugging) -
Hi, I am having problems with VB 6. One is the Date function; all it displays in the txtdate is Date, when i want it to be the system Date. txtDate = date is the code i have. Another debugging problem is the Extra's section. When i try and click on the extras tick boxes i ge

Date problems -
I got a variable startDate as Date datatypes. the function argument is in this format date(YYYY,MM,DD) 1. How can I put my variables date(startDate)? how can I manipulate startdate variables to fit those format????

Date In functions doesnt work all the time -
I have created a function to calculate the maximum value from a grouping in an access report that is dependant on certain criteria. the function has 2 variables passed to it from the relevant group on the report - date and code. the report works as planned until it reaches a particular

some date problems -
VB.NET 05 --- (1) --- to get todays date is: "now.date" how do i get tomorrows date? --- (2) --- also how do i get the month or weekday of the date say i got dim x as new date(2,11,2007) is there a function that returns "Thursday" and "Februrary"?

Dates !!! -
Hi, I am having problems in transferring dates to the Database. I am using a MaskEdBox for data entry. When i try to insert the date into the DataBase it throws me an error. I tried using the Cdate function to convert it into a date. Doesnt work. The other porblem ive been having i

DATE problems - change date format to European, get current date, subtract 2 dates -
Need someone to point me in the right direction/start me off with this please as I am quite clueless on it at present... I need something that can successfully subtract two dates... eg. calculate the difference between the current date 02/04/04 (2nd April 04) and 29/03/04

date validation...... -
Hi, I need to validate the date. Im using drop down boxes for users to select the date. I need to make sure that they're selecting a valid date. Is there any function (like isDate() in vbscript) in Javascript? or will I have to write my own function?? Thanx.

VB6 String character and Date function -
Hello every1, am a VB6 beginner and need you help in a simple matter. There is a string and i want to be able to check every letter of it to see if its a particular alphabet for ex. i want to check which letter in the word "apple" is "l".. in this case its 4th. I do

date (MM/DD/YY & DD/MM/YY) -
hai everyone.... i have problem with the date.i use active x contol calendar to ask user insert the date.it follow the client computer that is MM/DD/YY but i also using some date function.it's formula is reverse from active x control-DD/MM/YY.it give big problem to me when i want

Date Formatting Problems -
Hi! When I use the Format() function in VB5, it usually formats the date correctly. However, for some dates, it gets it all messed up, switching the day, month, and year around. How can I fix this?

[2005] validating date strings -
Hi Bit of a newbie question I'm afraid. My application currently uses datetimepicker controls, but because these can't show blank dates when no date is present/needed, my users (bless 'em!) want to go back to a free format text field for entering dates. Whilst I'm reluctant to

Problem using date function -
Why the Date function is not working in the following function? Private Sub Form_Load() var_date = Date 'get the current date var_date = FormatDateTime(var_date, 2) lblDate.Caption = var_date End Sub Every time I am getting an error message saying: "Compile error:

Getting Current Date in VBScript -
How do I correctly check the current date against a preset date in the future and based on that call this function EarlyPrice or the other function RegPrice? Here is what I have: Dim MyDate Mydate = Date ' will return system date If MyDate <= ' the rest is a clue to me!

Date Problems in Microsoft Development Software -
As I recall MS has changed their date calculation several times over the last 20 or so years. I am referring to the earliest date possible. For whatever reason I couldn't locate in MSDN. I need to deal with daily records from 1900 to today. QUESTIONS: 1) Anyone know what t

Problems in formatting date ... -
Hello to all Forum Members! I've a rather very simple issue but I'm not able to find a solution for it. I'm currently working on an Application which deals with XML data. One of the node attributes return a date value which is obviously returned as String by MS XML. Now, I need to f

Does anyone have a date formatting function -
I'm looking for a date formatting function that will format a date into mm/dd/yyyy format... I'm not asking for anyone to code one (as it would probably take some time) but if you have one lying around in the endless piles of code I wrote one that will format a date accordingly..

How can i use the date function! please help Simple question -
I am trying to calculate age against the current date but i dont know how to use the date function in the correct syntax help me please

How do define a Date Field only in SQL Server -
I have a SQL Server 2005 DB. I have a table in which a date value is stored in the following format: 1/30/2008 or 12/25/2007. It's defined as a varchar(10) but this is causing me problems in my application. How can I define this field as a date type and only populate it with a date suc

My date format vs user's date setting -
Hello ppl I have to use date in my application which I have set to be short date (mm/dd/yy). This application communicates with an Access 2000 database. In many cases users of applicaiton willl have different setting (Regional setting of date in their Windows), for example they can

Date Problems -
Hi Guys I got a date field with date like 10/25/2005. I need to run an exception query to determine all data not updated for the last 3 days Example I got a record dated 10/25/2005 Todays date is 10/28/2005 When I run this query it must bring up all records with date

Where does the date in DATE() come from -
I have an app that uses the date function, but I need to know where VB gets this date from? Is it from the local computer or the SQL server or the primary domain controller? The reason why I am asking this is because I am using the date as part of a time clock system (ie, clocking of

Changing of Date Format -
Dear Friends, In VB whenever date function is called it formats the date as in system. That means i want to say that if the user input is as "01.03.2007" and in the system it is specified as mm/dd/yyyy, after any date function called say DateSerial() ,the date format chan

Check for valid date format -
I'm using VBScript in an ASP environment and I have a form field that a user inputs a date they want to search on. I need the date in the format (MM/DD/YYYY) which is what the regional settings is set at. You can not do a mask on the field (not allowed by html). What I have done so f

this time stuff is hard!!! -
I am using the following function... Private dtTimediff As Date Private dtTime1 As Date Private dttime2 As Date Private iHoursDiff As Integer dtTime1 = TimeValue(Combo1(0).Text) dttime2 = TimeValue(Combo1(1).Text) dtTimediff = dtTime1 - dttime2 iHour

Help with a date function -
I need a date function that always show current date 5 days backwards. Ex: If the date is 2005-06-15 the function should show date 2005-06-10. How do I do that?

Finding out if it has been 30 days since a certain date. -
I have a database that store a users signup date, it is format as MM/DD/YYYY. I want to take that date and find out if it has been a month since they have signed up so I can activate their account. Is this possible with built in function or has someone written a function to do this pro

Function to show last day of month -
Hi all Am trying to write basic function to show date of last month...either today or a date I supply. If I supply a date it works fine but making it oprional is not working for me...... Could someone put me out of my misery cheers George Function LastMth(Optional myDate

XML/RSS last build into date variable -
Anyone have a simple way to put an XML/RSS <lastbuild> date into a standard date based variable. My issue is that there is no strict standard for the <lastbuild> date format, so I'd like to be able to use an API or built-in VB function to get a date/time that I can calc

Problem with Date format in VB with SQL -
In SQL server ... it takes only this format of date : yyyy:dd:mm hh:mm:ss But in VB, I would like to give the date in this format : dd:mm:yy I can successfully store the date ... but while retreiving it from the DB .. I am facin format problems... Can somebody help me .. ple

A little VBA help - Random Date -
Hi, I made a small Access DB that has a Date field in it (DUEDATE). The DB is used for demonstration purposes to show current orders. I need a function that would randomly update the orders due date in the table (orders). I would like to input a starting date and a range (30,60,

VBS date format vs. SQL Server -
Hi guys, I need to create a record in a SQL server table whose key field is defined as a datetime. When I use VBS' function DATE() to retreive the current server date, it's retreived in the dd/mm/yy format whereas I would like to have it in the yyyy-mm-dd format. I'm aware of

Check the string if it is Date or not -
Hai My system date format is dd/mm/yyy. When i input a date 13/03/2006 in a text box.if i checked this using ISDATE function it show that the date is invalid.In vb.net it take mm/dd/yyy. How can i solve this

RESOLVED - Manipulate dates -
I need a function that will give me the date exactly 6 weeks before the date the user inputs. I have only used eg "Text1.Text = Date" so I have a very limited knowledge of this function. I am using the format dd/mm/yy Thank you aikidokid

Need help with a date function -
I'm trying to write a function in VB6 that will give me the previous Sunday's date. I will be using this on a website with asp and would like to be able to do the following. Return last Sundays date and place it in a variable (the date would need to be formatted as follows without

current system date and time -
I have two date fields in my code: Dim dateOfIssue As Date Dim dateOfReturn As Date when i printed the value of date, it gave 12:00:00 AM. I want to get the date in the format MM-DD-yy. Plz help me. I want to add n no of days to this date to get the dateOfReturn. Plz let me

Generating Unique Values -
We currently use a function that is supposed to generate absolutely unique values for each document scanned for each workstation. We base it off of a specific date/time in the past and calculate the number of milliseconds until the current system/date and time. Then we take that numb

question about date -
I'm having problems making sure the date appears on my payroll form. I am not sure what the easiest way to do this is, but I used dtpicker and then set its value to = Date. I also used the value property of the dtpicker but I could not find a way to automatically update it every tim

DTPicker Issue -
Morning all. I'm still having an issue with the DTPicker control. I am loading a recordset into a flex, and setting the date of the control to be the same as on the records being retrieved. It does this OK, but the top part of the control (where the date is displayed) is sho