topic Re: date in QlikView

date

Wed, 25 Nov 2020 16:16:04 GMT

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')

Re: date

Wed, 11 May 2016 14:07:55 GMT

please follow this link

The Date Function

and try this

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

Regards

tripati

Re: date

Anonymous — Wed, 11 May 2016 14:11:49 GMT

try:

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

Re: date

Wed, 11 May 2016 15:10:27 GMT

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 ??

...