Date

[smilingjohn]

HI All ,

Please find the attachment of the qwv file .

I have a field called date .

I want to create a field which has 45 days and one more field of 120 days ...

How can i achieve this ?

Tahnks in advance

[Anil_Babu_Samineni]

How you are expecting?

[smilingjohn]

Hi Anil,

I want to it in a variable ...or in a filter

[Anil_Babu_Samineni]

Still not understandable. But for a while try these?

=If(Day(Date) <= 45, Dual('45 Days',1), If(Date(Date)<=120, Dual('120 Days',2)))

OR

=If(Day(Date)>= 0 and Day(Date) <= 45, '45 Days', If(Day(Date) >=46 and Day(Date) <= 120, '120 Days'))

[prma7799 · Accepted solution]

Like this???