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
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
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