Date expression

G

Greg

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]"
 
G

Greg

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

LostInAccess

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