current date

[nopposan]

Hi there, everybody.

Please help me to figure out what to do about getting the current date using a calculation; it's just the first step to a larger problem of calculating a date dependent on whether another date is two weeks earlier than today.

The Get(CurrentDate) function calculated in a field that's defined as a date field returns 733168. Formatting the field in my layout as date format mo/da/year only lead to a displayed result of 00/00/0000. What's up with this???

[comment]

Can you post a file showing this? It seems quite impossible: what you describe is what you would get if you set the calculation result to type Number - but then you wouldn't be able to format the field to display as a date.

[nopposan]

Well, sorry to reply to my own thread, but I figured out a solution. I decided to just do a calculation whereby the result is formatted as a date. See screenshot.

WOOPS; Hmm, I *&$@!*^& can't insert an image by pasting a url. WTF!

Anyway, it's just important to format the calculation as a date.

In case you can't read the calculation, it's

If( (Get ( CurrentDate )-Date_Received) ≥ 21;(Date_Received+21);"")

The field is called TurnaroundTime_2wk. 'Guess that's pretty self-explanatory.

'Hope maybe my solution helps someone else, but I'm still not sure how to do it the other way; that is, supposing I had some reason to do it using an automated input to a date field validated by the same calculation.

Thanks for reading my post.

Edited May 6, 2008 by Guest

[nopposan]

'Sorry. I tried to put in a screenshot, but the url didn't take; it displays in my browser. Anyway, I'd have to create a whole new file with the same fields to show you; this one has all kinds of private patient data.

[comment]

So how long does it take to create a new file with 3 fields?