Date format in a calculated form field

[CherylLu]

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.

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,

[_Manish_Singh]

Are you saying it should be 04/27/23 rather than 4/27/23?

[CherylLu]

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.

[_Manish_Singh]

I can think of extracting the day, month and year from the desired date field and concatenate it. Something like this:

CONCAT(MONTH({entryDate}),DAYOFMONTH({entryDate}),RIGHT(YEAR({entryDate}),2))

Other community members may have better ideas.

[CherylLu]

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!

[_Manish_Singh]

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

[CherylLu]

That worked - thank you so much!

[CherylLu]

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!

[The_Real_Melinda_Layten · Accepted solution]

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

[CherylLu]

THANK YOU!! I had the right pieces in the wrong order. I really appreciate your help.