Custom Date Field Formatting
I am creating an internal reference number using the CONCAT function and the date forms part of this. I need to convert a Custom Date field into an all numerical format of YYYY/MM/DD. If this is possible in a Calculated Field in a Custom Form this would great for any help!
You got an answer to that.
Then someone said:
Ohh I think I see what you're asking for. My calc above will give you 1/5 but not 01/05.
You''d have to insert logic in the expression to evaluate the month and date. If the month is less than 10 then you'd have an expression that concats "0" in front of month. Same thing for Day of the Month.
Hi Justin - any idea on the calculation for this?
Here it is:
CONCAT(YEAR({DE:UKI - Campaign Start Date}),"/",IF(MONTH({DE:UKI - Campaign Start Date})<10,"0",""),MONTH({DE:UKI - Campaign Start Date}),"/",IF(DAYOFMONTH({DE:UKI - Campaign Start Date})<10,"0",""),DAYOFMONTH({DE:UKI - Campaign Start Date}))