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?
Go to 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" )
View solution in original post
thanks @CNENFRNL 100% the right answer
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.