nathra
asked on
CR Specific date with current year..
I need to create a field in CR which will produce a specific day of the year for the current year.
Example:
For this year the date might be 3/31/2013 but, when field is chosen next year, it needs to produce 3/31/2014.
I can create a field pretty easy to produce a specific date but I need to have the current year.
Hope that makes sense.
Thanks.
Example:
For this year the date might be 3/31/2013 but, when field is chosen next year, it needs to produce 3/31/2014.
I can create a field pretty easy to produce a specific date but I need to have the current year.
Hope that makes sense.
Thanks.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Think I just figured it out.
Date (year(Currentdate), 3, 31) produces the date I need.
Going to do some testing and make sure it will work.
I'll still give you credit though for helping me out with it.
Date (year(Currentdate), 3, 31) produces the date I need.
Going to do some testing and make sure it will work.
I'll still give you credit though for helping me out with it.
ASKER
Though helpful in finally finding an answer peter57r didn't really answer my issue and I was able to find the answer.
ASKER