Support » Plugin: CF7 Spreadsheets » date fields in date format instead of string

  • Resolved jvasquez

    (@jvasquez)


    Hi thanks for the plugin it is phenomenal.

    A query like passing date fields in date format instead of string

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author moshensky

    (@moshensky)

    Hello. The best way to get this – is to change cells format to “date” directly in spreadsheet (for all column), values will be converted automatically.

    Other way – send formula:
    =DATEVALUE("[_date]")
    But in result you’ll get integer value, so you should convert cells to “date” format anyway.

    Thread Starter jvasquez

    (@jvasquez)

    Thank you very much for your kind and prompt reply.

    Thread Starter jvasquez

    (@jvasquez)

    Excuse one more question, before formatting, the data must come in string or number?

    What happens is that the string data has an apostrophe character at the beginning which does not disappear when formatting the date.

    Plugin Author moshensky

    (@moshensky)

    It should work as string (with singlequote symbol).

    I just tested:
    1) Send date as usual string.
    2) Select column, Format->Number->Date in menu
    3) Value changes to 08/26/2020

    Thread Starter jvasquez

    (@jvasquez)

    Actually, if it works, the value changes when formatting is applied, however it does not change automatically despite having previously formatted the entire column, that is, I have to apply the format to the data so that they change.

    Plugin Author moshensky

    (@moshensky)

    Try to figure it out somehow with formulas (you can parse string and process it as date.

    https://stackoverflow.com/questions/48839999/automatically-convert-date-text-to-correct-date-format-using-google-sheets

    Maybe here some useful.
    Sorry, nothing more I can help in this case.

    Thread Starter jvasquez

    (@jvasquez)

    Thank you very much for your help, I used formula and now everything is going very well!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘date fields in date format instead of string’ is closed to new replies.