Questions tagged [convert]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
142 views

Converting text to number

I am trying to create a new field and convert a text to a number but am getting this error (Error: text__c may not be used in this type of formula) when using this formula (Value(text__c)). The ...
Vicky's user avatar
  • 1
0 votes
0 answers
81 views

Milliseconds issue, how convert 00h to 24, 01h to 25, 02h to 26..?

I have a LWC component that is a calendar, he verify the begin and end time of the company to put the interval of this hours, the problem is, when the hour is 00 or 01 or 02.. because of the way that ...
Alexia's user avatar
  • 81
0 votes
0 answers
77 views

How do I put a DATE type value in a String field in a Marketing Cloud data extension

I'm trying to do this sql query, but I'm getting an error when converting the type date to string.... I've tried using CAST/ CONVERT/ TRYCAST .. but I must be doing something around because Marketing ...
Thais Carolyne Souza's user avatar
-1 votes
1 answer
658 views

Pass array of JS object from LWC to Apex as list of string

From child LWC I want to pass the array of object to Parent LWC which will then pass the object to Apex as List of String Child.js allData = []; data = { id: '', startDate ...
Jenil's user avatar
  • 43
-1 votes
1 answer
2k views

How to convert Map<String,List<String>> to Map<String,String>?

I have a Map<String,List> and I want to convert to Map<String,String> converting list to string.join(','). I tried this, but it only replicates one value User u = new User(); List<User&...
Alexia's user avatar
  • 81
1 vote
1 answer
228 views

Data Extract activity is changing the physical order of records

I have the next issue when exporting a CSV file to a SFTP location: It's about a daily automation, the process consists in three steps, one for data extract, a second one to convert the file to UTF8 ...
Alexandru Ciobanu's user avatar
0 votes
1 answer
2k 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, ...
Matheus Coelho Campos's user avatar
0 votes
2 answers
3k 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....
LT888's user avatar
  • 27
0 votes
0 answers
78 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 ...
Nap's user avatar
  • 71
-1 votes
1 answer
856 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.
developer's user avatar
0 votes
1 answer
427 views

Convert integer to a binary value [closed]

I want to display the given number in binary format. For example 78 -> 1001110
ilaydas's user avatar
-3 votes
1 answer
593 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 ...
Eduardo Murakami's user avatar
1 vote
3 answers
2k 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 ...
Saariko's user avatar
  • 5,581
0 votes
2 answers
88 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-...
Rag21's user avatar
  • 105
0 votes
1 answer
175 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 ...
M.ho's user avatar
  • 5
0 votes
1 answer
786 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), ...
Ilyass Ait Moussa's user avatar
0 votes
2 answers
5k 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 ...
MD Faizan's user avatar
0 votes
1 answer
2k 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,...
Maverick's user avatar
1 vote
1 answer
2k 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
Julianne Matzell's user avatar
1 vote
1 answer
1k 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 ...
SFMC SQL's user avatar
1 vote
2 answers
139 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 ...
jschleicher's user avatar
0 votes
1 answer
2k 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 ...
Pablo's user avatar
  • 5
-2 votes
1 answer
1k 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);...
Sarah Paulson's user avatar
0 votes
1 answer
4k 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 ...
Ajith Kumar's user avatar
0 votes
0 answers
2k 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 ...
Juraj Resko's user avatar
0 votes
1 answer
457 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?
Max's user avatar
  • 101
0 votes
1 answer
668 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 ...
Tom Linstead's user avatar
0 votes
1 answer
544 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:...
WEFX's user avatar
  • 259
6 votes
2 answers
2k 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 ...
PatMcClellan__c's user avatar
1 vote
1 answer
1k 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. ...
GeorgieR's user avatar
3 votes
2 answers
2k 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: "...
chandu's user avatar
  • 33
2 votes
1 answer
725 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....
SalesforceAdminKanova's user avatar
0 votes
0 answers
82 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, ...
Ron's user avatar
  • 25
0 votes
1 answer
1k 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 ...
stan's user avatar
  • 71
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 ...
Roody's 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()....
JURY's user avatar
  • 183
1 vote
2 answers
552 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 ...
Sowparnika's user avatar
5 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....
Mossi's user avatar
  • 3,906
0 votes
1 answer
335 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 ...
jaw999's user avatar
  • 1,308
1 vote
1 answer
1k 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 ...
Win4frndz's user avatar
9 votes
2 answers
2k 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.
Oupat's user avatar
  • 723
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 ...
Nick's user avatar
  • 6,924
1 vote
0 answers
211 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; ...
VaroutSP's user avatar
  • 311
1 vote
1 answer
7k 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 ...
Testing_SFDC's user avatar
  • 2,940
0 votes
1 answer
499 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 ...
TheAdmin's user avatar
  • 335
3 votes
1 answer
2k 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 ...
Olivia Salvatore-King's user avatar
0 votes
1 answer
1k 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 ...
Alias311's user avatar
  • 399
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%%, ...
Coronel's user avatar
  • 41
3 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?
Dudekula Guruvamsi's user avatar
2 votes
1 answer
387 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 ...
Melissa Lenai's user avatar