Questions tagged [convert]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1 votes
0 answers
24 views

Cast function for strings [closed]

i have the following problem: When there is a positive percentage in FORMAT(ProjectVisibilityTrend, 'P1'), there has to be a plus in front of the percentage. So i wrote the following code but i keep ...
user avatar
  • 1
0 votes
1 answer
48 views

What is the simplest way to cast a Map<Object, List<SObject>>?

I'm trying to find the most simple way to cast a map<Object, List<Sobject>> in any other type like, String, Integer and etc.. Anyone knows how to do this? This is my code Map<Object, ...
user avatar
0 votes
2 answers
96 views

Convert a datetime to date in SFMC

I have an issue converting a date/time to a string format date. Indeed, I would like to change the following date format : 'mardi 15 mars 2022 4:24 PM' to this format '15/03/2022' without the timedate....
user avatar
  • 27
0 votes
0 answers
41 views

Convert function with date formatted as text

I have a DE1 with field named 'DATE_A' with datatype text. This field contains records that are formatted like this: yyyy-mm-dd hh:mm. Using sql query activity I should retrieve records with field ...
user avatar
  • 71
-1 votes
1 answer
47 views

Can I Convert Map<String,sobject> to Map<String,object> [closed]

I have Data in MAP<String,sobject> type map and I wants to put it in Map<String,object> type Map. Please help with this casting.
user avatar
0 votes
1 answer
71 views

Convert integer to a binary value [closed]

I want to display the given number in binary format. For example 78 -> 1001110
user avatar
-3 votes
1 answer
55 views

How to convert string in Date format? [closed]

I have a string like this : '20170206' I need to convert it into a date like that : 06/02/2017 String birthdayDate = '20170206'; Date dt = Date.parse( birthdayDate); system.debug(' Parsed Date is ...
user avatar
0 votes
1 answer
535 views

Unable to create temporary data extension: Field name cannot contain the character ) convert to date

I'm trying to convert a timestamp data to a "dd/MM/YYYY" format, but I couldn't figure out the correct syntax. I've wrote this query but I'm getting this error message. Unable to create ...
user avatar
  • 49
1 vote
2 answers
180 views

I would like to do Validation on Lead fields before the 'Convert' button is clicked

So, we have several lead fields, that are only needed upon conversion. There are fields mappings for these fields, which populate correctly on the account/oppty new/converted records. However, they ...
user avatar
  • 5,435
0 votes
2 answers
32 views

Convert Task ActivityDate into String

I need in my wrapper class the activity date from the task object as string to display at a visual force page. My two version below does n't work. If I use this version I get an error (Attempt to de-...
user avatar
  • 83
0 votes
1 answer
64 views

How to convert List<sObject> to List<InnerClass>

I have a @InvocableMethod that is used from Flow builder to create a record. Also I have a inner class with @invocableVariable. It is working fine, but I want to use the same method from another class ...
user avatar
  • 5
0 votes
1 answer
75 views

File convert to UTF8

I'm trying to extract the journeys data with data views and put the generated file in FTP with UTF format. After configuring the query and the Data extract activity (Data extract from Data extension), ...
user avatar
0 votes
2 answers
748 views

System.JSONException: Unexpected character ('<' (code 60)): expected a valid value (number, String, array, object, 'true', 'false' or 'null')

