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...
Lee Smith Posted January 28, 2005 Share Posted January 28, 2005 Your post isn't very clear about the form of your date. It reads to me that they could be actual dates (i.e. 01/01/2005) and formatted to read as Jan 2005, or they are Text field entered as Jan 2005. Also, the calculation is not providing what you want the result to be. A number to show 30, 60, 90 or a text field to say "Late" and either blank or "Current" Lee Link to comment Share on other sites More sharing options...
-Queue- Posted January 28, 2005 Share Posted January 28, 2005 How about something like Status(CurrentDate) - issue_date > 30. It will need to be set as unstored and will produce a 1 when true. If you need the issue_date displayed, use Case( Status(CurrentDate) - issue_date > 30, issue_date ). Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7028 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 accountSign in
Already have an account? Sign in here.
Sign In Now