Search results for query: *

ShiftDate is a date field starttime is a number field endtime is a number field. So I started to use the formula to convert the number into time. which worked. numbervar x := tonumber({table.starttime}); time(truncate(x),round(remainder(x,truncate(x))*60),0) Than I tried to add the formula to...

Actualy I think the error is coming because it does not recoginze the time as a time. You helped me before to convert the number to a time. http://www.tek-tips.com/viewthread.cfm?qid=1327220&page=1 Now it will not take the time

This is what I tried but it didn't work datetime(date({table.date}),time({table.time})) It only returned records that the time is 12:00 PM. So it was unable to add the records. The rest of the records were coming back false

Hi, I have a field that is a date field for example 1/6/2007 12:00 PM and I have another field that is just a time field 3:00 PM. Can I add the time field to the date field to get 1/6/2007 3:00 PM? Thanks

thanks that worked

Thanks it almost worked I needed to add an if statement becasue I have null values. The other problem I have is that its giving me an error if the decimal is more than 4 numbers. How do trucate the decimal?

Hello, I'm trying to take a text field and add it to the date. The text field is the 7.5 = 7:30 am and 19.5 = 7:30pm. I tried a couple of formulas but nothing worked. I was able to do it in sql but unsure how to do it crystal. Any suggestions would be appreciated. Thanks