Date to Serial

Question

I'm looking to convert a date to serial .. like this:

21/04/2022 = 3

01/03/2022= 2

10/02/2022=1

25/05/2022= 0 (current month)

I have a report i run  monthly where i need to find the data for the last 3 months and assign a serial number as described above but not sure if this is possible?

any suggestions?

Sebastiaandb · Accepted Answer

Hi @berty ,

Here you go

Greetings,

Seb

DataNath · Accepted Answer

A bit of an extended workaround to get it in the order/format that you want, but this works for your example:

If, in your live data, you have loads of additional months (i.e. not just the most recent 3) and you need to find those as stated then just add a filter after the datetimediff calculation, with the condition that [Serial] =< 3

DataNath · Accepted Answer

@berty have modified the workflow. See if this works?