Hi!
i just want to ask how to manipulate Time and Date... suppose I have
tiMe in 1:30pm. and TIme OUt 2:15... and i want to get the tiMe between 2:15 and 1:30..
SUppose i have Date 1 = Sept 16, 2007 and Date 2 = maRch 12, 2008 and i want to get the number of days between those dateS..
what Codes Should I Use?? i need it this week because it's part of our CAseStudy in Our School! thanKs!
Hey
I have remember another function try these too these are easy
******************************
DateADD()
Date addfunction is used to add or subtract from a date. It has three parameters.
1) Part of date to be added or subtracted
2) Amount to be added or subtracted
3) Only valid date to be processed
D="01/22/2003"
print dateadd("yyyy",5,D)
it add 5 years
yyyy Add or subtract years
m Add or subtract months
d Add or subtract days
h Add or subtract hours
n Add or subtract minutes
s Add or subtract seconds
*********************
DateDiff()
It is used to find the differeence between two dates.
It has also three parameters.
1) Indicates the format for displaying the diff
2) Second and third are only valid dates on which the process will be applied
D1="01/22/2003"
D2="01/22/2004"
print datediff("yyyy",D1,D2)
it will show 365
********************************