How to use frappe.utils methods in server script

alkuhlani · April 18, 2020, 12:55am

Here Server Script are instructions for server script

I tried to write for example frappe.utils.nowdate() and frappe.utils.data.nowdate() ,but I get error

Is there any another syntax to write a frappe.utils methods

Thanks in advance

neerajvkn · April 18, 2020, 8:25am

share what you have done so far

Akram_Mutaher · April 18, 2020, 9:56am

Try this
frappe.datetime.now_datetime() , frappe.datetime.get_today()

nabinhait · April 19, 2020, 2:44pm

frappe.utils.nowdate() should work. Can you please share the error?

alkuhlani · April 21, 2020, 12:40am

@nabinhait
TypeError: ‘NoneType’ object is not callable

submitted_on is a custom field.

Vishakha_Mishra · June 19, 2020, 10:59am

Hello @alkuhlani,

I am facing this same problem, have you found any solution?

Regards,
Vishakha Mishra

alkuhlani · June 20, 2020, 2:50pm

No

alkuhlani · November 13, 2021, 9:00am

I think now it is working.

indrawow · November 15, 2021, 6:15am

How?
I can’t use frappe.utils.xlsxutils.read_xlsx_file_from_attached_file()

ChillarAnand · November 15, 2021, 6:58am

@indrawow Due to security issues, only selected methods are available in the server script.

https://docs.erpnext.com/docs/v13/user/manual/en/customize-erpnext/server-script#25-security

MartinHBramwell · January 8, 2024, 11:36am

To anyone looking to manipulate dates from within a Server Script, the following is an example of how to jump momentarily from the safe, impossible-to-do-any-harm zone of the Python sandbox into the safe, impossible-to-do-any-harm zone of your entire corporate database:

def getThisMonthRange():
    data = frappe.db.sql("""
                SELECT LAST_DAY(now()) AS last_day
              , DATE(date_add(now(),interval -DAY(now())+1 DAY)) AS first_day;
           """, 
           as_dict=True)
    return data[0]

date_dict = getThisMonthRange()
firstOfMonth = date_dict.first_day
endOfMonth = date_dict.last_day