logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


Welcome Guest ! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Thendral  
#1 Posted : Friday, June 15, 2018 1:22:09 PM(UTC)
Thendral

Rank: Newbie

Groups: Registered
Joined: 5/24/2018(UTC)
Posts: 0
India
Location: Chennai

Thanks: 1 times
Hi,
I'm new to seal report. I created a date parameter restriction('start date' and 'End date') with 'between' operator, when i choose the date range i'm getting the datatype conversion Error. since my datatype is in 'datetime' only dno why this error arising, Can anyone please assist how to solve this.

Error detail:
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

Edited by user Tuesday, June 19, 2018 7:43:08 AM(UTC)  | Reason: Not specified

epf  
#2 Posted : Tuesday, June 19, 2018 11:40:50 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
Did you check the SQL generated with your model (F8).
If KO, check where is the error in the SQL.

thanks 1 user thanked epf for this useful post.
Thendral on 7/2/2018(UTC)
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.