converting text dates to formula

Steve Berer
over 2 years ago

Hi all.
I would like to convert a range of text dates in the format:  <Dec 10, 2018 > to the standard QPW formula date, which unformatted would be <43444>. Now, I could figure out how to write an equation using text parsing (I think), but is there some easy, automated way of making this conversion over a rather long range of cells?
Thanks.
Steve Berer

  • over 2 years ago

    Oh: I'm using X9 on Windows 10.
    best,

    Steve

  • over 2 years ago

    Look at the @DateValue function.   See the formats accepted in help.  Use text parsing to get your date into this format.   It looks like either 10-Dec-2018 or 10-Dec-18 will work for your example.

    Or post your query over at WPUniverse.com where you are likely to get a more timely response and better advice than I can give.

  • over 2 years ago

    Chapter 9 of my free book on QP formulas, functions, and macros deals with conversions between text and numbers, including an article on @DATEVALUE. It contains an article with a number of sample formulas entitled "How to convert text dates/times into numeric dates/times."  Several of the samples are close to your example.

    It would be great if Corel would expand the formats that @DATEVALUE can use. That would make this common task simpler.

    Construct a working function in a cell to the right of the first cell in your range of cells.  Then copy that function down (usually) in parallel to the entire range of date-text cells.

    The book is here: http://corklaw.com/Tech/QP/QP_FormulasFunctionsMacros.pdf

    Charlie

© Corel Corporation. All rights reserved. The content herein is in the form of a personal web log ("Blog") or forum posting. As such, the views expressed in this site are the views of the participants and do not necessarily reflect the views of Corel Corporation, or its affiliates and their respective officers, directors, employees and agents. Terms of Use / Privacy​ ​/ ​Cookies / Terms of use.