Date format YYYY/MM/DD 1

[Periko]

Hi,

I have to compare a databasefield stored as YYYY/MM/DD with the current date.

So I want to have my current date (in a variable) transformed to YYYY/MM/DD.

Is this possible in ASP ?

Thx in advance

Pedro

"Live is Music

 

[Periko]

just one word extra.
In visual basic i used to type : cdate = format(now, "yyyy/mm/dd). This seems not to work in asp.

Has anybody an idea ?

Pedro...

 

[TheCount]

Use the datediff() function.
See at Microsoft MSDN.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vsfctdatediff.asp

 

[Genimuse]

You can flip a date around with something like (you can make it slightly shorter, but I just want to make each step clear):

'assumes "YourDate" is the date you want to convert

Dim strYear, strMonth, strDay, strNewDate

strYear = Year(YourDate)

If Month(YourDate) < 10 Then
    strMonth = "0" & Month(YourDate)
Else
    strMonth = Month(YourDate)
End If

If Day(YourDate) < 10 Then
    strDay = "0" & Day(YourDate)
Else
    strDay = Day(YourDate)
End If

strNewDate = strYear & "/" & strMonth & "/" & strDay