How to get the diff betweem two date values ?

[suvechha_b]

Please help me in writing the following expression :

Max((Date(Date#([Start Date],'DD/MM/YYY'),'YYYY/MM/DD'))-Min((Date(Date#([Exp End Date]),'DD/MM/YYYY'),'YYYY/MM/DD'))

Eg ,

[Start Date] : '2014-11-03 00:00:00.000'

[Exp End Date]: '2015-08-03 00:00:00.000'

Result : 273

[sunny_talwar]

Try this:

=Date#(Left('2015-08-03 00:00:00.000', 10), 'YYYY-MM-DD') - Date#(Left('2014-11-03 00:00:00.000', 10), 'YYYY-MM-DD')

[suvechha_b]

Sorry .... My Date format is like this : DD/MM/YYYY

[Start Date]:03/11/2014

[Exp End Date]:03/08/2015

[sasiparupudi1]

=Max(Date#(SubField([Start Date],' ',1),'YYYY-MM-DD'))-Min(Date#(SubField([Exp End Date],' ',1),'YYYY-MM-DD'))

[sasiparupudi1 · Accepted solution]

=Max(Date#([Start Date] ,'DD/MM/YYYY'))-Min(Date#([Exp End Date],'DD/MM/YYYY'))

[maxgro]

if you have 2 dates fields

[Exp End Date] - [Start Date]

if you have 2 date and time and you want the difference in days

floor([Exp End Date]) - floor([Start Date])