I am using CR 10 with a SQL database and I have a field that I am trying to take any time that was recorded before 9am and display the same date and adjust the time to 9am.
I thought I would be able to use an IF THEN statment but CR tells me that I not only need time, but a date too. What I had was this.
IF {Cases.createDate} < "0900" then "0900"
I want it to keep my same date. Does this make sense?
I thought I would be able to use an IF THEN statment but CR tells me that I not only need time, but a date too. What I had was this.
IF {Cases.createDate} < "0900" then "0900"
I want it to keep my same date. Does this make sense?