Strip Timestamp from a salesforce field

[Anonymous]

Hi All,

I have a field "CreadyBy" in salesforce and I want to strip the timestamp from that field.

When I bring in the data in qliksense This field is called "CreatedByID". How can I write a script to strip only the timestamp

[ahaahaaha]

Hi,

Try

TimeStamp#(SubField(CreatedByID, ', ', 2), 'MM/DD/YYYY h:mm')

[sunny_talwar]

May be like this

LOAD TimeStamp(TimeStamp#(SubField(CreatedByID, ', ', -1), 'M/D/YYYY h:mm TT')) as TimeStamp

[sasiparupudi1]

SubField(CreatedByID, ', ', 1),