Date to format as yyyymm [RESOLVED]

Get Help
, , ,
1

Hi everyone,

I have a "Unique ID) field that has to show: test-yearmonth-000001 (test-202309-000001)
I’m not able to show …-202309-…

This “yearmonth” comes from a “date” field. Then, in the Unique ID settings, I’ve wrote:
…-{ID:DATE}-…
I’m tried to format this date:
…-{ID:DATE:format;ym}-…
…-{ID:DATE:format;y-m}-…
…-{ID:DATE:format;yyyy-mm}-…

But I’ve not been able to figure out how to do this. Any help would be appreciated.

Thank you

2

You should use your merge tag as follows: :point_down:

Unique ID-{ID:DATE:format;Ymd}-000001

This will format the date as 202309 for the date 23rd September 2023.

3

Thanks Faisal,

I write this:
-{ID:75:format;Ymd}-
And obtain this:
-24/09/2023-000001

If I try this:
-{ID:75:format;ymd_dash}-
I obtain the same:
-24/09/2023-000001

Any idea?
Thanks!

4

Can you try the following instead, using y and m only:

{ID:75:format;ym}-000001

5

Hi,

We have a snippet you can use to display dates in any formats, which should work for you. With the snippet on your website, the merge tag below should work;

-{:75:Ym}-

3 Likes
6

I’ll try.
Thanks!

7

Works correctly.
Thanks!

2 Likes