Convert string into time?

[william_fu]

How can convert a string into a timestamp (hh:mm)?

e.g.:

1531 into 15:31

0805 into 08:05

This code doesn't seem to work:

    Time(Time#([String], 'hh:mm') ) AS [StringHour],

After that, how would I combine it with a date to create a date/time column?

Thanks in advance

[pradosh_thakur · Accepted solution]

Time(Time#([String], 'hhmm') ,'hh:mm') AS [StringHour],

[pradosh_thakur]

for the second part something like this

timestamp(timestamp#(date_field & [StringHour],'DD/MM/YYYYhh:mm')) as date_time

here DD/MM/YYYY I have assumed as date format.

[sunny_talwar]

For second part, this is also possible

TimeStamp(DateField + Time(Time#([String], 'hhmm') ,'hh:mm')) as date_time_field