concatenate formula Help

[chamakalayil]

Can anyone help with the concatenate function. 

Trying to concatenate three characters from the left from Tabel Station with the schedule date. 

One Screen from Excel where it was converted and other from Alteryx

Thanks in advance

alteryxexcel

[DataNath]

Hey @chamakalayil, I've had a play with this and to get the same date format (i.e. days since 1900) you can use the following Formula expression:

Left([Station], 3)+ToString(
DateTimeDiff([Scheduled Date],'1900-01-01','day'))

In my case this outputs 45194 (so 2 days short). I think this may be due to system settings. However, if not then you can just add a +2 to the expression to give:

Left([Station], 3)+ToString(
DateTimeDiff([Scheduled Date],'1900-01-01','day')+2)

Hope this helps!

[chamakalayil]

Thank You Very much