How is it posible to use WORKDAY_CALENDAR and WORKDAY_CALENDAR without problems.

How is it posible to use WORKDAY_CALENDAR and WORKDAY_CALENDAR without problems.? I want to use both calendars at the same time.

I have use INTERSECT, and i have join both calendars adding the id_calendar to the tables, but i get always the same error.

Error in formula

To use the calendar ID column [constant SP-MAD], it must have a join relationship to the table containing the timestamp column ["IssuesFunes"].

The formula is the following.

REMAP_TIMESTAMPS (

"IssuesFunes"."created" ,

HOURS ,

INTERSECT ( WORKDAY_CALENDAR ("WDCalendar") , WORKDAY_CALENDAR( "WORKDAY_CAL_TFACS" ) ) ,

'SP-MAD'

)

Hello Enrique.

Yes, possible to use together. In the documentation, we see an example using the same functions twice, inside an "Intersect".

Looks like the error is not related to the intersect/calendars , but to the relationship between tables (calendars and the table with the timestamp)

Tks. D

Hola Daniel,

Thanks, i will check it.

Sign up