Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

abhonsle
Contributor

Strip Timestamp from a salesforce field

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

3 Replies
ahaahaaha
Honored Contributor

Re: Strip Timestamp from a salesforce field

Hi,

Try

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

Re: Strip Timestamp from a salesforce field

May be like this

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

sasiparupudi1
Honored Contributor III

Re: Strip Timestamp from a salesforce field

SubField(CreatedByID, ', ', 1),