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

Determining dates -

I want to purge files in a directory that are older than a certain date, say January 1, 2004. How do I do this in vbscript?

 

Determining dates -
I want to purge files in a directory that are older than a certain date, say January 1, 2004. How do I do this in vbscript?

How would I write this SQL statement -
Hi Well I am not too familiar with SQL statements, as im only getting family with simple ones such as UPDATE INSERT etc. Question Column 7 named 'Dates' contains all dates and times, which are stored from a process (which doesnt matter) Basically I have to combo boxes one w

better way to compare dates -
hi guys! can anybody please help me...i have the code below which compare two dates,datenow and the alarmdate, and show the alarm notification when they are equal but as you can notice the way of comparing dates is first Convert both dates ToShortDateString and compare it and when they

How many weekend days between 2 dates -
What would be the most effecient method of determining how many weekend days between 2 dates? Here are some examples: 1) A 3 would be returned for the following date range: Start date: 5/1/02 End date: 5/4/02 2) A 1 would be returned for the following date range: Start

query help with dates -
trying to do some booking system here. Basically I can retrieve a list of dates which are available for bookings, thats cool. But now from this list, if the user chooses a date, I want to be able to bring me back another list which contains all the dates UNTIL the next date is no

Determining a Bank Holiday (in the UK) -
Hi all, I'm developing a time sheet calculator that needs to know if the day is a bank holiday (in the uk) to determine the rate. is there any way to do this in vb besides having the dates saved in a db? any ideas thanks in advance! Jon

I need help... A loop i think.. -
I need a way to create dates. I want to be able to select 2 dates, say from 2 datepickers. Say the user select this two dates: 24.02.03 and 28.02.03. Could i make a loop that creates the dates between? It need to add one day at the time, until it gets to 28.02.03. And i want t

change dates formated as text to dates in excel from vb6 -
I have a spreadsheet with mixed dates and dates expressed in text. From VB6 I want to programtically convert all text dates to dates. I know it shoudl be simple ... Im just not getting it ... any help appreciated! Added [RESOLVED] to thread title and green &qu

