need to trim a month year formula

[Sean-OReilly]

Hi

I am using the below formula and i get the following result = 4-2019

i want the result to be a shortened version of year, so result wanted = 4-19

how do i achieve this?

[Sean-OReilly]

thanks @CNENFRNL 100% the right answer

[CNENFRNL · Accepted solution]

@Sean-OReilly , supposing the PURCHASEORDERS_ORDERS[DELIVERY_DATE] column is date format, you might want to try,

M-YY = FORMAT( PURCHASEORDERS_ORDERS[DELIVERY_DATE], "M-YY" )