time comparaison

master_student · ‎2016-09-23

Hello everyone,

I need to display the first time after 13:00:00

with this script, I only display all timings after 13h

if(

// Compare if the time from DATE_DEB

time(DATE_DEB,'DD/MM/YYYY hh:mm:ss')

// is greater then

>

// 13:00:00

time(date(floor(DATE_DEB) ,'DD/MM/YYYY') + time(MakeTime(13),'hh:mm:ss'),'DD/MM/YYYY hh:mm:ss') ,

// if so, DATE_DEB

time(DATE_DEB),

// If not, null() value

null()

) as DATEE,

DATE_DEB has this format : 12/05/2015 13:00:00

Ce message a été modifié par : master student

miguelbraga · ‎2016-09-23

Try the Function -> firstsortedvalue().

See examples bellow:

Hope it helps

Related Topics