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 ...

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 p...

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 f...

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...

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(da...

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 parse...

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...

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.

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.

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 dig...