Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try
TimeStamp#(SubField(CreatedByID, ', ', 2), 'MM/DD/YYYY h:mm')
May be like this
LOAD TimeStamp(TimeStamp#(SubField(CreatedByID, ', ', -1), 'M/D/YYYY h:mm TT')) as TimeStamp
SubField(CreatedByID, ', ', 1),