Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i have feild that present time like this:
1138
625 ( means 06:25)
1758 ( means 17:58)
how i chenge to format HH:MM
and i need that 625 will bt 06:25 , or 12 will be 00:00
thanks'
yarin.
time(time#('625','hmm'),'hh:mm')
try this
time(Time#(field,'hhmm'),'hh:mm')
or try this
Date(Date#(field,'hhmm'),'hh:mm')
Hi
if you have 2 options in the filed (625,1758) you need to combine the 2
try this:
if(len(Field_Name)=3,TIME#(Field_Name,'hmm'),TIME#(Field_Name,'hhmm'))
BR
Ariel
Hi,
Use Alt() for handling multiple date formats in a single field
=Alt(time(time#('TimeDimension','hhmm'),'hh:mm'), time(time#('TimeDimension','hmm'),'hh:mm'), time(time#('TimeDimension','hhmm'),'hh:mm'),time(time#('TimeDimension','hh'),'hh:mm'))
Hope this helps you.
Regards,
Jagan.