Combine two fields to create new date field, is it possible?

Combine two fields to create new date field, is it possible?

Question - Is there any way to take two fields, Month and Year, and create a true date field in Forms or a Forms document merge with Writer? Example:

Month Field: Jan
Year Field: 2022
Create New Date Field: 01/01/2022

Note: day of the month is irrelevant and can always default to 01

No, I cannot use an actual date field (see history below if interested). I know I can do this outside of Forms/Writer but would prefer not to if at all possible due to considerable time investment for what's already in place and the time that would be required to change everything.

Thanks for any help.

Daniel

History - We have a Zoho Form that includes several pseudo "date" fields. In constructing the form I was told our applicants may not know the exact date for some of the questions and that we only needed the Month/Year. With that in mind I created the date fields and included hints/instructions to only match the Month/Year and that the exact day was not important. I was told that would be to complicated/confusing for those filling out the application and it must be Month/Year only. I informed everyone that wasn't possible as a date field and I would have to cobble something together. So I did.

I created drop downs such as Month of Diagnosis, with months of the year, and Year of Diagnosis, with year options as appropriate for each question. Though not pretty, this satisfied their desire for Month/Year only and was fine for everything they wanted/needed at the time.

I took that form and created a document merge with Writer that included all of the information from the form and automated a rubric for scoring. I spent a good deal of time creating conditions to boil down a form with 170+ fields/choices and untold combinations to 24 scores. There are also other automations that include saving copies to a MS SharePoint site, creating direct links to each document, and emailing various parties with info and links. Everything was good...until they came back and asked for calculations based on those "dates". So now I need a true date to be able to count time, specifically months. BTW - I have to leave the date fields as they are, drop downs with Month/Year. 

I haven't been able to find a way to do this via Forms or Forms/Writer document merge. I know this can be done in another program but I would like to avoid having to completely rework everything I've already done.

Thanks for any help/suggestions.

Cheers,

Daniel
    • Sticky Posts

    • Transitioning from MS Word to Writer: A complete walkthrough

      Hello everyone! We understand moving to a new word processing tool can be difficult, especially if it means switching from a legacy software like MS Word. That's why we've organized an exclusive webinar where we talk you through ways to make your switch from MS Word to Writer as easy as possible. In this webinar, you'll learn: - Why Writer is a simple yet powerful alternative to MS Word. - How to locate your favorite MS Word features and functions in Writer.  - How to migrate your Word documents
    • Writer Designer's Update 2018: What's Changed with Page Settings

      Hey there, Writers! =] As a part of the Writer Designer's Update 2018, here's everything new and improved with Tables in Writer: 1. Customizable horizontal lines  While horizontal lines act as separators for different sections in a document, they also make your document more visually appealing and easier to read. Keeping that in mind, we've now added some handy customization options for horizontal lines in the form of line weight, color, pattern, and alignment. 2. Beautiful page borders Give your
    • Do more with Zoho Docs

      Hello Everyone, Thanks for participating in our live webinars, posing questions and giving feedback. We look forward to having you with us in the next live webinar from Zoho Docs. ​ This webinar will help you learn how to: Set up your organization profile Create organizational policies Organize files for easy access Work together on files for improved productivity Assess performance with activity reports Create appealing content with the Zoho Office Suite   Day : Thursday, 8th February 2018 Time :
    • Zoho Clipboard App has been discontinued

      Hello there! Thanks to everyone who wrote to us. We could see you had trouble installing, and using both Zoho Writer and Zoho Clipboard Apps at the same time via Chrome Web Store. To avoid this conflict, we have decided to, as you've already guessed, discontinue the App, and bundle it with the Zoho Writer App itself. Chrome users will only need the Zoho Writer App now to enable Copy and Paste on right click. Here's the how to remove the Clipboard App: 1. Go to your Chrome Apps page by clicking on
    • First Look: The New and Improved Zoho Writer

      Preview the all-new Zoho Writer to see our cleaner, more stylish, and more intuitive interface. Click the Try New Version link on top of your Writer window and switch to a better experience.  Here's all that's new: Revamped UI With a brand new look, comes a whole new approach – introducing modes, a simpler way to write. The Compose mode gives you a space to write without distractions. Switch to the Review mode when it's time to add other people to the equation, and get feedback from your peers. When

      Zoho SalesIQ Resources



            Zoho TeamInbox Resources

              Zoho DataPrep Resources


                  Zoho CRM Plus Resources

                    Zoho Books Resources


                      Zoho Subscriptions Resources

                        Zoho Desk Resources

                          Zoho Projects Resources


                            Zoho Sprints Resources


                              Zoho Orchestly Resources


                                Zoho Creator Resources


                                  Zoho WorkDrive Resources




                                      Zoho Campaigns Resources

                                        Zoho CRM Resources

                                                    Design. Discuss. Deliver.

                                                    Create visually engaging stories with Zoho Show.

                                                    Get Started Now


                                                      Zoho Show Resources


                                                        Zoho Writer Writer

                                                        Get Started. Write Away!

                                                        Writer is a powerful online word processor, designed for collaborative work.

                                                                  有料プランをご利用の方