Write the expression to find the number of days between date1and date2?

[gkcchowdary]

Fields provide :date1,date2

[Anonymous]

interval(date1 - date2, 'DD')

[aarkay29]

or

simply date1 - date2

[MarcoWedel]

between date1 and date2 means date1 precedes date2, rigth?

So one solution might be:

date2-date1

hope this helps

regards

Marco