Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

icoggin
icoggin
Offline

Badges

Badges
12

Accepted Solutions

Accepted Solutions
3

Likes Received

Likes Received
1

Posts

Posts
23

Discussions

Discussions
1

Questions

Questions
22

Ideas

Ideas
1

Blog Posts

Blog Posts
0
Top badges earned by icoggin
Customize the badges you want to showcase on your profile
Adobe Campaign Standard Direct Mail - how to order the output by a given specific field - Adobe Campaign Standard 13-01-2022
Hello all. We have a requirement to be able to sort our mailing output by account number - so as to better see the joint accounts (with two rows) and make checking mailing proofs much easier. We don't want to filter out any rows just change the order of the output.I can see there are "windowing" or representation functions such as Desc and OrderBy but I get error messages about invalid aliases when trying to use them on the account number field and I suspect they might be meant to generate QUALI...

Views

139

Likes

0

Replies

1
Re: Reformatting a non mandatory date field in expression editor - Adobe Campaign Standard 13-09-2021
I did get to a solution for this (or at least a part solution). Somewhere the default date was set to YYYY/MM/DD but I could not get it turned to DD/MM/YYYY format as a default. However - for Direct Mailings (DM) at least - I could get the format I wanted - for dates fields that are only sometimes populated. It does not need the expression editor for DM.The solution:edit the Direct Mail Delivery activity, Click on the Content area to edit that, click on the "File Structure" tab, Go down to the D...

Views

196

Likes

0

Replies

0
Re: Reformatting a non mandatory date field in expression editor - Adobe Campaign Standard 13-09-2021
Thanks for the reply JyotiThe two suggestions you give under the OR parts of the reply will not work for this specific query. They only work where the data is always populated like GetDate() - they do NOT work for my specific query where the date is only populated some of the time. They are lifted from other posts and do not include the date separator I need.As for the "<%= formatDate(targetData.Date1, "%2D/%2M/%4Y") %>" option I have not tried this. I do not think it is part of what would work ...

Views

197

Likes

0

Replies

0
Reformatting a non mandatory date field in expression editor - Adobe Campaign Standard 07-09-2021
I have a requirement to output date in the format DD/MM/YYYY. However, our Adobe Campaign Standard has a default date format of YYYY/MM/DD. I do not have system admin access and have no idea if we can change this default format. That would be good to know as a possible solution but for now I need to reformat from YYYY/MM/DD to DD/MM/YYYY. The excellent solutions such as the ones below only work for a field that is populated all the time. I need something different for a date field that is someti...

Views

228

Likes

0

Replies

3
Re: Convert System Date to mmddyyyy format - Adobe Campaign Standard 03-09-2021
Thanks David. That works for GetDate() but what happens if you apply the formula to a field in which the date is only present some of the time? When the date is not present the value output into the field is "00". Is there anyway to overcome this. I have tried various functions, e.g.IsEmptyString(datefield) - with and without ToString(datefield) - Iif(datefield IS NULL, Iif(Length (datefield) = 0 , etc. etc,. and nothing gets parsed.

Views

285

Likes

0

Replies

0
Re: Date Format Function in Adobe Campaign Standard - Adobe Campaign Standard 03-09-2021
Thanks Anil. That works for GetDate() but what happens if you apply the formula to a field in which the date is only present some of the time/ When the date is not present the value output into the field is 0/0/. Is there anyway to overcome this. I have tried various functions and nothing gets parsed.

Views

4.1K

Likes

0

Replies

0
Re: Load File Activity: Uploading new file hangs with no response - Adobe Campaign 13-08-2021
Hi Sukrity. In the end we did not really get to the root cause of it. In itself the file size was not an issue as both a colleague and myself had the issue in the end with the same sort of number as text (with leading zeroes needed). With that field altered the files loaded. with very small files it loaded but big files with that field failed to load. something else was happening.However we do not no what Adobe was doing differently to that field. Our support could not reproduce it but after he ...

Views

602

Likes

0

Replies

1
Re: Load File Activity: Uploading new file hangs with no... - Adobe Campaign 04-08-2021
No worries minakshis868318 it is an obscure one as well as confidential info, I will hope to be able to get to a resolution with the support team to share back here.

Views

630

Likes

0

Replies

0
Re: Load File Activity: Uploading new file hangs with no... - Adobe Campaign 03-08-2021
Sorry minakshis868318 I thought I had replied to this. I do not have system admin access to get to the audit logs. I have asked our named support people to get into them and investigate further. If nobody on the community has come across this hopefully their extra access can help us.

Views

640

Likes

0

Replies

0
Re: Load File Activity: Uploading new file hangs with no... - Adobe Campaign 03-08-2021
Thanks for the suggestion minakshis868318. I see something slightly different in the web interface but it does not get as far as allowing me to change the datatypes of the fields in file structure. It hangs when uploading the file and never gets as far. Also I need to keep it as string. It holds digits but some of them have a leading zero which is valid so it needs to remain as a text datatype.

Views

647

Likes

0

Replies

0
Likes given to
Likes from