Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have two fields like YO2 Date , EOB Date when YO2 Date<>'NULL' and EOB Date <>'NULL'
i have to get min date from YO2 Date and EOB Date .
so how to write an expression to get min date .
example :
IF(YO2 Date<>'NULL' and EOB Date <>'NULL') THEN i shoud get min date from YO2 AND EOB Dates.
can any one help on this thanks.
try :
date(min (total date))
May be this
RangeMin([YO2 Date], [EOB Date]) or RangeMin(Min([YO2 Date]), Min([EOB Date]))
Hello Nagarjuna005,
Do you need to get ONE value that is min between the 2 dates, or you need both?
For both, try this...
=IF([YO2 Date]<>Null() and [EOB Date] <>Null() , min( [YO2 Date] ) &' | '& min( [EOB Date] ) )
For one, try this..
=IF([YO2 Date]<>Null() and [EOB Date] <>Null() ,
if ( min( [YO2 Date] ) > min( [EOB Date] ) , [YO2 Date] , [EOB Date] ) )
Fukumoto.
You have received quite a few ideas on things, if any of them helped, please close out the thread for us by using the Accept as Solution button on any post(s) that helped you solve your issue. If you did something different, consider posting that and then use the button to mark that post. This will close the thread and let other Members know what worked and it gives credit to the posters for the help if something did work.
Regards,
Brett