I have a time Colum in a odd format ( do not even have Year in and need help converting to a simply YY/MM/DD HH:MM
Thanks
tong
Here is the formula I used to do the conversion
Date MDY( Num( Word( 1, :Time, "[/" ) ), Num( Word( 2, :Time, "[/-" ) ), 2024 ) +Informat( Word( 3, :Time, "[/-]" ), "hh:mm:ss" )