Options
Additional date placeholder
- Additional date placeholder
-
Additional date placeholder
scottkillen > 2020-11-04 08:17
Jean,
I am trying to replace software that I use that replaces macros--after all, QAP does this just even better!
I have replaced the macro that inserts the 15th of the current month with {Now:MMMM 15, yyyy}. I would like to replace a macro that inserts the last day of the month, but I can't quite figure out how to do it. Would it be possible for QAP to expand on AHK's date format so that value is available?
My thought is that QAP could add to the available Standalone Formats listed here and intercept it before defaulting to AHK's date formatting...
...or maybe add control flow logic to snippets?
I don't ask for much!
Scott -
RE: Additional date placeholder
Horst > 2020-11-04 08:29
Why not calling an Autohotkey script which does the calculation ?
Some example here:
https://autohotkey.com/board/topic/2885-...ent-month/ -
RE: Additional date placeholder
Jean Lalonde > 2020-11-04 09:34
Hi,
I see what you want. And I see how the last day of month can be calculated. What I'm trying to figure is the syntax that could be used.
Let's try it: Instead of "{Now:MMMM 31, yyyy}" which returns "november 31, 2020", an non-existing date in the current month November, you could use a placeholder that would be replaced by the last day of the current month. For example "{Now:MMMM {LDOM}, yyyy}" when "{LDOM}" would stand for the "last day of month" -> "november 30, 2020".
Would this work? Supposing QAP is modified to parse placeholders inside placeholders, etc.
Jean -
RE: Additional date placeholder
scottkillen > 2020-11-04 09:38
(2020-11-04 09:34)Jean Lalonde Wrote: Let's try it: Instead of "{Now:MMMM 31, yyyy}" which returns "november 31, 2020", an non-existing date in the current month November, you could use a placeholder that would be replaced by the last day of the current month. For example "{Now:MMMM {LDOM}, yyyy}" when "{LDOM}" would stand for the "last day of month" -> "november 30, 2020".
Jean,
That is what I was envisioning, assuming placeholders worked inside placeholders.
Scott
(2020-11-04 08:29)Horst Wrote: Why not calling an Autohotkey script which does the calculation ?
Some example here:
https://autohotkey.com/board/topic/2885-...ent-month/
That would work, assuming I could get QAP to replace the hotstring with AHKs output, instead of a MsgBox lilke in the script.
Also concerned that it would not be as responsive as QAP automatically doing it.
Jean,
I could also use "{Now:MMMM} {LDOM}, {Now:yyyy}" and eliminate the requirement of placeholderrs within placeholders.
Scott -
RE: Additional date placeholder
Jean Lalonde > 2020-11-04 10:00
> I could also use "{Now:MMMM} {LDOM}, {Now:yyyy}" and eliminate the requirement of placeholderrs within placeholders.
Good point. Added to the wishlist:
https://forum.quickaccesspopup.com/showt...p?tid=1326
Thanks. -
RE: Additional date placeholder
Jean Lalonde > 2020-11-04 10:02
PS: For those looking for more info about date placeholders, see:
Can I insert values in favorites location, parameters or snippets using placeholders? -
RE: Additional date placeholder
LaurentG > 2020-11-04 10:13
I'm not using such features of QAP, so maybe what I mention is stupid, please be indulgent, but isn't it possible in QAP, as I do in Excel, to get last day of month as the day before first day (which is always the 1, whatever the month) of next month (month + 1) ? With of course a specific case for December, for which "month + 1" is actually Month 1 of Year + 1 -
RE: Additional date placeholder
Jean Lalonde > 2020-11-04 10:47
> isn't it possible in QAP, as I do in Excel, to get last day of month as the day before first day
This would be possible in AutoHotkey (as an alternative to the examples posted by Horst earlier. But date calculation in QAP is not possible. Only the "Now" and "Now UTC" values are available. -
RE: Additional date placeholder
Jean Lalonde > 2022-03-10 16:44
> I could also use "{Now:MMMM} {LDOM}, {Now:yyyy}" and eliminate the requirement of placeholderrs within placeholders.
I'm working on this. Instead of "{LDOM}" suggested by Scoot, I choose this format: "{Now:ld}" (lowercase LD for last day) that is more coherent with other date-time placeholders syntax and will support calculation if we want to insert the last day of a future or past month, for example:
"{Now:MMMM} {Now:ld}, {Now:yyyy}" -> March 31, 2022
"{Now+1M:ld} {Now+1M:MMMM}" -> 30 April -
RE: Additional date placeholder
Jean Lalonde > 2022-03-14 18:27
Last day of a month in the {Now:} placeholders is now included in v11.5.6.