Minimum dates from two dates field

[rkpatelqlikview]

Dear Team,

Please help me on this scenario. There is a condition, I want to consider the Minimum date from two dates and if Date1 is null ,need to consider Date2 vise versa. After generated new date field i need to count days by using Today()-Newdate. Thanks in advance.

[jyothish8807 · Accepted solution]

Hi ,

Try like this:

If( Sent_Date >= Final_date and len(Sent_Date )>0 and len(Final_date )>0, Sent_Date ,

         if( Sent_Date < Final_date and len(Sent_Date )>0 and len(Final_date )>0, Final_Date,

                if(len(Sent_Date )=0 and len(Final_date )>0,Sent_Date ,Final_date )))

For interval:  Date(today(),'DD/MM/YYYY')- Above exp

Br,

KC

[rkpatelqlikview]

Thank you so much KC. 

[jyothish8807]

You are welcome 🙂