


I have a calculated custom field that is pulling multiple pieces of data into one field. The bold field is the one I'm stuck on. The user enters a date in a calendar field, but when I pull the date into this field, I need the date to be MMDDYY rather than 4/27/23. I've looked online but haven't been able to find this situation.
Views
Replies
Sign in to like this content
Total Likes
RIGHT(CONCAT("0",MONTH({DE:Driver file delivery date requested - driver file 1})),2)
RIGHT(CONCAT("0",DAYOFMONTH({DE:Driver file delivery date requested - driver file 1})),2)
So X become 0X
And 10 becomes 010 becomes 10 etc
Are you saying it should be 04/27/23 rather than 4/27/23?
Views
Replies
Sign in to like this content
Total Likes
No, I need it to be without the slashes in the date. It doesn't matter if it's 4 or 04 for the month.
Views
Replies
Sign in to like this content
Total Likes
I can think of extracting the day, month and year from the desired date field and concatenate it. Something like this:
Thanks, I'm not sure where to put that in relation to the field name it's pulling from though - the bold part here. I've tried inserting it before and after and get errors
CONCAT("LL",{DE:Driver file data source},"_",{DE:ES Project Number system generated},"_",{DE:Project letter for Driver file 1, entered by PM},"_",{DE:Driver file delivery date requested - driver file 1})
Thanks for your help!
Views
Replies
Sign in to like this content
Total Likes
Have you tried this..
CONCAT("LL",{DE:Driver file data source},"_",{DE:ES Project Number system generated},"_",{DE:Project letter for Driver file 1, entered by PM},"_",CONCAT(MONTH({DE:Driver file delivery date requested - driver file 1}),DAYOFMONTH({DE:Driver file delivery date requested - driver file 1}),RIGHT(YEAR({DE:Driver file delivery date requested - driver file 1}),2)))
Views
Replies
Sign in to like this content
Total Likes
That worked - thank you so much!
Views
Replies
Sign in to like this content
Total Likes
That worked, but now we do need the month and date to be mmdd. I'm unable to figure out how to get a leading zero, if the month or day are only 1 digit numbers.
thanks!
Views
Replies
Sign in to like this content
Total Likes
RIGHT(CONCAT("0",MONTH({DE:Driver file delivery date requested - driver file 1})),2)
RIGHT(CONCAT("0",DAYOFMONTH({DE:Driver file delivery date requested - driver file 1})),2)
So X become 0X
And 10 becomes 010 becomes 10 etc
THANK YOU!! I had the right pieces in the wrong order. I really appreciate your help.
Views
Replies
Sign in to like this content
Total Likes