AnsweredAssumed Answered

HUH?  Simple math isn't working.

Question asked by Matty_1 on Aug 21, 2013
Latest reply on Aug 21, 2013 by Matty_1

Title

HUH?  Simple math isn't working.

Post

     Hello,

     I have the following calculation:

      

     
          Filter ( TimeFormatAs ( RightWords ( Get ( CurrentTimeStamp ) ; 2 ) ; 24 ) ; "0123456789" )  ≥  80000
     
           
     
          and
     
           
     
          Filter ( TimeFormatAs ( RightWords ( Get ( CurrentTimeStamp ) ; 2 ) ; 24 ) ; "0123456789" )  ≤  190000

     I have installed a timed script running hourly backups and I only want it to run during business hours otherwise I will have a boat load of backups for nothing.  My issue is that the above calculation only functions after 10 AM.  My TimeFormatAs is a custom function that outputs a 24 hour clock and obviously the filter removes all spaces and whatever else to produce a proper integer, so 09:45:00 AM comes out as 94500.  I get the impression that because the output isn't six digits long the second line can't resolve but I don't know why.  Once the output is at 100000 or more the files start to backup.

     Any ideas?  Thanks!

Outcomes