Link calendar to table

[joeybird]

Hiya

i am using the following calendar...

Calendar: DECLARE FIELD DEFINITION TAGGED '$date' Parameters first_month_of_year = 1 Fields

     Year($1) As Year Tagged '$year',

     Month($1) as Month Tagged '$month',

     Date($1) as Date Tagged ('$date', '$day'),

     Week($1) as Week Tagged '$week',

     Weekday($1) as Weekday Tagged '$weekday',

     DayNumberOfYear($1, first_month_of_year) as DayNumberOfYear Tagged ('$numeric');

DERIVE FIELDS FROM FIELDS [Date_Received] USING Calendar;

i need to link Weekday from this calendar to my main Orders table. is there a way to do this please?

Kind Regards

Joeybird

[Anonymous · Accepted solution]

The only thing you need to do is to create Weekday field in the Order table.  For example, if you have OrderDate field, you can use this:

Weekday(OrderDate) as Weekday

[joeybird]

Hiya

fab xx

Thank you

Kind Regards

Joeybird