Community forum

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


Rahn
  •  Rahn
  • No customer Topic Starter
2009-04-16T13:18:22Z

Trying to add the date criteria to an attachment in an email:
If created date > {DATEFORMAT(MM/dd/yyyy 00:00:01)}

Returns error "Field 'Newer than' value is an invalid date."

I've tried various forms:
{DATEFORMAT(MM/dd/yyyy)}
{DATEFORMAT(M/d/yy)}
{DATEFORMAT(MM/dd/yyyy 12:00:01)}

I even tried hardcoding the date in, 4/16/2009 or April 16, 2009.

All seems to fail. What simple thing am I missing?
(And it can be done in "Older than" textbox too.)
Sponsor
Forum information
Support
2009-04-17T08:04:53Z
Hi Rahn,

the problem is that DATEFORMAT Variable was not not implemented for comparison. But we will add this for, probably, next version.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Rahn
  •  Rahn
  • No customer Topic Starter
2009-04-17T13:06:03Z
It must be kind of exciting to see how your stuff is used in ways you didn't expect.

I worked around this by adding the dateformat variable to the filename in the attachment.
I suppose I can also use the name of whatever fired the trigger, but that doesn't allow me as much control. (In case a random file shows up.)

Thanks.
Support
2009-04-17T13:08:06Z
Yes, it is exciting 😁
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Support
2009-04-19T13:45:45Z
We have fixed this now so you can use DATEFORMAT that way. It is fixed in version 5.1.1. http://www.visualcron.co...m.aspx?g=posts&t=531 
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top