Dear friends, Is that formula true inside of ...

(Etwo Cargo) #1

Dear friends, Is that formula true inside of the Email Body of workflow?

<<LEFT([awb],3>>&"-"&<<RIGHT[AWB],8)>>

(Levent KULAÇOĞLU) #2

<<CONCATENATE(LEFT([awb],3),"-",RIGHT([awb],8))>>

(Etwo Cargo) #3

@Levent_KULACOGLU Dear Levent, Thanks a lot for your kind support as always.

(Etwo Cargo) #4

@Levent_KULACOGLU Dear master,

The date column shows date as JAN 8, 2019. So i want to take day and month only in email body as 08JAN. According below first formula will take data as 8,JAN. If i write formula as MID([DATE],5,1 the data will appear as 1JAN on 11JAN. What solution will be for that? Same for time. Time is as 5:00:00 PM i need hours and minutes as 0500 only.

for date <<CONCATENATE(MID([DATE],5,2),LEFT[date],3))>>

for time <<CONCATENATE(LEFT([time],2),MID([time],3,2))>>