Last complated full week condition

building semantic layer
1

Hi

I want to create a condition, on the universe designer for Last completed week, date query.

The following running for last complated month. How do I make it to weekly.

@Select(Request Detail\Open Date) between PdmToday(-1,1,-1) and PdmToday(1,31,-1)

Thanks

hknk (BOB member since 2014-10-02)

2

Welcome to B:bob:B!

It’s good to mention what database you use because the syntax depends on it.

[Moderator Note: Moved from General Discussion to Semantic Layer / Universe Designer]

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

MSSql 2008 r2

hknk (BOB member since 2014-10-02)

4

Must admit pdmtoday() is a new function for me.

PdmToday() function syntax.

https://support.ca.com/cadocs/0/CA%20Service%20Desk%20Manager%20Analyst%20License%20r12%205-ENU/Bookshelf_Files/HTML/CA_SDM_Release_ENU/index.htm?toc.htm?administration_guide_pdm_functions.html

If its SQL server, then you should be able to use standard SQL server syntax?

https://bobj-board.org/t/152613

Mak 1 :uk: (BOB member since 2005-01-06)