Hi,
We need filter like ErrorDate >= CurrentDate - 10 days. If we apply this filter, it is throwing error("Conversion failed when converting date and/or time from character string. Conversion failed when converting date and/or time from character string."). Can anyone help us, how to fix this? Related screenshot is attached.
Tried with Current Date, Current Date and Time with/without other date functions also..
Thanks,
Hi
I did a bit of research on the issue and found that it was part of "high priority issues for K2 smartforms 1.0" and has now been resolved in the K2 smartforms 1.0.1 release.
Have a look at the following links that I came across
K2 smartforms 1.0.1 (4.12165.1565.0) Release Notes
K2 smartforms 1.0 high priority fixes
Quick guide to upgrading k2 smartforms
Regards
Hulisani
Hi Hulisani,
Thanks for your immediate reply. We appreciate it.
As per your reply, the latest version has the fix. Seems we are having the latest version of the K2(5.xxx) only, even though above error is coming. Please guide us, how to proceed next.
Herewith I have attached our system K2 version screenshot.
Thanks,
Hi selvakumar_rama,
You might have to create a data label to hold the expression before using it in the filter, see steps below.
-Create a data label (Type = DateTime)
-Create an expression on the above data label.
To Date and Time (Current Date and Time - 10)
-Use the expression in your filter.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.