on 03-08-2017 7:43 PM
So I'm trying to filter my report to only show yesterday's date, I go to the formula editor and type:
{TimeTicketDet.TicketDate} = CurrentDate -1
Which results in the following error message "A string is required here"
So if I substitute CurrentDate for say "03/07/17", it works fine, but that's useless to me. I'd also like to be able to get last weeks results only (Mon thru Sat) and the current week thru yesterday
I'm pretty clueless as to how to accomplish all this. I know SQL pretty well, but none of my SQL statements work in Crystal. I've been looking for tutorials on youtube but I can't find an answer to my question
Wondering if someone here can help, thanks in advance
Hi Ted,
Crystal thinks the date in your database is a String type and not Date or DateTime. Try converting your field to a date like:
CDate ({TimeTicketDet.TicketDate}) = CurrentDate -1;
Brian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ted,
Crystal thinks the date in your database is a String type and not Date or DateTime. Try converting your field to a date like:
If IsDate ({TimeTicketDet.TicketDate}) Then
CDate ({TimeTicketDet.TicketDate}) = CurrentDate -1;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.