• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

Date Formatter

akgshanmuga

Member
Hi Pabbly Team,

I encounter an issue in my workflow in Date Formatter Section.(Workflow name: Transport Operator Permit Reminder)

When using "Filter" to calculate the number of days between given two dates, Filter function gives result only if the date is in MM/DD/YYYY format and if it is in DD/MM/YYYY format, it doesn't do the calculation.

Can you please throw some light on this?

Thanks
 

akgshanmuga

Member
Hi Pabbly Team,

Any update regarding my query about Date Formatter issue?

When using "Filter" to calculate the number of days between given two dates, Filter function gives result only if the date is in MM/DD/YYYY format and if it is in DD/MM/YYYY format, it doesn't fetch the result.

Can you help me to resolve the issue?

My workflow name: Transport Operator Permit Reminder

Thanks
 
P

Pabblymember11

Guest
Hey @akgshanmuga

It's an excel format issue and the" DD/MM/YYYY" doesn't work with the excel formula, Try to use the date in "MM/DD/YYYY" or in "YYYY/MM/DD" format which is ISO date format. We are simply using the formula provided by the spreadsheet plugins and it seems that this format of date is not compatible with it.

As a reference, you can check out the following blog here - https://www.lifewire.com/entering-dates-with-the-date-function-3123948

Thanks!!
 
Top