Get all the dates from each day of a week

[Peter_Y]

I need a VI that gives me the dates of the week. I am using a Month Calender to look at a database and fill two different graphs with values from that database. One graph looks at the values of the specific day I choose in the Calender but the other graph looks at all the days of that week. To build that SQL query I need to have all the dates of that week.

I could build a function if I knew the first and last date of the week. Anyone know an easy way to do this?

[tst · Accepted solution]

Use the Second to Date/Time primitive to convert your day to a time cluster. One of the elements in the cluster is day of week which should allow you to easily find the end of the week (you can add 2 days and convert back or add 2 with the d unit to the original timestamp).

[Peter_Y]

Thanks that works. Tried to just change day of week but of course that didn't work because day of week, day of month and day for year has to be correct.

[Peter_Y]

Oh nice Labview understands that Day of year -1 is the last day of previous year. Saves me a lot of time.