Can we apply like ErrorDate >= (CurrentDate - 10) in Filter (View)

  • 11 March 2020
  • 3 replies
  • 5 views
S

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.

 

12984iA9A4B312B8ADC0DE.png

 

Tried with Current Date, Current Date and Time with/without other date functions also.. 

 

Thanks,

 

3 replies

H

Hi  @selvakumar_rama 


 


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


https://help.k2.com/kb001565


 


K2 smartforms 1.0 high priority fixes


https://help.k2.com/kb001563


 


Quick guide to upgrading k2 smartforms


https://help.k2.com/kb001331


 


Regards 


Hulisani

S

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,

 

 

 

K
Userlevel 6
Badge +16

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.


Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings