Thanks dude
vikash
Thanks dude
vikash
vikash
Try the following solutions: 1) use the abbreviations 'd' OR 'dd' inplace of day in your syntax. 2) Check out your table. Are you storing your data alongiwth the time in the database. If yes then this query will never return any result Thanks, Vikash Kumar Singh
vikash