i have data likes this
post_month post_ year
january 2006
.
.
december 2006
january 2007
february 2007
i need to write a query to display as follows
january2006
.
.
december2006
january2007
february2007
I have a form and I request a date. I want the slashes(02/25/2005) to auto fill in the form. Can this be done? How?
View Replies View RelatedHow can I get the following date field to display as month and year only like "January 2004" ?
<%=(rsTitles.Fields.Item("Datte").Value)%>
Here's what I have thus far:
<% =month(now) %> <% =year(now) %>
How can this be modified so that it, for this month, it would read:
August 2005
Also, how can I make certain there is a space between the month and the year without using a ?
How can I retrieve all the records from the database having the following parameter:
in form, these are the fields to be entered:
month (it's a select option)
year
Then from the database the field objrs("strDate")
Scenario: User entered the ff:
month = January (with the value 1)
year = 2004
if in the database the input for the strDate field is having this format: 1/2/2004
How can I retrieve all data for January?
I have a date field in an MS Access database. I need to sort this field and print the results to an ASP page. I have done this plenty of times before except this time the date field data includes BCE data. A sample of the data in the date field is as follows:
1300 BCE
930 BCE
November 29, 1947
May 14, 1948
1465 CE
October 29, 1956
1020 BCE
I know that I can not have the data type of the MS Access field set to date/time. I searched online and didn't find too much.
I have an access db with 5 years worth of articles. I need to be able to list them according to year from a query string. I am having no luck with this. Can anyone help. SQL is not one of my strong points.
vyear = Request.QueryString("year")
strSQL = "SELECT * FROM tablename WHERE "& DatePart("yyyy", article_date) &"="& vyear &" ORDER BY article_date desc"
I have tried this a few different ways with no luck at all. I keep getting errors.
I have a date field in an MS Access database. I need to sort this field and print the results to an ASP page. I have done this plenty of times before except this time the date field data includes BCE data. A sample of the data in the date field is as follows:
1300 BCE
930 BCE
November 29, 1947
May 14, 1948
1465 CE
October 29, 1956
1020 BCE
I know that I can not have the data type of the MS Access field set to date/time. I searched online and didn't find too much.
is there a way to calculate the month from a week number and year?
View Replies View RelatedI want to display a series of records grouped by nested years and months, e.g.:
2004
December
Record1
Record2
Record3
November
Record4
Record5
...
...
2003
This would be based off of a date value stored with each item in the
recordset.
Does someone have a snip of nested looping script to break this down by
date in this manner? Code:
I have a form which allows a user to select a 'commencement date' using separate day, month and year drop downs. The date is then submitted to db in DDMMYYYY format(as required).
I now need to allow user to edit this date if they need to. So, I retrieve the date from db as ie. 30101968. I now need to place the first 2 digits (30) into strDay, second 2 digits into strMonth and last 4 into strYears so that I can reflect these values in the their relevant drop downs.
Does anyone know how to 'grab' those specific values?
I have an Access "date/time" column and I am trying to use SQL to select by month. I thought the code below would work (to query for records in april for example) but I am still getting all the records regardless of when the date is.
SELECT *
FROM comm
WHERE comm_requested_date = month(4)
Basically, I have a drop menu with the months and I want to query the DB for all records for a particular month.
I m having two combobox on my page cmbyear(years) and cmbmon(months). i want to make a check that if year selected is current year then selected month should not be greater than current month. how we can achieve this.
one way out is that we can store values of selected options in two variables in javascript function. In the function we can make the check that if selected value for year is current year and selected value for month is greater than current month then it ll show some error message and reload the page.
i m trying this but do not get results. May be i m having some mistake in syntax. can anyone tell me how to get selected value in a variable in javascript or some other way out to achieve this. I have applied same technique on text box value. its working fine. but with combobox. i dont know whats the prob.
I need a date simple date function that would append the coming month value in my current month ...
View Replies View RelatedHow to convert a month to previous month in a very easy way?For example, I have AUGUST, but I want JULY to return.
View Replies View RelatedI want to be able to format a year as mm/dd/yy
formatdatetime does not work because the year is yyyy. How do I format a 2 digit year such as 04 for 2004?
I have an sqlstatement which is executing on my form it works fine in sql server enterprise manager but obviously the function that is used in sql server enterprise manager will not work on a form i am coding with asp...my sql statement is as follows
Sholiday.source = "Select * from Year WHERE Year= IsDate(Year) order by bhdate"
this doesnt work fine, because i would like that the Year that my sqlstatement picks up to be equal to the current year we are in..can anyone tell me what the function for that is in vbscript... i am using vbscript and asp..
Basically what im trying to do is create a dynamic drop down box that changes its output each year.
It is a drop down box that displays years, but i need it to be always a minimum of 18 years minimum from the current year e.g as its 2004, it needs to display 1986 as its minimum year and upwards to 40 years from 2004, because the type of people im looking for need to be over 18, and no more than 40... And this is within a form, so the users choice of years is collected on submit.
I have a set of values like name,age,desg,salary,year etc . currently i am getting the values using max(year) and displaying the values year is integer in my sqlserver db
If you go thru my code (see attachment) you would be able to understand.
Now the problem is if a person gets promoted or hike in his salary i have to display two differnt salary on the same year how do i do that. currently i am displaying the values based on the max(year) max(year)-1 etc. i cannot modify the database. i have to do some changes on my coding only. Please view my coding as attachment (3000.txt).
For example
Name Age Desig Salary Year
abc 35 CEO 39000 2004
abc 35 CFO 38000 2003
abc 35 CTO 37000 2002
abc 35 CTO 35000 2001
abc 35 Direcotr30000 2001
How do i display this from the database.
I have a set of values like name,age,desg,salary,year etc
currently i am getting the values using max(year) and displaying the values year is integer in my sqlserver db If you go thru my code (see attachment) you would be able to understand.
Now the problem is if a person gets promoted or hike in his salary i have to display two differnt salary on the same year how do i do that. currently i am displaying the values based on the max(year) max(year)-1 etc. i cannot modify the database. i have to do some changes on my coding only. Code:
Can someone please tell me how to add a year to the following date field from a SQL Server Database:
DatePaid = rs("DatePaid") & ""
I tried something like:
DateExpires = DatePaid + 1.
It certainly didn't work.
i wan to do a page at the backend,when the date is end of this year(12/31/2007) then will execute the code (such as add the new total leave with the current balance leave automatically without regresh the page or login into the system.)
i heard that the MS SQL SERVER got this triggered function, but unfortunately..the MS SQL SERVER hosting that i used(third party) didnt provide this function. i jz can store data in the table and create database..no more others component that i can use.
How can I select only articles from the current year? I have a datestamp column and the date it stored like this: 2004-06-18 00:00:00.000
The time is always all zeros so I have been having problems with it.
Im working on a Year(Date) function right now, the output of that function is this "2005", my question is how can i change the format into this "05"
Function: Year(Date)
Output: 2005
Needed Output: 05
I need to make a countdown to the year 2004. I want it to have days, seconds, minutes, hours, etc.
The only problem is that my server is 3 hours faster than my time, and I need to adjust it in the script somehow, and also please give me the script for the actual countdown.
I have an Access table with (among others) a number type field.
I'm building a web form which will add a new record to the same table. My problem is as follows:
I need to retrieve the (number) value from the previous record and increase it by 1 when submitting the new record. Also, this number should reset to 1 whenever a new year occurs.
Was that clear?
If I keep a hard sql statment to show all records from 1 to 31 of each month
will get error on months where there are no 31 days, how can i know the last
day of the month ? any sql function or just via programming language? Using
ASP and Sql Server 2005!
What you suggest ? Code:
I have the following for the header in my table which should display "November", "December", "January" but instead I'm getting "November", "January", "December". Is it possible to do it like below or will I need to incorporate year in some way to that when it gets to these last months in a year it will know start back at January?
Code:
<%
DIM iMonth
iMonth = Month(now)
For x = 1 to 3
intMonth = Month(iMonth)
Response.Write("<td align=center colwidth=""50""><b>" & MonthName(iMonth) & "</b></td>")
iMonth = Month(iMonth)
Next
%>
How will I get the last day of a given month and a year ?
View Replies View Relateda quick and dirty way to get the last day of the month?
View Replies View RelatedI am wanting to retrieve the current date and submit to db in DDMMYYYY format. I have got it working but am now worried that if the month was January, that the value returned would be 2812003 and not 28012003.
Can anyone confirm that the below code will return 01(January) etc for the month instead of 1?
Dim DateToday
DateToday = Day(Date()) & Month(Date()) & Year(Date())
Response.Write DateToday
(The above returns 28102003, which is what I want).
I want to know how to get the last month value. I used the Month(Now) to get this month, but how can i get the previous month?
View Replies View RelatedI need writing a SQL select statement. I know this one has to be simple, but I can't seem to get the query right. I need one query to select where the date range falls within the last 24 months, and a second query for data that's older.
View Replies View Related