date manipulation crashing when month is feb

[BT454]

Hi all,
This piece of code works for any month, except feb (i..e if the @dateadd determines any month other than feb, it will correctly return the requested date string. But for Feb it returns "?". And unfortunately, Feb is the month I need to assign the string to. Any thoughts?
Thanks!
Bob

Code: Select all

close @wf wfcreate(wf=test) m 2016 2016 !dom=@datepart(@dateval(@date),"dd") if !dom > 10 then %enddate = @datestr(@dateadd(@dateval(@date),-2,"mm"),"yyyy") statusline check ok else %enddate = @datestr(@dateadd(@dateval(@date),-3,"mm"),"mm/dd/yyyy") statusline check bad endif show %enddate

[BT454]

Ah... I bet it's because it's the 29th, and feb only has 28 days this year....

[BT454]

Is there a way to code a string that returns the first day of the month instead of the current day? I'm playing around with @datefloor but I can't seem to pass the value to a string or scalar.
Thanks!
Bob

[EViews Gareth]

Combination of @datestring and @datefloor