Date format convertor

[rony2006]

Hello, I have 2 dates and I need to calculate de difference between them.

For difference I know that i can use _DateDiff but the problem is that my dates are in formats like 26.04.2016 18:18:49 and _DateDiff accepts only 1970/01/01 00:00:00 format.

So how can I convert my format to the format accepted by _datediff?

I so that there is a function _DateTimeSplit that allows to put each number to an array. I could use this but it seams that is to much work to do to put the numbers in arrays and then add all arrays in another order to make the format accepted by _DateDiff.

Is there any simple way to do this?

[Melba23]

rony2006,

My Date_Time_Convert UDF (look in my sig for the link) allows you to switch between any format easily.

M23

[rony2006]

Thank you,

It is working ok. The code I used is:

Global $sOut_Date = _Date_Time_Convert($ainterogare[1][12], "dd.MM.yyyy HH:mm:ss", "yyyy/MM/dd HH:mm:ss")


Global $sOut_Date1 = _Date_Time_Convert(_Now(), "dd.MM.yyyy HH:mm:ss", "yyyy/MM/dd HH:mm:ss")

    
    
Global $trea = _DateDiff ('n', $sOut_Date, $sOut_Date1 )