Kinetic Dashboard filter - How do I do it by 'First Day of the week'?

Kinetic ERP
, ,
1

Hello,

I am trying to recreate a clasic dashboard into Kinetic 2025.2.10

It uses a filter on it of Constant.FirstDayOfWeek

image

I couldn’t find much on here on how this translates into the Kinetic dashboard BAQ Where List.

Does anyone know how it should be formatted?

Or does it just not work in the where list?

Any help is appreciated!

2

This should do it, but I can’t test at the moment properly.

edit: Fixed

image
image474×601 10 KB

1 Like
3

Hello,

That was the missing piece!

The only difference from what I was trying was the question mark.

Thank you again for the help.

I really do appreciate it!

1 Like
4

Another question, if possible, do you know where I can get a list of Contants used by Epicor Kinetic?

5

Open a BAQ and go into Calculated Fields editor as if you were creating a new field. There’s a long list of things under BAQ Constants…goes well past Country Code in the screenshot and includes the aforementioned FirstDayOfWeek.

image
image501×562 9.21 KB

2 Likes
6

@JMPCONJ THANK YOU!!!

That was exactly what I needed to see.

Hopefully it will help the next person find them.

1 Like