Re: HELP!! with usage of datetime in ace
Posted in 1993
amr malik,
You need to specify a little more information. But if ace is bombing when you
enter your datetime value into your datetime variable, chances are you are
entering an incorrect datetime format. The follwing sample ace report works
when given input in the format HH:MM . This format uses a 24 hour clock (no
am's or pm's). The following inputs are valid: 09:30, 9:30, 13:46, etc.
database vth end
define
variable p_time interval hour to minute
end
input
prompt for p_time using "Time (HH:MM): "
end
select *
from species
end
format every row end
Hope this helps.... If not provide a little more information (what does your
code look like and what does your input look like) and we'll try again.
Cathy
+-------------------------------+----------------------------------------+
| Cathy Kipp | Internet: ckipp@vth1.vth.colostate.edu |
| Veterinary Teaching Hospital | |
| Colorado State University | Voice: (303) 491-1294 |
| Fort Collins, CO 80523 | Fax: (303) 491-1205 |
+-------------------------------+----------------------------------------+