date calculation

[Joe H]

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?

[Lee Smith]

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

[-Queue-]

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 ).