HUH? Simple math isn't working.
I have the following calculation:
Filter ( TimeFormatAs ( RightWords ( Get ( CurrentTimeStamp ) ; 2 ) ; 24 ) ; "0123456789" ) ≥ 80000andFilter ( 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!