https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/122288.aspxThu, 23 Jan 2020 16:07:31 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122288granDelimiter0https://www.infopathdev.com:443/forums/thread/122288.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122288Thanks Hilary, I see now that SharePoint makes it easy to add months to a date, and integrates it even for leap years in a calculated column: =DATE(YEAR(originalDate),MONTH(originalDate)+6,DAY(originalDate)) More on formulas at: https://docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/bb862071(v%3Doffice.14)#date-and-time-formulas. I wouldn't have found it without your forum to think out loud in.https://www.infopathdev.com:443/forums/thread/122287.aspxThu, 23 Jan 2020 15:36:56 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122287Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122287.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122287Dates are formatted yyyy-mm-dd in XML. Date time fields are formatted yyyy-mm-ddTHH:MM:SS. So if you are populating a date field, you'd use a concat formula to put your numbers in, separated by hyphens, like 2020-01-23. If you need a date time, because your field is a date time field, you can use 0s for the time, like 2020-01-23T00:00:00.https://www.infopathdev.com:443/forums/thread/122286.aspxThu, 23 Jan 2020 02:52:10 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122286granDelimiter0https://www.infopathdev.com:443/forums/thread/122286.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122286Update: I got extracting year (and month) as numbers: YEAR(dateField), leaving datatype as number. After I do my math, how do I insert the new number into a date field?https://www.infopathdev.com:443/forums/thread/122284.aspxWed, 22 Jan 2020 23:28:07 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122284granDelimiter0https://www.infopathdev.com:443/forums/thread/122284.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122284Hi, Here's a question that should be fun. I want to set a date field to a date 6 months in the future. I see posts about subtracting date/times that look extremely hard and complicated. I only need the number of months. I suppose it will involve extracting the year and the month separately and using a formula. Does the extration have to be to txt? (numbers might be more useful) If so, can I convert them back to numbers? Has anyone done this? Thanks,