Hi All.
How is it going? I've been busy getting ready for the Holiday Season. I'm going to say Christmas! Yes, I don't care if it is political correct or not. In America, the majority of the citizens celebrate Christmas.
Anyway, my family is doing fine. My mom is coping well with the loss of her husband of 55 years. My children and husband are in good health. Not much more I could ask for.
Work has been busy. I have that project with the definable workflow on the back burner for now. Putting out other fires..
I responded to a person on Notes.net today that wanted to know how to get the first day of Next Month. Like if today is December 15, then want a date of January 1st.
Wrote this up quickly for him:
vdate := @Adjust(@Today;0;1;0;0;0;0);
vdtext := @Text(vdate);
newvdate := @Word(vdtext;"/";1) + "/01" + @Word(vdtext;"/";3);
@TextToTime(newvdate)
Anyway, I hope everyone has a fabulous "Winter Holiday" and a Great New Year.
The times, they are a-changin....
17 hours ago
2 comments:
couldn't find the notes.net entry, so maybe I try posting another way here:
@Adjust(@today;0;1;-@Day(@today)+1;0;0;0)
Sorry if I misuderstood the question at the basis. Got to your site by linkhopping, and sure will be coming back :) thx for your bloggin!
Very slick, Manu! It works because the arguments of @Adjust are applied right to left.
We don't like formulas that parse text dates, because they don't work the same for everyone.
Post a Comment