date

[#1]

hello i'm traying to realise a soustraction of tow dates one of them continue hours ,i have to change the two dates in the same  form, but still dosen't work :

=MIN(DATE_DEVIS) - DATE(CREATION_CIIENT_COMP,'MM/DD/YYY')

[#2 · Accepted solution]

Hi

please follow this link

The Date Function

and try this

=DATE(FLOOR(CREATION_CIIENT_COMP),'MM/DD/YYYY') AS Date1

Regards

tripati

[Anonymous]

try:

min(date(DATE_DEVIS)) - DATE(CREATION_CIIENT_COMP,'MM/DD/YYY')

[#4]

thanks for your reply but it dosen't work her 'is athe problem un this situation the intervall between dates must be 0

however it's negative ??

...