Discussion board where members can get started with Qlik Sense.
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
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),