topic Re: Link calendar to table in App Development

Link calendar to table

joeybird — Thu, 21 May 2015 21:26:21 GMT

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 — Thu, 21 May 2015 22:05:13 GMT

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 — Fri, 22 May 2015 10:45:00 GMT

Hiya

fab xx

Thank you

Kind Regards

Joeybird