10 Replies Latest reply on Feb 9, 2016 12:10 PM by Elaine Nelson

File not going in category

Elaine Nelson Feb 8, 2016 12:13 PM

Hello,

I have a template card that I need certain fields be filled in before the user can check the file in.

To do this I have made a category with conditions requiring values in these fields.

One of these fields is a date which I am requiring be later than the current date. I my condition for the date I set the argument to greater than and in the drop down calendar I clicked on "Today:..." at the bottom. The date shown in the argument stays as the date I set it up on but it does seem to go by the actual current date and not the date shown.

Everything works fine except for one thing with the date.

Say the current date is 2/7. When I fill in the template card I can put in 2/8 or later. Say I put in 2/10. When I try to check it in it tells me it does not meet the conditions of the category. To get it to work I have to change the date and then change it back to 2/10. It will then check in fine.

Here are the setting of the date control.

Can anyone tell me what I have to do to get it to check in without having to change the date?

Re: File not going in category

Charley Saint Feb 8, 2016 12:46 PM (in response to Elaine Nelson)

Configurations could be the culprit, are these CAD files? What's the Due_Date variable set to on the file card (Update all configurations?). Also the Due_Date variable has to be set as a date type in Admin Tool->Variables for comparisons to work correctly.
Like Show 0 Likes(0)

Actions
- Re: File not going in category
  
  Elaine Nelson Feb 8, 2016 1:18 PM (in response to Charley Saint)
  
  Thanks for the rely Charley.
  
  These are excel files. Configurations do not apply to excel files do they? Due_Date is set as a date type.
  
  Any other ideas?
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: File not going in category
    
    Charley Saint Feb 8, 2016 1:26 PM (in response to Elaine Nelson)
    
    Mind running this query on the file after creating it with the template, then again when you change the variable and see if anything pops up as different. I can also make this a report generator report if you need.
    
    select filename, variablename, vv1.*, dc1.ConfigurationName
    from
    documents d
    inner join VariableValue vv1 on d.DocumentID = vv1.DocumentID
    inner join DocumentConfiguration dc1 on dc1.ConfigurationID = vv1.ConfigurationID
    inner join Variable v on v.VariableID = vv1.VariableID
    where
    v.VariableName = 'Due_Date'
    and filename = 'Enter FileName Here'
    
    Like Show 0 Likes(0)
    
    Actions
    - Re: File not going in category
      
      Elaine Nelson Feb 8, 2016 4:23 PM (in response to Charley Saint)
      
      I don't have access to the database to run a query. Could you please make a report? Thanks
      
      Like Show 0 Likes(0)
      
      Actions
      - Re: File not going in category
        
        Charley Saint Feb 8, 2016 4:51 PM (in response to Elaine Nelson)
        
        See attached
        
        Variables.crp.zip 597 bytes
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: File not going in category
        
        Elaine Nelson Feb 9, 2016 10:45 AM (in response to Charley Saint)
        
        Not sure what this tells me.
        
        I put in a date of 2/17 both times.
        
        After creation:
        
        After date change:
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: File not going in category
        
        Charley Saint Feb 9, 2016 11:48 AM (in response to Elaine Nelson)
        
        That explains why it's not working at least, in the first image the valuedate is blank in rev 2, which is the current value. It looks like it's not reading 2/17/2016 as a date, it's expecting 02/17/2016. I fear this is caused by the Windows time settings but should be reported as a bug if that's the case. To test go to you Windows date settings and change to this short date and see if that fixes it:
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: File not going in category
        
        Elaine Nelson Feb 9, 2016 12:10 PM (in response to Charley Saint)
        
        That did it. Thank you very much!
        
        Like Show 0 Likes(0)
        
        Actions
Re: File not going in category

Craig Schultz Feb 8, 2016 5:32 PM (in response to Elaine Nelson)

Wouldn't you have to change the value in the category definition every day? Or am I missing something?
Like Show 0 Likes(0)

Actions
- Re: File not going in category
  
  Elaine Nelson Feb 9, 2016 10:46 AM (in response to Craig Schultz)
  
  Thanks for replying.
  
  I am not changing the category. I have to change Due_Date before the file with go in the category.
  
  Like Show 0 Likes(0)
  
  Actions

Go to original post