InfoPath Dev

Used the current() formula to solve the problem thanks clay....it took a while but i got there

yeah i have a rule in place that when you select the date from the date picker it populates the fields but i need this for every row of the repeating table however i need individual numbers in every row so for e.g if they select 03/13/2008 it fills the field with qtr = 1 week =3 fiscal year =2008 then when i insert the next row if they select ...

  Thanks for that Clay but got things sorted by doing the following. I used the SQL CONVERT function to change the datetime format of the date in the Fiscal database in EDIT SQL on the connections wizard. I converted using the following CONVERT(varchar(10), Perioddate, 120) this converted the date from 14/03/2008 00:00:00 to ...

Hey all, First time poster long time reader.....I'm developing a capacity planning tool for MS and the date ISO that infopath submits to SQL is YYYY-MM-DD and i'm querying a fiscal year database that will allow me to enter a date from a date picker and return the month, week in the month, fiscal year and quarter. However the date format ...