cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Current Date

SOLVED
BG_9641770
Participant

Current Date

Hi all 

 

what is best way to get mathcad to reference todays date?

 

I want to add a function that removes functionality of the sheet after day 6 months should another user try to access it. So will write a statement like the following 

 

If todays date is > 01/01/2022 then etc...

 

 

Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions

Re: Current Date

Here is an example of my last suggestion

Werner_E_1-1614255968809.png

 

 

View solution in original post

11 REPLIES 11

Re: Current Date

Are you talking about real Mathcad or just Prime?
In Mathcad you could use a scripted component to get and return the current date.

In Prime you can use the time() function which gives you the number of seconds since 1.1.1970. You can now write a routine to get the current date using the number returned by time(0).

You can find solutions for both approaches by searching in this forum.

Another way is using an Excel component with the current date in a cell. Kind of using a sledgehammer to crack a nut 😉

For your purpose you won't need the current date, though. Simply add the number of seconds in six months to the result given by time(0) now. If the result of time(0) exceeds this number, its six months later. You may be generous and use 31 days for a month 😉

 

Re: Current Date

Hi its in Mathcad Prime 6.0.0.0

 

 

Re: Current Date

So you can't use the first suggestion (scripted component).

But the other three still apply

Re: Current Date

can you upload an example sheets please 🙂 

 

sorry to be cheeky 

 

Thanks

 

Re: Current Date

Here is an example of my last suggestion

Werner_E_1-1614255968809.png

 

 

View solution in original post

Re: Current Date

Hi,

 

Enclosed is a number of date functions from the reference quoted at the top of the sheet.

They are a conversion from date functions from Mathcad.

Hope you can find them useful.

They will allow detecting passage of exactly 6 months.

 

Cheers

Terry

Re: Current Date


@terryhendicott wrote:

Hi,

 

Enclosed is a number of date functions from the reference quoted at the top of the sheet.

They are a conversion from date functions from Mathcad.

Hope you can find them useful.

They will allow detecting passage of exactly 6 months.

That's true, but for the purposes of the questioner, however, I guess it is essential to determine the current date and unfortunately I cannot find anything in the file for this. It is herewith added:

Werner_E_0-1614674904087.png

 

Since only the time () function is used here, the result is unfortunately limited to GMT (Universal Time UTC). Now I don't see any possibility of determining the time zone currently set on the computer without using a scripted component or an Excel component.

Re: Current Date

Hi,

 

As the date functions are used in a "included" worksheet referenced in when the functions are used you can for one time only at any site set a variable GMT to the + or - hour.  This would need to be reset if daylight saving or DS variable 0 or +1 is used in the file.  

 

Who wants to take up the challenge.

 

Cheers

Terry

Re: Current Date

This is a marvelous set of functions!

 

Express, however, will not accept programming.

 

Attached is a file that implements these functions in Express.  My thanks, Terry!

Re: Current Date

@Fred_Kohlhepp 

Looks like you have a wrong sign in the DaysBefore() function and this seems to be the reason why you had to change the Timebase to be two days off.

Werner_E_0-1614782001691.png

 

Re: Current Date

Thank you!  Good catch!

Announcements
Check out the latest
Mathcad Tip
"PTC Mathcad 15 / Prime 1-6 Update."