Set Date Format

ERPNext
1

Hii,

Can any tell me how I  can change date in DD MMM YY format for every module.For example
date on sales order form display like 1 May 15.
For Example If we create new sales order then when we select delivery date then date is 
display like DD MMM YY format like 12 Apr 15.

Thanks

2

I don’t think ERPNext supports DD MMM YY yet, but you can do that in your own print format.

3

thanks rmehta
but If I want to implement then what are the steps I have to to follow for set date format in erpnext.

4

Are you a developer? How familiar are you with frappe framework?

https://frappe.io/tutorial

5

Yes I am developer and have idea about frappe,erpnext.
I have tried this issue for this I have follow following steps:

  1. Doctype List->System Settings->date format->dd mmm yy(option)->save
  2. Now when I create new sales order then date is display as format dd mmm yy but when i pick
    delivery date then correct date format is not selected.
1 Like
6

Second condition for helping is that you will send a pull-request. okay?

7

Yes, In second condition i am simply making a new sales order

8

hi

can any one please suggest me how to convert date to dd-mm-yyyy from js side

thanks
Eliyas

9

{{ frappe.utils.formatdate(doc.get_formatted(‘your date fieldname’), “dd-MM-yyyy”) }}

10

thanks for reply
not for print format i want for report JS side
in the report this error is coming

Date 01-01-2019 must be in format: dd-mm-yyyy

11

Setup → System Settings → Date and Number format section
have you done this!!!

12

yeah there is in this format dd-mm-yyyy

13

can you show your code

14

i am using this code

if (temp_from_date == “” || temp_from_date == null) {
console.log(“fetch_days_data-------------”+fetch_days_data);
var temp_from_date = frappe.datetime.add_days(to_date, -(fetch_days_data));
//temp_from_date = frappe.utils.data.now_datetime (temp_from_date);
temp_from_date = moment(temp_from_date).format(“DD-MM-YYYY”);

15

{{frappe.utils.formatdate(doc.due_date, “dd-MM-yyyy”)}}
try this

1 Like
16

if i am using your code
var date = frappe.utils.formatdate(temp_from_date, “dd-MM-yyyy”);

its throwing this error
TypeError: frappe.utils.formatdate is not a function

17

var date = frappe.utils.formatdate(doc.temp_from_date, “dd-MM-yyyy”);

18

doc undefined error

19

can you send the full code of yours

20

function() {
var filters = report.get_values();
var from_date = filters.from_date;
var to_date = filters.to_date;
var temp_from_date = filters.temp_from_date;
var temp_to_date = filters.temp_to_date;

            var temp_from_date_filter = frappe.query_report.get_filter_value("temp_from_date");
	// console.log("Previous-primary-temp_from_date---------" + temp_from_date);
            var temp_to_date_filter = frappe.query_report.get_filter_value("temp_to_date");
            var fetch_days_data = frappe.query_report.get_filter_value("fetch_days_data");

            if (fetch_days_data != "" && fetch_days_data != null) {
	      
                if (temp_from_date == "" || temp_from_date == null) {
		console.log("fetch_days_data-------------"+fetch_days_data);
                   var temp_from_date = frappe.datetime.add_days(to_date, -(fetch_days_data));
		//temp_from_date = frappe.utils.data.now_datetime (temp_from_date);
		temp_from_date = moment(temp_from_date).format("DD-MM-YYYY");
		var date = new Date();
		var date =  frappe.date.datetime(temp_from_date,"dd-mm-yyyy");
		console.log("mm------------------"+date);
		//frappe.query_report.set_filter_value("temp_from_date"," ");
		//var temp_from_date = from_date;
		//temp_from_date = moment(temp_from_date).format("DD-MM-YYYY")
		console.log("*******temp_to_dtemp_from_date----" + temp_from_date);
		//frappe.query_reports["INDIA-GSTR-2"].filters[5].options = temp_from_date;
		//frappe.query_reports["INDIA-GSTR-2"].filters[5].default = temp_from_date;
		frappe.query_report.set_filter_value("from_date",date);

		//frappe.query_report.set_filter_value("temp_to_date"," ");
		var temp_to_date = to_date;
		temp_to_date = moment(temp_to_date).format("DD-MM-YYYY")
		console.log("*******temp_to_date----" + temp_to_date);
		//frappe.query_reports["INDIA-GSTR-2"].filters[6].options = temp_to_date;
		//frappe.query_reports["INDIA-GSTR-2"].filters[6].default = temp_to_date;
		frappe.query_report.set_filter_value("temp_to_date",to_date);
		/**
                    temp_from_date_filter.df.options = temp_from_date;
                    temp_from_date_filter.df.default = temp_from_date;
                    temp_from_date_filter.refresh();
                    temp_from_date_filter.set_input(temp_from_date_filter.df.default);
		
                    temp_to_date_filter.df.options = to_date;
                    temp_to_date_filter.df.default = to_date;
                    temp_to_date_filter.refresh();
                    temp_to_date_filter.set_input(temp_to_date_filter.df.default);
		**/
		  console.log("temp_from_date---------" + temp_from_date);
                    console.log("temp_to_date---------" + temp_to_date);

                    report.refresh();