I have a date 01-12-2000 in the database..
I want a function to change it to 01-12-2006..

ie, wanted to split dd-mm-yyyy into dd-mm and yyyy
and concatinate it with yyyy' to get dd-mm-yyyy'

Please help me if you know how to do this...

What do you wish to do, change all references to 01-12-2000 to 01-12-2006 or to add six years to all the dates? A different reply would hold for each case.

Rand

This function should do it:
<%

FUNCTION tweakDate(varDate,yearVal)
   IF isNull(varDate) OR Trim(varDate) = "" OR varDate = "Null" THEN
      tweakDate = "Null"
   ELSE
      tweakDate = "" & day(DateValue(varDate)) & "/" & month(DateValue(varDate)) & "/" & yearVal
   END IF
END FUNCTION

response.write tweakdate(date(),"2006")

%>


Wind is your friend
Matt

mmmm, re-reading your post I think you need to replace:

response.write tweakdate(date(),"2006")

with

response.write tweakdate([your database date value],"2006")


Wind is your friend
Matt

agggggh Im not with it today. I have used a / as a seperator you wish for a -

I assume you can make this simple change?

Wind is your friend
Matt

Matt, this is a SQL Language Forum.. your solution does not look mutch like SQL ;)

Gert

I got it, if anybody like to know see the function below..

 date(rtrim(char(month(input_date)))||'/'||rtrim(char(day(input_date)))||'/'||char(new_year))


if input_date = 31/01/2000
and new_year = 2006

then output will be 2006/01/31(with data type DATE)

Thanks to all who responded..
:)

Gert - where do you think you use this funtion? Inside an sql statement - what are you on about?

EG:

sql = "SELECT dateValue,...,..;"
set getdateValue = conn.execute(sql)

sql = "UPDATE tbleName SET dateValue = '" & tweakdate(getdateValue(0),"2006")
 & '" where ID=[someID]

Do you dis agree? or do you reckon I should stick to the ASP area, youve got a cheek...


Kunjan:
You asked for:
;;and concatinate it with yyyy' to get dd-mm-yyyy'

Now you say:
;;;then output will be 2006/01/31(with data type DATE)
You never asked for yyyy/dd/mm


Over n out


Wind is your friend
Matt

Matt - no need to be upset (tried to keep it in a light tone with the smiley..), and I'm afraid I don't understand what the phrase "youve got a cheek" is supposed to mean..

I just thought that since Kunjan didn't mention anything about a programming language, and since he made the post in a SQL forum, then he might needed something to work in SQL, not ASP. But since I am most familiar with SQL Server, your solution might be for some other SQL-language for all I know. In that case, I apologize.



Gert

Not up set and yes I did see the smiley.

You are correct maybe he is not using ASP. If so my VBScript function may be of no use. No need to apologize - re reading the post, yes, i may have been a bit abrupt - sorry bout that.
Have a nice day.

Wind is your friend
Matt