Saving Dates (Help) -
Just wondering what the best way to do this would be. I have a MonthView calender which allows for dates to be set as highlighted for various purposes. I want to be able to save all the dates that have been highlighted and have them highlighted whenever i start the program (so basic

determining if gif is animated -
I am writing a program that will be dealing with several graphics types. What I am having trouble with at this point is determining if a .GIF is animated or not.

comparing dates -
hi guys. i was just wondering how you compare dates. what i wanted to do is to compare two dates and see which one is earlier. One o the dates is retrieved from the calendar control and the other date is in a text box. PLease help. thanks.

dates and disabling -
Hi. I have 2 datetime pickers, start and end dates dates will be shown when a user selects a month. now, when they change the month, I will be getting some datetime values from SQL, depending on the month they choose (or rather for each month they select) now, these dates fro

Determining the day when given the date -
Hello again, I'm trying to make a program that will picbox.Print the day someone was born. The user will enter their birthday as a mm-dd-yyyy in txtBirth and press a command button to print the day. Unfortunately, I have no experience whatsoever with using dates. Any help or tips/t

[2005] Old Dates -
I have some old formatted text files with dates. The dates are stored as "09,05,2002". Will the comma's matter if I try to read them as dates? Will the DatePicker control (or any others) choke on this format? If so, what do I need to do to fix it?

Best practice for working with dates -
I'm putting some code into my app for working with dates etc. now. Just wondering should I make sure that users enter dates in a particular format, or how should I deal with it ? I'll also be searching for dates etc. in recordsets, how should I construct the SELECT query for that ?

adding date fields to random access -
I am modifying a udt and adding new fields, some are for future use Havent worked with dates. I want to add 5 fields for billing dates and payments dates. Should these be added as strings or dates ? Public Type Myudt InvoiceDate1 as string * 15 or: InvoiceDate1 as date Payment

How to refer to previous fields in 2 different row -
HI there! I'm new in Crystal Report programming. I have a report that generates dates in rows. I would like to calculate the different between 2 dates. For example, I would like to calculate the different dates between 1st row and 2nd row, 2nd row and 3rd row etc. The dates are from A

query help - dates -
This query does not seem to quite work. I want to get results based between the year 2006-2007 from the month of 2006 to the month 8 of 2007. It only returns the 8'th month of 2006 it works well when the year is the same, just not when the years are different SELECT CONVERT(

filtering dates in vs 05 -
I want to filter dates in a vs 05 data grid using two txtboxes. So when the user types in the dates in the the textboxes it should return all of the results e.g. txtbox1.txt = 12/10/05 txtbox2.txt = 18/10/05 It should return all of the dates between the start date and finis

Determining administrator privileges -
Is there an API or some way of determining if the logged on user has administrative privileges in W2K/W98? I want to add the ability for an administrator to change the location of a database in an app rather than hardcoding it, which would mean recompiling and redistributing the app.

Date Ranges Problem........ -
hi, I need to find the dates between a range of dates...... eg: the dates are in dd/mm/yyyy format the user specifies 2 dates Date1:15/4/2003 Date2:20/4/2003 I want to retrieve the dates between Date1 and Date2.i.e. 15/4/2003,16/4/2003,17/4/2003,18/4/2003,19/4/2003,20

Determining a connection type -
How can I detect whether my system is connected to a network via LAN or via Modem using help of network adapter information. Is there a way of determining whether I have a wireless connection ( RAS, RNA etc) currently active ? I got some sample code in VB that uses a lot of APIs. But

International dates in VB and SQL -
I am having fun with international dates in VB and SQL. Can anyone give me some advice on dealing with international dates. It seems the best way is to use DateSerial in VB for storing the date. Its is the usual that it works on our system but not on the customers (maybe to do with the

Get number of weekdays between two dates. -
Hey guys, I was wondering if anyone had written a function that will return the number of work days between two dates. I figured this has been done many times, but I can't figure out how to go about it. For instance if I put in the dates 2008-04-19 and 2008-05-02 it would return t

determining the prime number -
help me pls...can I have the code in determining if the number that i have inputted is a prime number or not using a loop...thanks!!

Determining no selected items in a listview *resolved* -
I have two listviews, you can select one item between the two othem and I need to know how to determine which view has the selected item in. I can think of a round about way of determining (add a global variable that says which is selected with the itemclick event) but would rather kn

Problems with datetimepicker -
Hi to everyone plz help with me this dilemma: I have two datetime picker from which i select two different dates. now what i want is to calculate all the dates which r found in the range i selected previously and store them lets say in an array. now my windows application is connected

Problem with Date Range -
I'm bringing back dates from a database and want to compare those dates to see if they're between a range defined by two dtPickers. I've tried using >= and <= but it doesn't seem to work for dates. I was testing to see if the dates were equal and that worked fine, although it may

sql dates -
Hi all. i have a field dates with values in this date format. dd-mm-yyyy is it possible to sort the records by the dates field of the table? i can't seem to achieve the sort i want with "order by dates desc" thanks

Calendar Coded List Box -
Hi: I have an Access Database in which I created a form. The form has a calendar (which shows three months at a time), a date bar (which showed the date(s) picked), and a list box (which shows the date, customer name, city, maintenance date). All the sync codes I've entered work

find dates between to given dates -
hi is there any way to find dates between to given dates. ie, suppose it is given 01-01-2006 and 04-01-2006 (in dd-mm-yyyy format), want to print the dates from 01-01-2006 to 04-01-2006.

Dateproofing my app -
I'm having some problems with my app, and I cant seem to get a handle on the best way to deal with it. The problem relates to the date formats, dd/mm/yy vs mm/dd/yy. I'm saving the dates to an access database, and will be perforning calculations on the dates (eg. 14 days from tod

Finding # of months between two dates -
Good Morning folks, I have two dates. I need to know number of months between these two dates. The dates always start on 1st of every month. example: date1: 02/01/2008 , date2: 12/01/2005. how to calculate the # of months between date1 and date2? thanks nath

setting a date range -
I'm trying to get a range of dates from one sheet to populate into another sheet. One sheet has dates written as example 02/05/05. In my source sheet I have one of two dates for every month either the 16 or the 31. written as 7/31/05. The date in my source because it is already exs

Compare dates from db to current date -
I have a problem. I retrieve some dates from a database in the format dd/mm/yyyy. These dates are stored in the database. what i want is to compare the date that i retrieved, to the current one, calculating the days between the two dates. afterward i want to place this in a column i

SQL to search a database for results between 2 dates -
I am trying to write an sql that will take 2 dates from a drop down date picker box and perform an sql on a database to bring back the data logged between the dates. Can anyone help?

Determining memory size.... -
Is there a way of determining how many bytes of memory you are using for an object or image or control, etc.. programmatically? Say I had an image that I loaded and had it's .hdc. Is there some way to use varptr() or something to find its location in memory and then determine how m

Holidays -
Hi Everyone, I currently have an array that is filled with holiday dates. This works great for the current year since I have all of the dates listed, but how can I figure out the holiday dates dynamically through code for years into the future? I would appreciate any help. Thanks

VBA Question on Date's in Excel -
Is it possible to write a code that will look at a range of cells that have dates, and if the dates are 60 days old they will be highlighted like that in the conditional formating. I am currently looking through some code I have that work with dates, I have not come across something

Casting Dates and Chars -
Hello, I have a column of dates in nvarchar format . The dates are structured in dd/mm/yyyy I use the following query - SELECT *, CAST(datestr AS datetime) AS Expr1 FROM test This puts the nvarchars in datetime format , but they are now in the format mm/dd/yyyy Does