Make date using GetFieldSelections

[#1]

Hi all

Can i use GetFieldSelections of Year, month and day in makedate function like

vselecteddate= makedate(GetFieldSelections(year),GetFieldSelections(month),GetFieldSelections(day))

if not how can i get the selected year,month and day as a date?

waiting for your answers.

Thanks in advance.

Bhavya

[its_anandrjs · Accepted solution]

Possible click Ctrl + Alt + V and in the variables Overview

Make a variable like

vselecteddate =makedate(GetFieldSelections(Year),GetFieldSelections(NumMonth),GetFieldSelections(Day) )

Note:- Month field will be Number month values.

[#3]

Thank you Anand Chouhan

can i use variables instead of GetFieldSelections in makedate

[#4]

you can use variables,not sure how your year,month,day list boxes setup, if user is able to select multiple values (ex:2010,2011) makedate wont work ...

[maxgro]

GetFieldSelections if you have one selected value

this (or some other aggr function) if you want also manage no selections or many selected values

=MakeDate(max(Year), MAX(NumMonth), max(Day))

[#6]

Thanks everyone for your answers

[its_anandrjs]

You are welcome Yes you can use variables but check which type of data in the fields you have and where you use makedate functions.