Possible to generate every business date for 2023?

[wonka1234]

Hi,

I am trying to generate every business date for 2023.

Then take my data (2 dates) and fill the value for all dates between these 2 dates.

So the result would look something like this:

Testers	2023_10_02	2022_10_03	2022_10_04	..	..	2023_11_03	2023_11_04
Louis Stevents	0.4	0.4	0.4	0.4	0.4	0.4

whith 2023-11-04 blank as the .4 doesnt fall in here.

Edit - able to get .4 for every business date, but that isnt right.

my placeholder formula doesnt seem to be working!

[geraldo · Accepted solution]

@wonka1234 

An worflow Example for generating date lines without year hardcode

[wonka1234]

@geraldo  thx, is it possible to show 0 for every other business date?

[RobertOdera]

Hi, @wonka1234 

Kindly consider the below:

1. Add a Sort Tool and sort Descending by Date.

2. Add a Record ID Tool (and start the count at an odd number if you need the [Field] value in this row to stay the same OR start the count at an even number if you need the [Field] value in this row to be zero).

3. Add a Formula Tool and use this treatment to update the [Field] value (or create a separate new field)

- Update existing Field

IF Mod([Record ID],2) = 0 THEN 0

ELSE [Field]

ENDIF

- Create a new Field

IF Mod([Record ID],2) = 0 THEN 0

ELSE [the existing that you need to alternate between zero and itself]

ENDIF

I hope you find this helpful - cheers!