You are viewing limited content. For full access, please sign in.

Question

Question

Saving to the repository

asked on December 8, 2017

Hi

It’s possible to use date formats so we can use only the year or the month as path when we save to the repository?

 

Best regards

0 0

Answer

SELECTED ANSWER
replied on December 8, 2017 Show version history

Ricardo,

We use fiscal year when we save to the repository so that we can look under 2017 and see everything saved for that year.  I am not sure if this is what you are looking for but here is what we do.

I always put a date field at the top of every form using Date as the field name and current_date as the Default value.

I add a single line field and call it Fiscal_Year.  Our fiscal year starts on July 1st.  So in the advanced tab I put in this formula:

=IF(Date>DATE(YEAR(Date),7,1),YEAR(Date)+1,YEAR(Date))

This will put the year in that field and you can call that variable whenever saving the form.

If you are wanting the calendar year instead of a fiscal year, then you can put something like this:

=YEAR(Date)  Which will give you the current dates year and again you can use the variable to save in the repository

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.