Date Issue

[rathnam_qv]

Hi All,

i have a date field.my requirement is to create two vriables...From and To.

The From  variable should contain the dates like: if the current date is >10 then it should show the dates from the start date of the current month to current date otherwise it should show the dates from the start date of prevoius month to current date.

Can anyone help me out!!

Regards,

Smiley.

[senpradip007]

Try like:

vFromDate = If(Day(Date)>10, MonthStart(Date), AddMonths(MonthStart(Date), -1))

vToDate = Date

[rathnam_qv]

Hi Pradip,

thanks for your reply!!

i have data for 2012,2013 and 2014.

and i have two input fields From ,To--->in From field i want to show dates from jul/01/2014 to till date.
how to do that...helpme out!!

Regards,

Smiley.