Calculated field is sorting date from left to right instead of by YYYY/MM/DD

[A.Baeisa (Al)]

Hi Joe,
you can get any date from any date field then format it the way you want cast it to any calculated field in BAQ using this SQL command, for example

FORMAT(OrderRel.DueDate, 'DD/MM/YYYY')

you can add time and time calculation as well if you want

Time Interval / Duration BAQ E9.05

@Mi3kel @gpayne @Nancy_Hoyt, i do not know if this will help to simplify what you want or not, and i have noticed that you are not taking into consideration the date change, and i think this is important when working on the LaborDtl table, so i created this SQL equation to calculate the difference in minutes time for each transaction between ClockInDateTime and CurrentDateTime, this one equation will take into consideration the different in days as well as time, and can be altered to any other …