Format date in google spreadsheet

[ad...@wakefieldfamily.org]

Hi,

I have a date widget that I write to a google spreadsheet but the date is not formatted properly.

In another thread I got this information, but I don't know where to add this code in the web interface.

Quote:
Could you execute that code when getting dates : get_date(my_date,"MM/dd/yyyy")? For your information :

get_date(second,format): returns a UTC date where second is the number of seconds elapsed since January 1st, 1970 and format is date format to be returned (cf. Java norm): get_date(31539600,"yyyy-MM-dd HH:mm:ss"). Inverse function is get_time().

Please advise where in the web interface I should add this formatting code, so that when it writes to the spreadsheet it will be in MM/dd/yyyy format.

Thanks
Corey

[madhuri.ru...@gmail.com]

Hi Corey,
I would like to know which connector are you using?
If I assume you are using "Google Spreadsheet > Add a row [v3]" connector then
in Input parameters of your connector's entry variable you must be writing code like this
<gsx:email>${P_initiator.login}</gsx:email>
<gsx:name>${P_initiator.name}</gsx:name>
<gsx:from>${from_date}</gsx:from>
<gsx:to>${to_date}</gsx:to>

(Code is just for your reference)

So here you will convert your from and to Date fields variable using functions
get_date(my_date,"MM/dd/yyyy") and then pass those in entry input variable.
For more details go to Connector description.
Please find the attachments.

Thanks,
Madhuri,Fujitsu

[Wakefield Admin]

Hi,

Yes I am using [Add A Row v3]

Here is my entry code

<gsx:name>${submitter_name}</gsx:name>

<gsx:submissiondate>${submission_date?default("")}</gsx:submissiondate>

<gsx:expensedate>${reimbursement_items.date_expense_occurred[P_index]?default("")}</gsx:expensedate>

<gsx:category>${reimbursement_items.reimbursement_category[P_index]?default("")}</gsx:category>

<gsx:amount>${reimbursement_items.cost[P_index]?default("")}</gsx:amount>

<gsx:approver>${who_approved_this_purchase?default("Other")}</gsx:approver>

<gsx:description>${reimbursement_items.reimbursement_item_descr[P_index]?default("")}</gsx:description>

<gsx:checkrequired>${reimbursement_check_required?default("No")}</gsx:checkrequired>

<gsx:comments>${comments?default("")}</gsx:comments>

So are you saying I should add the following:

<gsx:name>${submitter_name}</gsx:name>

<gsx:submissiondate>get_date(${submission_date},"MM/dd/yyyy")</gsx:submissiondate>

<gsx:expensedate>get_date(${reimbursement_items.date_expense_occurred[P_index]})</gsx:expensedate>

<gsx:category>${reimbursement_items.reimbursement_category[P_index]?default("")}</gsx:category>

<gsx:amount>${reimbursement_items.cost[P_index]?default("")}</gsx:amount>

<gsx:approver>${who_approved_this_purchase?default("Other")}</gsx:approver>

<gsx:description>${reimbursement_items.reimbursement_item_descr[P_index]?default("")}</gsx:description>

<gsx:checkrequired>${reimbursement_check_required?default("No")}</gsx:checkrequired>

<gsx:comments>${comments?default("")}</gsx:comments>

[Dimitri MELCHIOR Pro]

Hi You should do it that way :

<gsx:name>${submitter_name}</gsx:name>

<gsx:submissiondate>${get_date(submission_date,"MM/dd/yyyy")}</gsx:submissiondate>

<gsx:expensedate>${get_date(reimbursement_items.date_expense_occurred[P_index])}</gsx:expensedate>

<gsx:category>${reimbursement_items.reimbursement_category[P_index]?default("")}</gsx:category>

<gsx:amount>${reimbursement_items.cost[P_index]?default("")}</gsx:amount>

<gsx:approver>${who_approved_this_purchase?default("Other")}</gsx:approver>

<gsx:description>${reimbursement_items.reimbursement_item_descr[P_index]?default("")}</gsx:description>

<gsx:checkrequired>${reimbursement_check_required?default("No")}</gsx:checkrequired>

<gsx:comments>${comments?default("")}</gsx:comments>

Best regards

--

--

Dimitri MELCHIOR

PreSales Consultant

Contact: dmel...@runmyprocess.com

Tel: +33(0)1 75 77 51 78

Mobile : +33(0)6 52 70 89 82

Website: Fujitsu RunMyProcess

     

Fujitsu RunMyProcess user? Please add a review on GoogleApps Marketplace

Afin de contribuer au respect de l'environnement, merci de n'imprimer ce message qu'en cas de nécessité.
Be environmentally friendly: do not print this email unless it is entirely necessary.

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CADxZ%2BDBHNsL84%3D4PLb7vLnz_7f%3D-xe1_Wymk1tii%2B8O%3D1M4zsQ%40mail.gmail.com.

For more options, visit https://groups.google.com/a/runmyprocess.com/groups/opt_out.

[Wakefield Admin]

Thanks that worked.

You received this message because you are subscribed to a topic in the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/a/runmyprocess.com/d/topic/supportforum/CXF5_6v5D94/unsubscribe.
To unsubscribe from this group and all its topics, send an email to supportforum...@runmyprocess.com.

To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CAED7vk0y7Q52zcYpAjxkfpTEpS8eKHFdTfDd5SkByy4V0q2xug%40mail.gmail.com.