first day of the month

[#1]

I like to get the first day of the month whenever I selected any day within that month. I think this would require set operation formula. I cant get the set formular right. I have the following data structure dte and dtemonth.

dte is bacically date and dtemonth is month and year (MMYYYY).

Bascially if I select 1/5/09 the formula should return 1/1/09. If I select 2/20/09 the formular should return 2/1/09

[#2]

hi,

Try

DATE#(01&dtemonth,'DDMMYYYY')

or

try monthsStart in conjunction with dte (i'm not aware what date format you using)

Hope that helps

Best regards

Michael

[Anonymous]

monthstart(dte)