time format

[Anonymous]

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.

[#2]

time(time#('625','hmm'),'hh:mm')

[#3]

try this

time(Time#(field,'hhmm'),'hh:mm')

or try this

Date(Date#(field,'hhmm'),'hh:mm')

[ariel_klien]

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

[jagan]

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.