SteveGriff Posted December 19, 2001 Posted December 19, 2001 Just a small question, Is there a way of incrementing the day of a Date field by 1? As in the contents of 23/12/01 becoming 24/12/01? Any ideas? Thanxs Steve Griff
cknudsen01 Posted December 19, 2001 Posted December 19, 2001 Hi Steve, Try writing a script which uses Set Field to affect the field that contains the date you want to change. Let's call the field, "DueDate" It could look a little like this... Set Field ["DueDate", "Date(Month(Today), Day(Today) + 1, Year(Today))"] Everytime you run that script it should increase the date by one day. Cheers, Christian Knudsen Toronto, Canada
Vaughan Posted December 19, 2001 Posted December 19, 2001 Arrrrghhh! DON'T USE THE TODAY FUNCTION. Use Status(CurrentDate). Besides all that, wouldn't Set Field [DueDate, DueDate + 1] work just as well? [ December 19, 2001: Message edited by: Vaughan ]
kenneth2k1 Posted December 19, 2001 Posted December 19, 2001 HAHAHA Just a little frustrated with the Today function, Vaughan?? Yeah, the Status(Current Date) works much better, esp. if FM is left open over night, or something.
Vaughan Posted December 20, 2001 Posted December 20, 2001 It's like in a car park you see somebody put their drink onto the car roof, get the keys out to open the door... you just know what's going to happen!
kenneth2k1 Posted December 20, 2001 Posted December 20, 2001 Hey, what are you trying to say.... Ive done that before. (Just kidding.... not with my drink, at least)
Recommended Posts
This topic is 8379 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now