How to get today date

max_morais_dmm · December 10, 2015, 2:34pm

@mrmo, define your logic based on customer field change!

You can achive this, because you dont have the customer while onload, so you cant call the server to get the credit_days from the customer.

mrmo · December 10, 2015, 3:07pm

@max_morais_dmm I am thankful for your help, maybe I have explained it wrong, let me try again.
I would like to add days based on days that I input in the custom field on the sales invoice document, which I call credit days. I am sorry for the confusion, below is a picture with screenshot for your reference, thank you so much.

max_morais_dmm · December 10, 2015, 6:11pm

frappe.ui.form.on('Sales Invoice', 'credit_days', function(frm){
frm.set_value("due_date", frappe.datetime.add_days(frappe.datetime.nowdate(), frm.doc.credit_days));
})

mrmo · December 11, 2015, 1:53pm

@max_morais_dmm I am very thankful for your help, you are awesome!
When I am finished with this customization project, I will share all for the rest to enjoy.
Thank you!

Hardik_Gadesha · February 24, 2017, 1:29pm

Hello,

How to get month’s first date for report module ?

Thanks,
Hardik Gadesha

JoEz · February 24, 2017, 1:37pm

@Hardik_Gadesha try with frappe.datetime.month_start()

github.com

frappe/erpnext/blob/d5ebd79ad7bda2f13e9b6f4e6487f3aafa3d1bd4/erpnext/stock/report/supplier_wise_sales_analytics/supplier_wise_sales_analytics.js

// Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors
// License: GNU General Public License v3. See license.txt

frappe.query_reports["Supplier-Wise Sales Analytics"] = {
	"filters": [
		{
			"fieldname":"supplier",
			"label": __("Supplier"),
			"fieldtype": "Link",
			"options": "Supplier",
			"width": "80"
		},
		{
			"fieldname":"from_date",
			"label": __("From Date"),
			"fieldtype": "Date",
			"width": "80",
			"default": frappe.datetime.month_start()
		},
		{

This file has been truncated. show original

tmatteson · March 9, 2017, 1:27am

Where can I find documentation on frappe.datetime methods?

littlehera · April 7, 2017, 1:21pm

Hi, @tmatteson!

frappe.utils.data and frappe.datetime have similar methods. You can find the documentation for frappe.utils in: https://frappe.github.io/frappe/current/api/utils/frappe.utils.data

However, we’re both in the same boat. I haven’t found the documentation for frappe datetime methods. I usually just rely on Pycharm’s autocomplete and code suggestion feature. Sometimes, I run console on chrome or firefox just to figure out the different frappe methods.

Hope it helps.

Cheers!

Hera

Mahmoud_Ghoneem · October 24, 2017, 1:39am

hi all

iv done the above steps while im trying to update item delivery date in sales order

i`v created a custom field in item and sales order item called delivery_days and fetched it successfully by

cur_frm.add_fetch(“item_code”,“delivery_days”,“delivery_days”);

and tried the followign script

frappe.ui.form.on(‘Sales Order Item’, ‘delivery_days’, function(frm){
frm.set_value(“delivery_date”, frappe.datetime.add_days(frappe.datetime.nowdate(), frm.doc.delivery_days));
})

it makes the item delivery date today not today + frm.doc.delivery_days

whats wrong with that ??

Mahmoud_Ghoneem · October 24, 2017, 11:12am

so sorry about repost

but i really need this script ASAP

tmatteson · October 24, 2017, 12:56pm

Hey @Mahmoud_Ghoneem

The frappe.datetime.nowdate() and frappe.datetime.add_days are python/ server side code, so they won’t work in your javascript. Sorry, and I understand your confusion about it.

Frappe uses the moment library for client side datetime functionality. The documentation you need to do this is there. Moment.js | Docs

Mahmoud_Ghoneem · October 24, 2017, 1:27pm

Thanks for your reply

but actually its working when i use th following code in custom script for sales order item

frappe.ui.form.on(‘Sales Order Item’, ‘delivery_days’, function(frm){
frm.set_value(“delivery_date”, frappe.datetime.add_days(frappe.datetime.nowdate(), 12);
})

and it works fine Today+12 Day

but actually what i need is to get custom field (delivery_days) instead of 12

what should i do ??

tmatteson · October 24, 2017, 1:43pm

Expected input: delivery days = 12;
Expected output: delivery date = today + delivery_days;

Break this into two lines of code and console.log the intermediate step.

Look for frappe.utils.data.formatdate in the docs, I think that may be where you’re stuck.

Mahmoud_Ghoneem · October 24, 2017, 8:32pm

They are already on two lines

cur_frm.add_fetch(“item_code”,“delivery_days”,“delivery_days”);

And

frappe.ui.form.on(‘Sales Order Item’, ‘delivery_days’, function(frm){
frm.set_value(“delivery_date”, frappe.datetime.add_days(frappe.datetime.nowdate(), frm.doc.delivery_days));
})

tmatteson · October 24, 2017, 9:03pm

Yes, you’re trying to do math inside the setter function, which makes it harder to debug. Pull the math out and log it so you can see where you’re going wrong; that’s what I meant by move it into two statements.

Gavin_Ji · December 30, 2017, 9:31am

hi, i used your code

when i input days like 10 in credit days, due date will automatically add 10 days;
but if i “save” invoice, due date will become the same as posting date.

Please help.

My system:
Installed Apps
ERPNext: v10.0.4 (master)
Frappe Framework: v10.0.5 (master)

Mahmoud_Ghoneem · January 2, 2018, 10:53pm

any updates yet !!!

Vishakha_Mishra · June 19, 2020, 11:09am

HI @rmehta,

This syntax is giving an error in server script, can you suggest me the solution?
Please refer the below code and error.

omar_salama · June 30, 2020, 3:15pm

frappe.datetime.now_datetime()

omar_salama · June 30, 2020, 3:18pm

frappe.datetime.now_datetime()