Date expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 tables, one with 3 different fields for different type dates. I am
trying to pull the latest date in a column to a report. Need help with proper
expression. Have tried everything. Example "=Maintenance![LastofPM Next Due]"
 
Didnt work. Trying to build expression [from table]![latest date in column]
--
Thanks for your help,
Greg


KARL DEWEY said:
Try nested Iif.


Greg said:
I have 2 tables, one with 3 different fields for different type dates. I am
trying to pull the latest date in a column to a report. Need help with proper
expression. Have tried everything. Example "=Maintenance![LastofPM Next Due]"
Click to expand...
Click to expand...
 
did you try =max(
![date]), this should return the maximum value for
the dates

you may also be able to use "last",

Greg said:
Didnt work. Trying to build expression [from table]![latest date in column]
--
Thanks for your help,
Greg


KARL DEWEY said:
Try nested Iif.


Greg said:
I have 2 tables, one with 3 different fields for different type dates. I am
trying to pull the latest date in a column to a report. Need help with proper
expression. Have tried everything. Example "=Maintenance![LastofPM Next Due]"
Click to expand...
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel due and overdue date colours 2
How to SELECT with date criteria by SQL? 1
Dates & Future Dates 3
An expression for dates from and to 9
Create Expression Using IIf, Or 8
Access query 7
DMax expression 2
Recordset Findfirst Date Issue 0

Back
Top