public class CurrencyConvertorClass { public static Decimal convertCurrencyToINR(Decimal eur){ Decimal inr = 0.0; HTTP h = new HTTP(); HTTPRequest req = new ...
user avatar
0 votes
1 answer
430 views

Convert string to list of String in Apex

I have string value : String x = '(My, Test Value, New Other, Value)'; Expected outcome or expected list of string is : list<string> NewList = new list<string>{'My, Test Value','New Other,...
user avatar
1 vote
1 answer
628 views

CONVERT button not showing in Lead tab in Lightning experience

I have added the Convert button in the Mobile & Lightning Actions and it is still not showing in the Lightning experience but it is in Classic
user avatar
1 vote
1 answer
212 views

Query Studio - Could not convert date and/or time from string data type

On one data extension, I have a DateIn field modeled as text. The value can be in one of the two formats like: 2015-06-23 16:12:04.703 8/6/2018 11:46:59 AM When I cast the field to date and use it ...
user avatar
1 vote
2 answers
65 views

Is there a size limit in performing sfdx force:mdapi:convert?

I am attempting to convert a large src directory in mdapi format into source format. When I run "the sfdx force:mdapi:convert -r directoryToBeConverted -d directoryToCaptureConversion --loglevel ...
user avatar
0 votes
1 answer
1k views

Standard Lead Convert Action on custom Lightning Component

Is there a way to call the existing standard action of Lead Convert inside a custom lighting component? I need to show a modal with some validations and if it seems correct by the user, click inside ...
user avatar
  • 5
-2 votes
1 answer
584 views

Convert from Id to Sobject

I have the following scenario. I have this method: public Id picklistTechUpId {get; set;} public void selectTechnicalUpgradeAndPassValues(){ System.debug('picklistShipToID: '+ picklistShipToId);...
user avatar
0 votes
1 answer
2k views

How to convert UTC to IST conversion in apex?

I am getting the time as string like "client_modified": "2020-02-04T11:27:34Z" How can I convert this to local time zone, Update: I am getting this time from api response I need to display it in ...
user avatar
0 votes
0 answers
1k views

SQL - Could not convert date and/or time from string data type

What I have: A source data extension with slightly over 14000 records Two attributes in the DE: GlobalID (Text 10) BirthDay (Text 8, YEARMONTHDAY, no dashes) The target data extension has ...
user avatar
0 votes
1 answer
121 views

I can't convert my Master-Detail field to a Lookup field because the Change Field Type button is not visible

I have deleted all Roll-up Summary fields in the Master object including those in the Deleted Fields but the Change Field Type button is still not showing. Do you have any idea what I can do?
user avatar
  • 91
0 votes
1 answer
422 views

Lightning Lead Convert Modal

Prior to the Summer 19 Release the 'Convert' button on Leads would open in the a modal popup as shown below: However now when our users click the convert button the screen opens in a sub tab and does ...
user avatar
0 votes
1 answer
298 views

sfdx force source convert not allowing spaces in names

I'm using SFDX on a Windows machine. The following command is giving me errors when running from a bash terminal: sfdx force:source:convert -d mdapi -n 'My Alias' It keeps returning this error: 'D:...
user avatar
  • 249
6 votes
2 answers
1k views

Unusual error when I try to sfdx force:source:convert

I'm using the exact same methodology and commands I've used dozens of times, and now I'm getting an error. VS Code, latest version; sfdx extensions, latest versions. I want to convert my source to ...
user avatar
1 vote
1 answer
933 views

Convert Lead button working in Lightning and Sandbox but not Classic

The Convert Lead button has suddenly stopped working in Classic. The button is on the lead page but when clicked nothing happens. No changes have been made to permissions and I've rechecked them all. ...
user avatar
3 votes
2 answers
1k views

Convert different Date Formats into Date based on User locale

I am getting different formats of date formats in date field from Json as a string. I should be able to convert any Date format into Date based on user locale.below are the example of formats. Ex: "...
user avatar
  • 33
2 votes
1 answer
560 views

Magic Mover Conversion Tool

I installed the Magic Mover conversion tool. We're looking to convert in sandboxes first then convert our production environment. I tested 1 record in our partial sandbox. Magic mover worked just fine....
user avatar
0 votes
0 answers
77 views

Convert project to DX - community page

So I followed the instruction to converting an existing project to DX. Created a unmanaged package. Retrieved and converted the zip file. All good so far. When I pushed my code to a scratch org, ...
user avatar
  • 25
0 votes
1 answer
944 views

Wrong date when converting datetime value to date field

I am using the REST API for creating a new Task record, including an Activity Date in the format YYYY-MM-DDThh:mm:ssZ. My current timezone is UTC+1. When submitting a date in the first hour of the ...
user avatar
  • 61
0 votes
1 answer
5k views

Convert JavaScript button for lightning!

I have a JavaScript button which works fine in classic but doesn't show up in lightning, my guess that JavaScript buttons are not supported in lightning, I couldn't convert it using the converter ...
user avatar
  • 49
0 votes
2 answers
2k views

Remove time stamp from the date

I want assign a date value into a WHERE clause of query This is my date Date myDate = System.Today().AddDays(Integer.valueOf(Deal_Expiration_Batch_Settings__c.getInstance()....
user avatar
  • 161
1 vote
2 answers
319 views

Convert a number picklist to date field & send email on that date before

I have a picklist with values from 1 to 31.It corresponds to the date. My requirement is to convert this number selected to a date. Lets say the number selected is 20 then it has to correspond to 20th ...
user avatar
3 votes
0 answers
2k views

Use Reports API to get report results as CSV

Using the Reports and Dashboards API is there a way to convert report results to CSV? Reports.ReportResults results = Reports.ReportManager.runReport(reportId, true); Map<String, Reports....
user avatar
  • 3,764
0 votes
1 answer
264 views

Assign queried Decimal to a Decimal variable

question - want to use a number field called Rebate_Amount__c on object called Rebate_schedule__c (child to Opportunity) to cut a rebate on the Amount__c field on a Revenue_schedule_Summary_Amount__c ...
user avatar
  • 1,268
1 vote
1 answer
988 views

Convert to DateTime, without also converting to GMT?

We have incoming JSON from one of our client using REST API. The JSON they send has a timestamp value as a String like this "timestamp": "2017-01-11 19:23:27 CST". CST here being China Standard Time ...
user avatar
8 votes
2 answers
1k views

Convert a binary value to an decimal value

I would like to know if there is a method to convert a binary value to a decimal value? For example, I need to convert the binary 10000101111010 and get the result 8570.
user avatar
  • 615
4 votes
2 answers
2k views

Is there a way to hide/disable standard Salesforce button clicked

Is there a way to stop standard Salesforce button being clicked? in the Lead page I have a standard button called "Convert" I want the user to stop clicking until the Lead is in certain stage, I'm ...
user avatar
  • 6,559
1 vote
0 answers
154 views

Cannot convert unconverted lead

When trying to convert a lead which hasn't been converted I get one of the two following errors: Error: System.DmlException: Update failed. First exception on row 0 with id 00QN0000005zrQtMAI; ...
user avatar
  • 131
1 vote
1 answer
5k views

Convert String array to Set of string in apex class

Can someone please help me to convert String array values to Set of string? I have below code where it says Set is not getting populated from string array. Criteria=[SELECT Franchise__c FROM ...
user avatar
  • 2,900
0 votes
1 answer
415 views

Populate custom Leads fields to Assets fields on 'convert'

My company wants to gather the client's assets at the lead stage and automatically populate the assets page of the account once the lead gets converted. The same assets fields currently exist as ...
user avatar
  • 335
3 votes
1 answer
1k views

Lead Conversion- sometimes merges with existing contact and sometimes doesn't..why?

Sometimes when my users are converting leads, after they click "Convert", it will bring up another screen asking if we want to merge the lead with an existing contact. This is not consistent and ...
user avatar
0 votes
1 answer
972 views

Lead Source Gone after converting "Lead" to "Contact"

I am having some trouble keeping the lead source. For some odd reason when I am converting a lead into a Contact/Account the lead source that originally came with the lead seems to disappear. Then I ...
user avatar
  • 389
0 votes
1 answer
2k views

Convert date in Marketing Cloud

I need a help to change the format of a date MM/dd /yyyy to dd/mm/yyyy I tried this: Works! Now: %%=Format(Now(),"MM/dd/yyyy")=%% Does not work! Date of Vestibular: %%=Format(%%Date Vestibular%%, ...
user avatar
  • 41
2 votes
1 answer
2k views

Excel to UTF-8 encoded CSV [closed]

How can one convert an Excel file into a UTF-8 encoded CSV?
user avatar
2 votes
1 answer
342 views

Custom button to open opportunity after lead is converted

I have a global class that creates an Opp from a custom lead conversion button. The problem is that the button works to convert the lead to an Opp but it does not open the Opp. I get an error message ...
user avatar
1 vote
1 answer
2k views

How to find the original lead after it has been converted into an opportunity?

I've asked a similar question recently and got the answer I was looking for but still have a bit of a predicament. In the call centre, agents take calls from technicians who sell new business to ...
user avatar
9 votes
3 answers
56k views

Function to convert String to Decimal value?

I need to convert String into Decimal. the isNumeric() method is retuning false if value is Decimal. Another alternate: try { Integer x = Integer.valueOf(myString); } catch (exception e) { // ...
user avatar
1 vote
0 answers
52 views

Map Url field via Object Converter

Could you please advise how to make a map between two fields by using the Object Converter. Here is what I need to achieve http://postimg.org/image/kzhf2h28p/ Unfortunately the Applicants Website(s) ...
user avatar
  • 578
1 vote
0 answers
43 views

Adding a time to datetime

I need some help correcting the time when doing a datetime convert. Currently when running the script below I get a time of 12:00AM - I need it to state 8:03AM SELECT [custcode],[customername],[...
user avatar