Converting date as string on web

HCL Domino Domino Forum
1

i want to convert date as string for comparison

view selection formula for comparison:

SELECT ((Form = “FrmTravel”) & ((Fromdate<=@Text(today)) & (@Text(today)<=Todate)) )

today field contains formula : @Text (@Date(@Now))

todate contains formula : @TextToTime (@Text (Todate))

pls suggest as i want to get all document which contains current date in either fromdate field or todate field.

2

Subject: converting date as string on web

Why not leave out the @TextToTime in the second formula? It seems to me that you will then in both cases you end up with a text.

3

Subject: converting date as string on web

We tried using @text but it is not working