02-29-2008, 12:23 PM
Hi
1)I am entering the date in input pox and the passing the value to datepart function
mydate=inputbox("enter the date")/if i enter date as 29/29/29
datepart("d",mydate)/then it should display 29 as date and when i click ok it should display invalid date.but not workin
2)if i use the same for "date" its is workin
datepart("d'",date)//it displays properly.i mean the system date,as date is a key word
Clarification:Can u jus help me in telling wheater the way i am passing the value in 1 is wrong
1)I am entering the date in input pox and the passing the value to datepart function
mydate=inputbox("enter the date")/if i enter date as 29/29/29
datepart("d",mydate)/then it should display 29 as date and when i click ok it should display invalid date.but not workin
2)if i use the same for "date" its is workin
datepart("d'",date)//it displays properly.i mean the system date,as date is a key word
Clarification:Can u jus help me in telling wheater the way i am passing the value in 1 is wrong