Search found 10 matches

by GapsOfTheGod
Jan 15th, ’24, 09:20
Forum: General Discussion
Topic: Excel lookup using INPUT date, to populate Text Expansion
Replies: 6
Views: 1930

Re: Excel lookup using INPUT date, to populate Text Expansion

You just need to set the initial value for Date variable to A_Now before applying the EnvAdd calculation. ; Split the SELECT_RnlDt string into an array using "/" StringSplit, COL, SELECT_RnlDt, / ; Combine the parts of the date into a single variable in the format yyyymmdd Date := COL3 . ...
by GapsOfTheGod
Jan 12th, ’24, 08:57
Forum: General Discussion
Topic: Excel lookup using INPUT date, to populate Text Expansion
Replies: 6
Views: 1930

Re: Excel lookup using INPUT date, to populate Text Expansion

Currently it is possible to use Excel File Lookup macro to lookup for one column in Excel and then return any other column. We may be expanding the possibilities in the future. ;) Thanks Tom. I've got to the following, but no matter what date value I enter into SELECT_RnlDt (htat's more than today ...
by GapsOfTheGod
Jan 8th, ’24, 08:19
Forum: General Discussion
Topic: Excel lookup using INPUT date, to populate Text Expansion
Replies: 6
Views: 1930

Re: Excel lookup using INPUT date, to populate Text Expansion

Thanks Tom. Is there no way of retrieving these date values (already calculated within an excel file), based on a keyed Renewal Date value? For example, the value for the working day prior to renewal date, as calculated in my excel file, takes into account UK Bank Holidays, and days that I'm out of ...
by GapsOfTheGod
Jan 4th, ’24, 16:05
Forum: General Discussion
Topic: Excel lookup using INPUT date, to populate Text Expansion
Replies: 6
Views: 1930

Excel lookup using INPUT date, to populate Text Expansion

Hello everyone, I currently use a text expansion setup for my email templates, incorporating INPUTS and SELECTS for dynamic content. Additionally, I maintain an Excel file containing calculated date offsets, such as the latest working day before the Renewal Date. Currently, I trigger this Excel data...
by GapsOfTheGod
Feb 26th, ’21, 15:08
Forum: General Discussion
Topic: Date Format with Ordinal Indicators?
Replies: 6
Views: 3790

Re: Date Format with Ordinal Indicators?

Thanks Tom, that's getting me the following: --------------------------- FastKeys.exe --------------------------- Error at line 153. Line Text: <html> <head> <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type"> <title>Debt C... Error: Invalid `%. The program w...
by GapsOfTheGod
Feb 25th, ’21, 08:16
Forum: General Discussion
Topic: Date Format with Ordinal Indicators?
Replies: 6
Views: 3790

Re: Date Format with Ordinal Indicators?

Please could you point me in the direction of where I can work out how to combine this ordinal formatting with the dateshift feature? Basically, within the body of a text expansion, I want to show today+7, formatted with that ordinal format you've kindly given to me above.
by GapsOfTheGod
Feb 25th, ’21, 07:56
Forum: General Discussion
Topic: Date Format with Ordinal Indicators?
Replies: 6
Views: 3790

Re: Date Format with Ordinal Indicators?

Thanks Tom, I do like to be challenging :lol:

I'll give that a shot.

Thank you again.
by GapsOfTheGod
Feb 24th, ’21, 12:22
Forum: General Discussion
Topic: Date Format with Ordinal Indicators?
Replies: 6
Views: 3790

Date Format with Ordinal Indicators?

Hi all, I want to format a date as follows: Wednesday, 24th February 2021.

How would I go about including the ordinal indicators (st, nd, rd, th)?

Thanks!
by GapsOfTheGod
Feb 22nd, ’21, 14:32
Forum: Announcements
Topic: FastKeys 5.01 Released
Replies: 6
Views: 14449

Re: FastKeys 5.01 Released

Thanks, however I'm running the portable version and there appears to be no other exe file, other than the version which opens v5.01. Where will I find my phrases from v4 please?
by GapsOfTheGod
Feb 22nd, ’21, 08:09
Forum: Announcements
Topic: FastKeys 5.01 Released
Replies: 6
Views: 14449

Re: FastKeys 5.01 Released

Despite being met with a message this morning that v5.01 was available, and that none of my settings would be lost, I've lost every one of my, roughly, 150 Text Expansion phrases and shortcuts. I've created a forum account just to express my sheer disappointment, as I'd hoped to purchase the softwar...