Post reply

Current Month:

  • January 10, 2005 at 10:16 am

    #361813

    Everything works great but my last False IIf statement:  [ReleaseDate]-[Current Month:]...Can I get some help why this isn't working???

    IIf(IsNull([ReleaseDate]),(IIf([DatePlaced]>=[Current Month:],[Next Month:]-[DatePlaced],[Enter Number of Days in Spreadsheet Month:])),(IIf([DatePlaced] And [ReleaseDate]<[Current Month:],0,(IIf([DatePlaced]>=[Current Month:],[ReleaseDate]-[DatePlaced],[ReleaseDate]-[Current Month:])))))

  • January 10, 2005 at 12:27 pm

    #536715

    Found Solution:

    Added DateDiff to statement

    MonthlyDays: IIf(IsNull([ReleaseDate]),(IIf([DatePlaced]>=[Current Month:],[Next Month:]-[DatePlaced],[Enter Number of Days in Spreadsheet Month:])),(IIf([DatePlaced] And [ReleaseDate]<[Current Month:],0,(IIf([DatePlaced]>=[Current Month:],[ReleaseDate]-[DatePlaced],DateDiff("d",[Current Month:],[ReleaseDate]))))))

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply