Solved: Formatting date - Page 2

Natt_Boarer · 04-11-2021 06:18 AM

I’m trying to get my date to format correctly to be a scrambled batch code.

I want it to read YDDMM where Y= year I.e currently 1 (2021)

I’ve managed to get it to show the whole date using concatenate but I’m struggling to omit the YYY and just get the year.

This will then be combined with a prefix & suffix which I seem to have working ok.

Any suggestions…

Suvrutt_Gurjar

Please take a look at the TEXT() functions.

In general, your desired format could be achieved by something like

RIGHT(TEXT([Date Column], “YYDDMM”),5)