Joe H Posted January 28, 2005 Share Posted January 28, 2005 I want to bill an advertiser for an ad in this month's monthly paper. I also want to itemize past due amounts. I set up a list layout using the header for the current bill, and the body for past due amounts. Fields are issue_date for the current issue and past_issue_date for past due. Both issue_date and past_issue_date fields are formatted month/year My calculation for past_issue_date returns all dates instead of just past due dates... If(Month(TextToDate(Today)),"",issue_date) What am I doing wrong? Link to comment Share on other sites More sharing options...
This topic is 6627 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now