"Yesterdays" on Friday…..

This topic has 0 replies, 1 voice, and was last updated 6 years, 8 months ago by Frank.

  • Author
    • #267
      • Topics Started - 80
      • Replies Written - 53

      It’s easy enough to see yesterdays sales in Stratum, just select Yesterday in the date selection. But what about on Monday when you want “Yesterday” to represent Friday(or Sat., or some combo of the weekend), which isn’t really yesterday….. You can use the following to get the current day number – datepart(“w”,Now()) in a calc then decide if you want to display “Yesterday” information or information from 3 days ago (if it’s Monday and you really want to see Friday – adjust to your requirements). The datepart(“w”,Now()) calc will return a 1 for Sunday, 2 for Monday etc.

Viewing 0 reply threads

You must be logged in to reply to this topic.


We're not around right now. But you can send us an email and we'll get back to you, asap.


©2022 KLEO Template a premium and multipurpose theme from Seventh Queen

Log in with your credentials


Forgot your details?