Initvalue day of the week

sarahgabr

Hello,

I would like to set a table field as todays day of the week, how do I do that?

SteveKnott

Virtual Date table... filter on type = Day and Todays date... will show the periodNo = day of week no from memory...

RockWithNAV

Either you can go with Date Virtual Table ti achieve this OR Have a look on this

https://rockwithnav.wordpress.com/2016/04/14/handle-datetime-use-dotnet-variable/

sarahgabr

What am I supposed to do with date virtual table, is there a walk through as I am a newbie.

RockWithNAV

Ok Can you explain your requirement a level more please.

Are you inserting data in a Table and then you want to insert a day of the Week or something else?

Kishorm

1) Create a function called InitRecord (or something similar) on the table

2) In the InitRecord function, add the following line of code...

"Day of Week" := DATE2DWY(TODAY,1);

3) On the Page where uses create new records, call the InitRecord function in the OnNewRecord trigger

4) If you are adding records in code, then...

MyTable.INIT;
MyTable.InitRecord;
...set additional fields here
MyTable.INSERT;

Kishorm

Note - you can't use the InitValue property for what you want to do because this can only be used to default to fixed values and what you want to do is default to a dynamic value (based on the current day of the week) so that's why you have to do it via the above code.