terrypin Posted November 4, 2011 Report Share Posted November 4, 2011 I've been floundering around with this for most of the day and it still eludes me. For anyone who can come up with a working macro, or practical advice on how to write it, by way of payment I'll send them a 30 second video of a Google Earth tour over their home town or any location of their choice, as well as my warm thanks! I have a date in text form, as 3 separate integers: nDay, nMonth and nYear. I want to calculate the number of days since a fixed previous date. I thought the easiest way would be to convert both dates to Date/Time variables and use Variable Modify Date/Time to make the subtraction. But ME Pro still has no option for inputting a text string. Has anyone written a reliable and easily adaptable subroutine to achieve this, that they're happy to share please? Otherwise I'll ditch that approach and calculate directly. Such a pity that Date/Time variable has no option for this! All it needs is a 'Variable' option within the 'Use a specific date time' option. Hmm - maybe there's some way to dynamically enter that field as part of the running macro? -- Terry, East Grinstead, UK Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.