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.
Solved! Go to Solution.
Views
Replies
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
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
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
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
Total Likes
That worked - thank you so much!
Views
Replies
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
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
Total Likes
Views
Likes
Replies
Views
Likes
Replies