Questions tagged [convert]
The convert tag has no usage guidance.
63
questions
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 ...
- 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 ...
- 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 ...
-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 ...
- 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&...
- 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 ...
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, ...
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....
- 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 ...
- 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.
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
- 1
-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 ...
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 ...
- 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-...
- 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 ...
- 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), ...
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 ...
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,...
- 27
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
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 ...
- 11
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 ...
- 33
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 ...
- 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);...
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 ...
- 346
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
...
- 13
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?
- 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 ...
- 21
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:...
- 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 ...
- 3,490
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. ...
- 13
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:
"...
- 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....
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, ...
- 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 ...
- 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 ...
- 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()....
- 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 ...
- 95
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....
- 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 ...
- 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 ...
- 91
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.
- 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 ...
- 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; ...
- 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 ...
- 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 ...
- 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 ...
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 ...
- 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%%, ...
- 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?
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 ...
