It would be in the XML memo (data) but of the delivery of the broadLogRcp. Something like this:Hope this helps.If you want to ensure that the variable is used in the HTML content you can check my reply to this question: https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-question...
Yes, if you have 4 digits in your field, it will remain the same, if you have 1 digit it will be filled with 3 0s at the left. For more info you have here a list of all database functions and how to use them: https://experienceleague.adobe.com/en/docs/campaign-standard/using/managing-processes-and-d...
Hello, check the function LPad -> To fill with 0s at the left of the number you can use: LPad(@field, 4, '0').With this, you will have 4 digits, with 0s at the left.
Hello, you should use a fork and an enrichment after your data loading file activity, making the enrichment with your table by the column "A", after that put a test that checks if there are some records (vars.recCount > 0):- If there are some records -> Go to End- Else: Recover the data from the dat...
Hello @RajeshBhat, the content is not stored in the SQL database, so you can't query it BUT you can use the field data with a regular expression. Take a look:The "data" field contains all the XML that forms a delivery. The content is between <content> and </content>, so you can make this query:This ...
Hello, I have this content in the delivery:The result is:I know that i can use:But I would like to know if I can set a default format date for the delivery.Thank you in advance.@Manoj_Kumar_ @ParthaSarathy @Parvesh_Parmar @DavidKangni
Hello everyone, when i show in a list any date i get the format MM/DD/YYYYI would like to know how to get by default the format DD/MM/YYYY.Thank you in advance,Héctor@Manoj_Kumar_ @ParthaSarathy @Parvesh_Parmar @DavidKangni