Jump to content

How to show today's date in worksheet with spreadsheet setup


Recommended Posts

Hello,

 

Is there a way to show today's date in worksheet cell with spreadsheet setup?

 

We are using this functions: =FORMATFIELD('Title Block Project Data'; '...') to get some data from title block border ... but would be great if we could add today's date too .... to the header of the worksheet layout with list of drawings (database part) as a main part of worksheet.

 

I guess it doesn't have to be connected to title block border data, but all we need to get today's date displayed + so that it automatically updates to correct date.

 

Any help much appreciated.

Link to comment
  • Vectorworks, Inc Employee

You can have a data tag that reports the today's date. Then you can use the DataTagField function with a criteria defined to get the value from the data tag. But you will still have to reset the data tag (for example by moving it) to get the date to update I think.

Link to comment

Or create a single line Vectorscript:

 

WSScript_SetResStr(Date(2,0));

 

In my case this was named Script-2

 

So I used a worksheet formula of:

 

=RUNSCRIPT('Script-2')

 

The parameters of the Date Function are for the Date and Time formats.

 

For the first Parameter, 0=Full Date, 1=Abbreviated Date, 2=Short Date

For the second Param 0=Date only, 1=Date & Time, 2=Time Only

 

The date is formatted according to your operating system settings.

 

I thought there was a way to enter a single line script like this directly into the RunScript function, but I can't make it work this morning.

  • Like 3
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...