Date Format in DD/MM/YYYY

How To
1

I am using {{formatDate(now; “DD/MM/YYYY”)}} to get the current date in the DD/MM/YYYY format in Zoho Invoice.

However, the date on the invoice is 04/03/2025 for today i.e 3rd April.

i can not confirm this, but I had added this on March 31 and the invoices were correctly generated then - the date was 31/03/2025

3

Hi @Reboot_Backend

Please share the screenshots of the scenario setup and JSON input/output of the module that generates the invoices.

4

Screenshot 2025-04-03 192245
Screenshot 2025-04-03 1922451790×881 132 KB

Screenshot 2025-04-03 192200
Screenshot 2025-04-03 1922001810×806 102 KB

PArt of the Woocommerce output

{
        "id": 11955,
        "status": "processing",
        "currency": "INR",
        "version": "9.7.1",
        "total": "1000.00",
        "billing": {
            "company": null,
            "city": "Delhi",
            "state": "DL",
            "postcode": null,
            "country": "IN",
            "email": "aayushcodes@gmail.com",
            "phone": "+919871771110",
            "firstName": "Aayush Gupta",
            "lastName": null,
            "address1": "48, Bhawani Kunj, Vasant Kunj",
            "address2": null
        },
        "shipping": {
            "company": null,
            "city": null,
            "state": null,
            "postcode": null,
            "country": null,
            "phone": null,
            "firstName": null,
            "lastName": null,
            "address1": null,
            "address2": null
        },
        "number": "11955",
        "refunds": [],
        "parentId": 0,
        "pricesIncludeTax": true,
        "dateCreated": "2025-04-02T11:32:45.000Z",
        "dateModified": "2025-04-02T11:33:18.000Z",
        "discountTotal": "0.00",
        "discountTax": "0.00",
        "shippingTotal": "0.00",
        "shippingTax": "0.00",
        "cartTax": "0.00",
        "totalTax": "0.00",

Zoho Invoice input

[
    {
        "date": "2025-03-03T18:30:00.000Z",
        "send": false,
        "line_items": [
            {
                "rate": 847.457627118644,
                "tax_id": "898466000000263103",
                "item_id": "898466000000103085",
                "quantity": 1,
                "description": "Chandrima Das for Anxiety"
            }
        ],
        "customer_id": "898466000002720154",
        "template_id": "898466000001504015",
        "payment_options": {},
        "is_inclusive_tax": false,
        "ignore_auto_number_generation": false
    }
]

Zoho Invoice output

{
        "invoice_id": "898466000003431001",
        "invoice_number": "RW/2025-26/00004",
        "date": "2025-03-04",
        "due_date": "2025-03-04",
        "offline_created_date_with_time": "",
        "customer_id": "898466000002720154",
        "customer_name": "Aayush Gupta",
        "customer_custom_fields": [],
        "customer_custom_field_hash": {},
        "email": "aayushcodes@gmail.com",
        "currency_id": "898466000000000099",
        "invoice_source": "Api",
        "currency_code": "INR",
        "currency_symbol": "₹",
        "currency_name_formatted": "INR- Rupees",
        "status": "draft",
        "unprocessed_payment_amount": 0,
        "custom_fields": [],
        "custom_field_hash": {},
        "recurring_invoice_id": "",
        "is_last_child_invoice": false,
        "place_of_supply": "DL",
        "payment_terms": 0,
        "payment_terms_label": "Due On Receipt",
        "payment_reminder_enabled": true,
        "payment_made": 0,
        "zcrm_potential_id": "",
        "zcrm_potential_name": "",
        "reference_number": "",
        "lock_details": {},
        "is_progress_invoice": false,
5

@Reboot_Backend Zoho API docs say the date should be formatted like this - YYYY-MM-DD
image

1 Like
6

Correct.
I removed the formatting part in the Date field, and kept only “now”.

Works fine.

Thanks!

4 Likes