How to trim Full Year and Seconds in DateTime

Question

I am getting Date as '2/12/2020 4:30:29 PM'. But i need trimmed year and seconds date time format like '12/02/20 04:30 PM'

what is the equivalent function in MEL for getting above date time?

Thanks

Answer 1

I'm afraid there isn't an equivalent function in MEL to do this thing. BUT the good news is that you can create it! (yes, MEL needs more time functions to work...).

I've create this global function that you can use it (I assume 2 is day and 12 is month, if not you can change the order):

separator = "/";
space = " ";
hourSeparator = ":";

$global:stringDatetimeToArray = function(datetime)
{
    array['year']   =  substring(datetime, 6, 10);
    array['month']  =  substring(datetime, 3, 5);
    array['day']    =  substring(datetime, 0, 2);
    array['hour']   =  substring(datetime, 11, 13);
    array['minute'] =  substring(datetime, 14, 16);
    array['seconds'] = substring(datetime, 17, 19);
    array['meridian'] = substring(datetime, 20, 22);
    return array;
};

concat(array['month'], separator, array['day'], separator, array['year'], space, array['hour'], hourSeparator, array[minute], space, array['meridian']);

My recommendation for you is to generate a method that converts a timestamp into an array of these values, and then you can work with these kind of issues easier than now. You can see an example on this github script