Search found 10 matches
- Jan 15th, ’24, 09:20
- Forum: General Discussion
- Topic: Excel lookup using INPUT date, to populate Text Expansion
- Replies: 6
- Views: 1955
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 . ...
- Jan 12th, ’24, 08:57
- Forum: General Discussion
- Topic: Excel lookup using INPUT date, to populate Text Expansion
- Replies: 6
- Views: 1955
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 ...
- Jan 8th, ’24, 08:19
- Forum: General Discussion
- Topic: Excel lookup using INPUT date, to populate Text Expansion
- Replies: 6
- Views: 1955
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 ...
- Jan 4th, ’24, 16:05
- Forum: General Discussion
- Topic: Excel lookup using INPUT date, to populate Text Expansion
- Replies: 6
- Views: 1955
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...
- Feb 26th, ’21, 15:08
- Forum: General Discussion
- Topic: Date Format with Ordinal Indicators?
- Replies: 6
- Views: 3817
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...
- Feb 25th, ’21, 08:16
- Forum: General Discussion
- Topic: Date Format with Ordinal Indicators?
- Replies: 6
- Views: 3817
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.
- Feb 25th, ’21, 07:56
- Forum: General Discussion
- Topic: Date Format with Ordinal Indicators?
- Replies: 6
- Views: 3817
Re: Date Format with Ordinal Indicators?
Thanks Tom, I do like to be challenging
I'll give that a shot.
Thank you again.
I'll give that a shot.
Thank you again.
- Feb 24th, ’21, 12:22
- Forum: General Discussion
- Topic: Date Format with Ordinal Indicators?
- Replies: 6
- Views: 3817
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!
How would I go about including the ordinal indicators (st, nd, rd, th)?
Thanks!
- Feb 22nd, ’21, 14:32
- Forum: Announcements
- Topic: FastKeys 5.01 Released
- Replies: 6
- Views: 14851
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?
- Feb 22nd, ’21, 08:09
- Forum: Announcements
- Topic: FastKeys 5.01 Released
- Replies: 6
- Views: 14851
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...