today()

[Guest]

I need to subtract today’s date from 2/1/2007.

 

[Guest]

Hi pgarcia,

If you subtract today;s date from 2/1/2007 you will get a negative number,
as today is after 2/1. Again, what are you trying to achieve?

Check out the datediff function perhaps.

Damian.

 

[Guest]

You don't say what you are using to perform the calc (Form, Query or Report)?

For a unbound textBox on a form or report

Select the properties of a textbox on a form or a report and type in the
Control Source row
=Date()-#02/01/2007#

hth Mike B

--
An Engineers Prayer:
At the very end of the day,
when all else fails,
you have tried all,
you have shouted at and blamed the innocent,
and asked everyone you know,

READ THE INSTRUCTION MANUAL.

 

[Guest]

Damian is right, I read the question round the wrong way

#2/1/2007#-Date() will be a negative number
--
An Engineers Prayer:
At the very end of the day,
when all else fails,
you have tried all,
you have shouted at and blamed the innocent,
and asked everyone you know,

READ THE INSTRUCTION MANUAL.

 

[Guest]

It's a form and I used (thanks any was):

Expr1: DateDiff("d",[Transaction_Date],Now())

But now that I have that, how can I do the following?

=IIF(AND([Expr1]>30,Expr1<=60),[Amount Due Remaining/Applied],0)

 

[Guest]

Sorry, it's a form, but I did find out how to do it.

Expr1: DateDiff("d",[Transaction_Date],Now())

But now that I have that. How can I do the following:

=IIF(AND([Expr1:]>30,[Expr1:]<=60),[Amount Due Remaining/Applied],0)

I'm a lot better ai Excel

 

[Guest]

try this one

=IIf([Expr1]>30,IIf([Expr1]<=60,[Amount Due Remaining/Applied],0),0)

Again hth????

Best Regards Mike B
--
An Engineers Prayer:
At the very end of the day,
when all else fails,
you have tried all,
you have shouted at and blamed the innocent,
and asked everyone you know,

READ THE INSTRUCTION MANUAL.

Sorry, it's a form, but I did find out how to do it.

Expr1: DateDiff("d",[Transaction_Date],Now())

But now that I have that. How can I do the following:

=IIF(AND([Expr1:]>30,[Expr1:]<=60),[Amount Due Remaining/Applied],0)

I'm a lot better ai Excel

You don't say what you are using to perform the calc (Form, Query or Report)?

For a unbound textBox on a form or report

Select the properties of a textbox on a form or a report and type in the
Control Source row
=Date()-#02/01/2007#

hth Mike B

--
An Engineers Prayer:
At the very end of the day,
when all else fails,
you have tried all,
you have shouted at and blamed the innocent,
and asked everyone you know,

READ THE INSTRUCTION MANUAL.

 

[John W. Vinson]

Expr1: DateDiff("d",[Transaction_Date],Now())

But now that I have that, how can I do the following?

=IIF(AND([Expr1]>30,Expr1<=60),[Amount Due Remaining/Applied],0)

That looks like a valid Excel expression - but Access and Excel are
different programs with different syntax.

Try

=IIf(DateDiff("d', [Transaction_Date], Date()) > 30 And DateDiff("d',
[Transaction_Date], Date()) <= 60, ,[Amount Due Remaining/Applied],0)


John W. Vinson [MVP]

 

[Guest]

That worked Great, THANKS!!

try this one

=IIf([Expr1]>30,IIf([Expr1]<=60,[Amount Due Remaining/Applied],0),0)

Again hth????

Best Regards Mike B
--
An Engineers Prayer:
At the very end of the day,
when all else fails,
you have tried all,
you have shouted at and blamed the innocent,
and asked everyone you know,

READ THE INSTRUCTION MANUAL.

Sorry, it's a form, but I did find out how to do it.

Expr1: DateDiff("d",[Transaction_Date],Now())

But now that I have that. How can I do the following:

=IIF(AND([Expr1:]>30,[Expr1:]<=60),[Amount Due Remaining/Applied],0)

I'm a lot better ai Excel

You don't say what you are using to perform the calc (Form, Query or Report)?

For a unbound textBox on a form or report

Select the properties of a textbox on a form or a report and type in the
Control Source row
=Date()-#02/01/2007#

hth Mike B

--
An Engineers Prayer:
At the very end of the day,
when all else fails,
you have tried all,
you have shouted at and blamed the innocent,
and asked everyone you know,

READ THE INSTRUCTION MANUAL.


:

I need to subtract today’s date from 2/1/2007.