Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please I need help formatting date in the load script.
My date reads 5-Jan-2016
but I need it to be 01/05/2016
Thanks.
Try this
Date(Date#(DateFieldName, 'D-MMM-YYYY'), 'MM/DD/YYYY') as DateFieldName
Try this
Date(Date#(DateFieldName, 'D-MMM-YYYY'), 'MM/DD/YYYY') as DateFieldName
Thank you. It worked!